access mail

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007 - mail merge

Access 2007 - mail merge

resolvedResolved · Low Priority · Version 2007

Nancy has attended:
Access Introduction course
Access Intermediate course

Access 2007 - mail merge

How do you prepare a mail merge of labels from a query?

RE: Access 2007 - mail merge

Dear Nancy

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.
It is possible to use the query as data source for your mail merge but unfortunately it is not very straight forward. You have to do few settings. I assume you are using Access and Word 2007 so the following instructions are for this version only:
1. Before you do any exporting you need t open Word 2007 and then choose the Office Button and then choose Word Options

2. Choose the advanced tab on the left hand pane and then scroll down until you see the general category

3. Ensure that you check the option that says

Mon 19 Jan 2009: Automatically marked as resolved.


 

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips


Server loaded in 0.08 secs.