Envelopes

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

Guest

I have just created my first Access data base and I need to print addresses on envelopes and letters. Can I use Access to do that, or will I still need to do this manually??? Thanks so much!
 
Access includes a Label Wizard to automate the process of printing address
labels. However, for letters you would probably be better off using a mail
merge in Word. Word can use the addresses you've stored in Access to print
mail-merge letters; just define a query on your database that specifies the
fields you want to use to build the name and address, and use Word's mail
merge features (select Tools > Letters and Mailings > Mail Merge...) to set
up your form letter to pull that data from Access.

--
Matt Lusher
Microsoft Corporation
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.

Kimberly@JCC said:
I have just created my first Access data base and I need to print
Click to expand...
addresses on envelopes and letters. Can I use Access to do that, or will I
still need to do this manually??? Thanks so much!
 
Access 97 is brilliant at this. I have used it for several
years now. The way to do it is to create a report which
you will print out the address on an envelope, and will
allow you to dress it up in all sorts of fancy ways eg
different colours and fonts.
This report is based on a parameter query where you type
in the ID of whatever name you want. Your printer might
offer different options from mine as well.
It is a bit complex, but worth it. I suggest you create
the parameter query first so that it will pick out the one
name and address first.
So create query first, then create report.
Let me know how you get on, and I will help.
 
Back
Top