Access to Word - Mail Merge Letter with multiple sections?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have implemented a cmdButton in Access that takes information (Name,
Address, Etc) from the current contact and merges it into a form letter. My
problem is that I have 8 different form letters where the only difference is
a customized page 2 of the letter. My thought is that if I could merge the
access information on Page 1 of the letter then somehow use vba code to
select the correct page two for the letter then, add the access data to page,
and when that finishes select the remainder of the letter it would be much
more efficient than having 8 different command buttons....
 
My thought is that if I could merge the
access information on Page 1 of the letter then somehow use vba code to
select the correct page two for the letter then
Click to expand...

or, even better, use an IF field in the word document to hide the unwanted
page. Sometimes it's easier to screw a screw with a screwdriver than with a
spanner...


B Wishes


Tim F
 
Tim Ferguson said:
or, even better, use an IF field in the word document to hide the unwanted
page. Sometimes it's easier to screw a screw with a screwdriver than with a
spanner...


B Wishes


Tim F
Click to expand...
 
You might also consider using 4TOPS Word Link
(http://www.4tops.com/wordlink.htm). What you would do
then is have it generate one template, put the locations
of the fields where you want. Next create 7 variants of
that start template each for the different types of
letters. Then you can start a selection form to decide
which template to use (second toolbar button) and it will
create a new document based on the selcted template
filled with the data. No coding required!
Mark Uildriks, 4TOPS
 
Back
Top