Quote:
|
Originally Posted by Clive Long Unfortunately this may be the only way - surely what I am trying to do isn't very novel or sophisticated?
CRL |
Ok first of all if you ask for help you need to state all the facts
500 contacts makes it a lot more complex.
The solution you are using isn't really cut out for that number of documents.
I would be looking at some kind of script. The contacts would have to be exported out in to an Excel file or comma delimited file for the script to read. The script would then carry out the mail merge in to Word using a macro or other script language, this would then call each page, create the PDF and then attach the pdf to an email message - probably sent out via a command line emailer such as "The Blat".
Inmac/PCWB do something similar with their quotes - key in the information at one end and the client gets an email with the attachment at the other.
Depending on how often this task has to be carried out will depend on whether it is worth getting an Office developer to create something for you.