How do you mail merge with Access

Dear Orla

Thank you for attending Access Introduction course. I hope you enjoyed the course and benefited from it.

It is quite straight forward to do mail merge from Access. I am hoping that you are familiar with mail merge in MS Word.


Please follow these steps:

Open the table that contains the data to be merged. (If the fields are coming from various tabels then best thing is to creae a query and then follow the below mentioned steps.)

Choose Tools > Office Links > Merge it with MS Word

Microsoft Mail Merge wizard will ask you if you already have a letter that you want to merge or do you want to create a new document.

Choose the relevant option and MS Word will open with the Mail merge activated.

It would have added the Access Table/Query as the data source for you.

Just place the fileds in their relevant places and compltee the mail merge as you normally would in MS Word.

I hope this helps. If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!


Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007