I'm trying to add an image into an email in vba. I've inserted the image into a sheet as I couldn't get the file location method to work.
Here's my code for the relevant section in the email body:
EmailBody = HelperSheet.Shapes.Range(Array("Picture 2"))
It's highlighting the whole row and saying Object required but I'm not sure what exactly it means (I'm really new to vba).
Does anybody know what I'm doing wrong?
Normally, I do not respond to posts that do not contain a sample workbook. I will leave you with these. These are two modules. It is up to you to write the code to feed the appropriate parameters to the Mailer subroutine.
The arguments are explained in the comments of the ModMailerMain module.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks