Revolution1200
Programmer
Hi All,
We have multiple word document templates that we use for merging purposes - this is due to people being assigned different letters in the database depending on processing.
We need to merge these into one final document for mailing.
The data for this comes from an excel spreadsheet which has the following format
Field 1 - Letter Identifier to use
Field 2 - Title
Field 3 - Initials
Field 4 - Surname
Field 5 - Address details
My current solution involves opening all the templates required
Open a new document to merge to
For each record
Select the template Required
Copy template to new document
Change each merge field to the data from the record
Add a page break
Next Record
The problem is that this is very slow, can anyone tell me if there is a way to do this using the mail merge within word?
Thanks
Stuart
We have multiple word document templates that we use for merging purposes - this is due to people being assigned different letters in the database depending on processing.
We need to merge these into one final document for mailing.
The data for this comes from an excel spreadsheet which has the following format
Field 1 - Letter Identifier to use
Field 2 - Title
Field 3 - Initials
Field 4 - Surname
Field 5 - Address details
My current solution involves opening all the templates required
Open a new document to merge to
For each record
Select the template Required
Copy template to new document
Change each merge field to the data from the record
Add a page break
Next Record
The problem is that this is very slow, can anyone tell me if there is a way to do this using the mail merge within word?
Thanks
Stuart