Merging particular data from access DB into Word

[Georgie]

Hi!

I have an access database that contains both community groups and service
providers. This database is used as a source for mail merges in Word. I would
like to be able to specify to Word to only insert community group entries or
service provider entries, so that I can tailor letters to these two types of
entries. Can someone please let me know what i need to tell Word to be able
to do this. I haven't set up fields in Access yet that specify which is
which.

Thank you!

Georgie

 

[pietlinden]

Hi!

I have an access database that contains both community groups and service
providers. This database is used as a source for mail merges in Word. I would
like to be able to specify to Word to only insert community group entriesor
service provider entries, so that I can tailor letters to these two typesof
entries. Can someone please let me know what i need to tell Word to be able
to do this. I haven't set up fields in Access yet that specify which is
which.

Thank you!

Georgie

You don't tell Word as much as you use two different queries to return
the records you want - either community groups or service providers.
Then if you have to, tell Word to open a different template based on
which group you are sending to. You could always grab Albert Kallal's
"Super Easy Word Merge" Can't make it much easier than that!

http://www.members.shaw.ca/AlbertKallal/msaccess/WordMerge97.zip