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

access mail merge

ResolvedVersion 2003

Nanna has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Project Intro Intermediate course

Access Mail Merge

It was mentioned at some point that Access can be used for mailings using mail merge. Do the addresses have to be exported to Word, or is there are mail merge option within access, please.
Thanks
Nanna

RE: Access Mail Merge

Hello Nanna

Thank you for your question.

The mail merge would be performed through Word. If you use the Mail Merge Wizard (Tools - Letters and Mailings - Mail Merge), this will take you through a step-by-step process for creating the merge.

At the third step (Select recipients) select the Use an existing list option, then click the Browse link to select the Access database that holds the recipients' names (these could be stored in a table or a query).

I hope this helps.

Kind regards
Amanda

RE: Access Mail Merge

Thank you Amanda
I just tried it out and it works!
Kind regards
Nanna

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

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.11 secs.