How to Do a Mail Merge Using Access and Word
1. Make a database
- Blank database
- Table in Datasheet View
- Make a table by inputting or importing info.
- Title, First Name, Last Name, Dept, Plus 4 Code
2. Merge Database with Letter or Memo
- Open document that is memo or letter
- Tools
- Mail Merge
- Fields have to be established in the document where you want the person's
name to be.
- Title, space, First Name, space, Last Name
- Merge Dialog box: Merge to: printer
3. Make Envelopes
- Open Word document
- Tools
- Envelopes and Labels
- Envelopes tab
- Add to document
- Click where address will appear on enevelope; text box appears
- Tools
- Mail Merge
- Main Document
- Create
- Envelopes
- Active Window
- Data Source
- Open Data
- Files of Type: MS Access
- Set up Main Document
- insert merge fields
- Title, space, First Name, space, Last Name
- Merge to: Printer