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.