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

access mail

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

Access 2007 - mail merge

ResolvedVersion 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:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.