A.S. I post this question too at http://www.tek-tips.com (thread705-373071) & I’ll put a small post on Woody’s Access forum as well, as this is both an Access (how can I use variables when I automate Word by calling Word macro’s from Access) & Word problem (mail merge to seperate documents).
Hey,
Consider a Word main document & data file ready for ‘mail merge’. Word provides this feature BUT you can only produce one file at the time, even if you mail merge for all records … I can understand this is sufficient when all letters are print out ‘hard copy’. We want, however, a separate file for each record: it is a private letter which needs to be sent (also) by e-mail to each instance (in private). Also more in general however, when the mailing must be spread digitally, an X00 pages document with the relevant piece submerged somewhere inside it, is not an option.
How can this be done?
Some tedious (wrong?) web searching only revealed this tip: put the first paragraph in Header 1 style. Then, after mail merge, you can consider the result as some kind of main document of which you can save the parts as sub documents. (???)
Maybe this works in some cases, but in the mean while, I’m close to another solution that also might work (& better suited to our problem)…
I’m quite close, IF I can solve one problem (supposing there are no dragons left waiting behind the corner): how to provide a variable to a Word macro using automation, e.g. from within Access?
The rest of this post is some background about the progress I made to solve this. I hope I’m heading in the good direction
