ms access courses in london - Mail merge

The UK's most regular instructor-led training courses.
Training information: ms access courses in london · Microsoft.access.courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Mail merge

Amy has attended:
Access Advanced course

by - delegate Amy [6 posts] (2007 Feb 2 Fri, 13:59) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	3	book now	£210	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
2003	2008 Oct 7 Tue	Southwark	6	book now	£193	£215
Full Schedule: See all 72 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Mail merge

by - trainer Richard platinum contributer [788 posts] (2007 Feb 6 Tue, 09:23) Reply

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.

· Microsoft Access 2007: New Features
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Innovation with Microsoft Access
· Why consider Access Visual Basic training?
· Want to Become the Office Hero? MS Project Training Could be the Answer

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips