How do I merge Access data to a Word document?

[Guest]

I'm trying to use a Word template for name badges and have all of the data in
Access. Everytime I connect to the database it puts me back in Letters Doc
Type for the data merge. When I change it to Normal Word Document it doesn't
give me the option to merge fields from the database to the fields on the
document. It doesn't seem any different really from a mail merge, but I
can't seem to get it to work.

 

[Anne Troy]

Tell your mail merge to use the Active Document if you already have the name
badges document open. Don't change it back to normal document--that means
you're making it a "non-merge" document.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

Thank you Anne.

This is my first attempt at doing something like this and I may be doing
something else wrong. I have inserted fields in the name badge template
where I need information from Access. Is that the correct way to do it?
Also when I look at the letter merge it has a set of items that it knows
about and I'm looking at things like Troop # that don't show up in that list
of items.

 

[Anne Troy]

Mail merge is so difficult to troubleshoot like this. If you like, send your
file to anne@ the 2nd website in my signature.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Suzanne S. Barnhill]

See http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm. If you're
doing name badges using Avery or similar stock, start in Tools | Envelopes
and Labels, selecting the appropriate label definition, then New Document.
Then choose a Labels merge type.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

Thanks to both Suzanne and Anne I was able to get the info I needed to
complete this. The only item I still haven't figured out how to do is a
nested if block. So I "cheated" and sorted the groups in a query and created
a different static item on the badge for each different group rather than
having it be variable. Unfortunately I ran out of time so I can't work on it
anymore for this project.