If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Envelopes
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!
|
#2
|
|||
|
|||
Envelopes
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" wrote in message ... 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! |
#3
|
|||
|
|||
Envelopes
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. |
Thread Tools | |
Display Modes | |
|
|