ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Transfer data from Excel Spreadsheet to Outlook (https://www.excelbanter.com/excel-programming/443320-transfer-data-excel-spreadsheet-outlook.html)

OM[_2_]

Transfer data from Excel Spreadsheet to Outlook
 
I have an Excel 2003 spreadsheet that I enter Hazard Reports into. It
has a section that I want to copy (as a picture) to the body of an
Outlook email. It also has a persons name, that I want in the "To"
section of the email, with the Subject "Hazard ######", with###### the
number of the Hazard Report, also from the spreadsheet.

How do I do this with VBA ?

Thanks in advance for any suggestions.

Rob


All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com