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

mail merge access

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

Mail merge - Access

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

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

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.