General Mail Merge Query
Hi everyone, I have a quick 'is it possible' question
At my current job we have order info in a database and each week we run a report which extracts something similar to the following into an excel spreadsheet. It shows what each customer has bought
CustomerID Customer Name Order Cost
ABCD1 Acme ã200
DEFG Widget ã150
ABCD1 Acme ã120
Basically, we then generate letters per line using mail merge but this is wasteful if the same customer has made multiple orders. Is there a simple way to get word to recognise multiple orders and create a line in the document for each item ordered? For example, using the data above, the end result would be 1 letter for Acme with two order items inserted instead of 2 seperate letters with one item each. Can anyone suggest a few basic steps for this or even advise how it might be done better (get it in access and use SQL to join then do something else?).
I really dont want to take up too much of anyones time, just wondering if anyone has done this before using VBA code or if it is going to be a nightmare. I have coded Outlook VBA code before so I should be capable of coding something quite nice but advice on a more elegant solution if available would be great.
Cheers
Iain
|