Macro needed to copy rows from spreadsheet to email as image (not as attachment)

c.woodward2012

New member
Joined
Oct 2, 2015
Messages
1
Reaction score
0
Points
0
Hi there,
I am pretty new to all this so please bear with me.

I have a pretty simple excel spreadsheet which consists of 9 columns. One of these columns is a check box. I would like a macro that, when that check box is ticked, I can press a button on the sheet and all the rows where the checkbox is ticked (but only data in columns B to I) are copied as an image and pasted into a new email message, not as an attachment to that email but as an image displayed in the email body. I do hope you can help.

Many thanks
 
There are two types of checkbox, if you right-click one type it will have 'Assign macro' included in the context menu, the other type won't. Which type are yours?
Also, what email application are you using?
And if you could link to a small workbook somewhere in the cloud that would save us trying to reproduce your layout and guessing wrongly, especially about how a checkbox islonked to a row (besides position), that would help.
 
Last edited:
Back
Top