I am hoping to find an answer to this here, as I have not found one (that works) elsewhere.
I have a sheet for landscape quality inspections which I would like to email to my customers. It would be easy enough to save and send a pdf attachment and copy/paste the email address from cell A9 into the "TO" field, but my challenges are as follows:
1. Customers aren't likely to open/download attachments on their mobile devices, so I would like to paste the active sheet as an image in the body of the email.
2. There is a company logo that is part of the form and needs to be part of the image that is pasted into the body of the email.
3. Other employees have limited computer skills, so I would like to have them simply fill in the form and push a button with assigned macro to create a redy-to-send email with the email address (value in cell A9) and subject of "property evaluation" already filled in.
4. The email would begin with "Dear (value from cell J7 is customer name), (skip two lines) Below is a copy of your most recent property evaluation. Plese let me know if you have any questions." Then, the image of the sheet would appear below that text.
Bookmarks