mail merge access

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

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

Mail merge - Access

resolvedResolved · Low Priority · Version 2003

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?

Edited on Mon 14 Apr 2008, 15:39

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.


 

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips


Server loaded in 0.09 secs.