View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OM[_2_] OM[_2_] is offline
external usenet poster
 
Posts: 3
Default 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