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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read email body and move values to excel sheet 0
How to export table from outlook into ms access table? 0
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Copy Range of Cells from Excel 1
Copy a range from Excel to Oulook MailItem's body as Bitmap 8
Paste cells from Excel into message body 1
Range for Body of E-Mail 1
Excel Send Lotus Notes Mails With VBA Macro Excel 0

Back
Top