Transfer Range of Cells from Excel to Outlook Message Body

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I do the above? I currently have the range (rngCells) and message
(mlMessage), but I'm at a loss as to how to copy the cells from Excel and
paste them into the body of the message...any help would be greatly
appreciated!

Thanks!
Jake
 
Iterate the range of cells and get the contents of each cell into a string
variable (or numeric or whatever depending on the cell contents). Then use
the .Body property of the Outlook mail item. See
http://www.outlookcode.com/d/customimport.htm for some more information and
code sample references.
 
Back
Top