|
Subject:
|
Export Excel data to an Outlook email
|
|
Posted By:
|
justin353715
|
Post Date:
|
10/17/2006 12:37:42 PM
|
I'm trying to export rows of information to an Outlook email. Currently I'm able to put each row of information into a separate email. However, I may have several rows that pertain to one company. What I want to do is put all rows pertaining to a specific company into one email.
My column headings are: Agency, Company, Town, SalesPerson, Time, Code, Product, Date, Len
My email is going to be formatted like this:
Agency: ...
Company: ...
Time, Date, Town, Len:
...
...
...
The ... represents the data i'm pulling from the Excel worksheet.
I assume I'll need some sort of loop and array to do this. I'm not familar with VBA so any tips, help is much appreciated.
Thank you.
|
|
