I know how to set up multiple mail merge using Excel as the data source but I was wondering if its possible to create a letter using only one cusomter/clients details.
To expand, bascially Ive got one Excel tab per client which has their name and address etc on (along with a whole host of other specific information) and I was wondering if it is possible to record/write a macro that when ran will open up a word document and insert the address etc fields.
Im looking at between 30-50 clients, anymore than that and I will be able to look at some of the commercial offerings out there but at the moment I need to build it myself to be as effecient as possible.
If its going to be a huge task then obviously I have the option to copy and paste the address and other fields into the document.
Thanks, Mark
To expand, bascially Ive got one Excel tab per client which has their name and address etc on (along with a whole host of other specific information) and I was wondering if it is possible to record/write a macro that when ran will open up a word document and insert the address etc fields.
Im looking at between 30-50 clients, anymore than that and I will be able to look at some of the commercial offerings out there but at the moment I need to build it myself to be as effecient as possible.
If its going to be a huge task then obviously I have the option to copy and paste the address and other fields into the document.
Thanks, Mark
