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

ms access courses in london - mail merge

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access courses in london - Mail merge

ms access courses in london - Mail merge

ResolvedVersion Standard

Amy has attended:
Access Advanced course

Mail merge

Is there a best way to use access for making letters to all your contacts? Would I need to download any extra software to help with this? (someone mentioned '4TOPS' to me..?)

Thank you

Amy

RE: Mail merge

Mail merge in word works well. The basic process is:

1.Write the letter in word.
2.Create or identify the database and fields that contain the data you want to merge to the letter (Name, address, other particulars).
3. Start the mail merge wizard, and follow all the steps.
4. Output the merge to a new doument, and process as required.

I would suggest reading a bit on Mail Merge in MS Word if you have never used it before. Feel free to ask questions here as you go through the process.

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



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.