ms access courses in london - Mail merge

Resolved · Low Priority · Version Standard

Fri 2 Feb 2007, 13:59 Delegate Amy said...

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

Tue 6 Feb 2007, 09:23 Trainer Richard said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips