Create Table/columns in Outlook for Blast Email of Invoices

[SamHink123]

Hello,

I'm trying to create a macro to send off a large number of emails to customers for invoices overdue and that are coming due shortly.

I'm currently in the process of creating a table or columns within the body of an Outlook email to pull in the data related to the invoices and am not sure how to get started.

The table should consist of 5 columns (Invoice #, Purchase Order #, Invoice Date, Due Date, & Invoice Amount) with a varying number of rows based on the number of invoices for that specific customer with a total row for invoice amount.

Each customer could have multiple open invoices and I'm trying to incorporate being able to retrieve all the information for each customer into one table so I only have to send one email instead of sending that customer x number of emails because they have multiple invoices, but I'm not sure how to include that into the table.

The excel sheet data is set up as so:
COL A - Customer #
COL B - Customer Name
COL C - Purchase Order #
COL D - Invoice #
COL E - Invoice Date
COL F - Due Date
COL G - Invoice Amount

So, for each repetition of the same customer in COL A (or COL B), the 5 criterion for the table from above would then be added to the rows for each invoice.

Does that make sense?

[jaslake]

Hi Sam

Welcome to the Forum!!

See this link...it can be adapted to do as you describe.
http://www.rondebruin.nl/win/s1/outlook/bmail2.htm