Access Data to Word

[dmarsh61]

We have a database that contains our branch offices their printing devices and usage. An example of the data would be:
Office , Printer Model, Serial Number, Mono Count, Colour Count.
City A X123 1234 35 156
City A X123 2345 156 215
Town B V355 756A 12 12
City B V355 799H 1562 275

I receive this in an Excel spreadsheet each month and import it into a table in Access. There are multiple offices and each office can have multiple printers.
I would like to be able to do a mail merge where I can email each Office their usage, preferably in a table.
I am familiar with the Mail Merge in Word and have performed both paper and email merges. From what I have read, everyone is recommending a Directory to do the merge, but that just creates a list to print and I have not seen any information on how too email (or print a letter for that matter) that information out to each office.

Ultimately, using the above example, I would like to email out something like this:

Good Day <<Office>>,
Here is your monthly usage report:
Office , Printer Model, Serial Number, Mono Count, Colour Count.
City A X123 1234 35 156
City A X123 2345 156 215

If you have any........etc.

Does anyone have an idea or some code that may assist me in this endeavour?

Thanks,

David

 

[Uncle Gizmo]

Try this from Gina Whipp


Send eMail to Multiple Recipients…

 

[dmarsh61]

Thank you for the response. I tried the code below, modifying it to my specifications and it worked a bit. It produced an email for each record so if Office A had 7 printers and Office B had 5 printers, it created 12 email messages s, each with a pdf attachment showing all 12 printers.

What I was hoping for was 1 email per office, with an attachment (or in the body of the email) listing each printer in their office only with the usage.