Transfer Range of Cells from Excel to Outlook Message Body

J

Jake

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
 
K

Ken Slovak - [MVP - Outlook]

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.
 
Top