How do you use Access to create a mail merge?

[Susiq2]

I'm a relatively new and infrequent user of Access, but wasn't sure if this
should go to the New Users group.

I know how to do a mail merge in Word, but wondered if using Access would be
any improvement. At the moment, there are under 100 names, but each has an
"ID #". I'll need to print address labels without the ID #, and general
lists WITH the ID #.

I think both my Word and my Access are much older versions, 2000, or 2003
at the latest.

Please tell me if I should bother with Access, and if so, how to create my
info so that it can be mail merged onto labels and plain lists, later. I'll
be the main one maintaining the list, but others will see the printed
versions, and of course, the labels.

Thanks.

Susiq2

 

[KARL DEWEY]

I use Access database with Word mail merge. Data is loaded in Access and
pulled out using a query to select what you want and the Word document.

Word Mail-Merge---
Open a blank Word document, click on menu TOOLS - Letters and Mailings -
Mail Merge.

It opens an additional window on the right and has step-by-step instructions
and choices. You can also backup in the process.

Works fine for me.

 

[Peter's Software]

You can use the report wizard in Access to create labels. This would
seem to me to be a more direct way to do it if your data is already
stored in Access.

Hope this helps,

Peter De Baets
http://www.peterssoftware.com