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.

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


"dcg" wrote in message
...
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.

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" wrote:

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


"dcg" wrote in message
...
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.

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


"dcg" wrote in message
...
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" wrote:

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


"dcg" wrote in message
...
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.

See http://word.mvps.org/FAQs/MailMerge/...AMailMerge.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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"dcg" wrote in message
...
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.

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.


"Suzanne S. Barnhill" wrote:

See http://word.mvps.org/FAQs/MailMerge/...AMailMerge.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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"dcg" wrote in message
...
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.