Hi everyone, I'm desperately in need of help for this one! I can't seem to do it myself this time.
Basically, I want to have a button in my workbook that automatically creates en email in Outlook.
I want the subject and body of the email to be populated by text from a few ranges of the workbook as well as a table pasted as an image, and then I want the same workbook to attach itself to the email. The email recipients, cc, bcc, etc., will be left empty.
I'll attach the file I want to use to this post and I'll explain what I want the macro to do step by step:
- Create new email in Outlook, en empty message, without the user's signature
- Select and copy cell B6 from sheet "TEMPLATE EMAIL" and paste it to the subject of the email
- Select and copy the entire A column from sheet "TEMPLATE EMAIL" and paste it to the body of the email
- Select and copy the the entire range that only contains text from the table in sheet "TEMPLATE", leaving the empty rows out. I want to select the blue, green, black and grey headings and go down to select until the last line of text of this table.
- Select the 12th row of the email body and paste special as "Picture (Enhanced Metafile)" the previous table
- Insert the excel file to the email as an attachment
I will also attach a screenshot of how the email should look like in the end.
Actually it appears I can't attach anything here, so I'll just post a link to wetransfer, hope that's ok.
https://www.wetransfer.com/downloads...5101007/52b6ee
Thanks in advance!!
Bookmarks