access mail
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Thu 23 Oct 2008, 17:10Delegate Nancy said...

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?

For upcoming training course dates see: Pricing & availability

replyReply Mon 12 Jan 2009, 12:39Trainer Rajeev said...

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.

 

Please browse our web site to find out more about
access-training-courses and other Microsoft training courses.

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard