mail merge access
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 » Mail merge - Access

Mail merge - Access

resolvedResolved · Low Priority · Version 2003

replyReply Thu 10 Apr 2008, 15:53Delegate Ian said...

Ian has attended:
Access Introduction course

Mail merge - Access

Could anybody provide me with step-by-step guide explaining how to perform mail merge in Access?

For upcoming training course dates see: Pricing & availability

replyReply Mon 14 Apr 2008, 15:38 Edited on Mon 14 Apr 2008, 15:39Trainer Pete said...

RE: mail merge - Access

Hi Ian, Thank you for the post, in answer to your question, try this;
From the Access database window, select the table or query.
Note: to ensure smoother mail merging, check that the field names in the Access table or query are not longer than 20 characters and that they do not contain any special characters or spaces.
Choose Tools >Office Links > Merge It with Microsoft Office Word or select the option from the database toolbar: Merge It with Microsoft Office Word,.
Choose to link the data to an existing Word document (if you have created this already), and select the document from the saved location. Click OK.
With the Word document open, make any required alterations, and choose
Next: Write Your Letter; You will notice that the recipients are from an existing list (from the table or query selected in the database).
The Merge Letter opens in Microsoft Word, and uses the database table or query as the list of recipients.
You can now add the merge fields that are required to the document. Ensure that the Merge fields have been added to your mail merge letter.
Click Next: Preview your letters, and review the resulting merged letters:
Complete the mail merge and send the letters required to the printer
I hope that was what you were looking for; if so please click the Resolved link, best regards Pete.

 

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

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

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