98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Mail merge - Access
Mail merge - Access
Resolved · 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?
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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create calculated fields that work out your ageYou can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field |