Mail merge

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

Resolved · Low Priority · Version 2003

3 posts

ReplyWed 20 May 2009, 14:04Delegate Dania said...

Dania has attended:
Access Introduction course
Access Intermediate course

Mail merge

How do I mailmerge a table into a word document? For example, I am writing a letter and want to autimically enter the addresses.

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

870 posts

ReplyFri 22 May 2009, 13:34Trainer Rajeev said...

RE: Mail merge

Dear Dania

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

I am hoping that you are familiar with the steps that are involved with mail Merge in MS Word.

When you get to the step where you have to choose the data source document you simply choose browse to locate your database file.

In the select data source window you click on the drop down arrow for the file of type and choose All files. Choose the folder where the database file is situated.

Select the database. If you have more than one table then it should allow you to select the table of your own choice.

Once you have selected eth table or query as your data source you should be able to select the fields from the Insert Merge fields!!

I know that you are doing Access Intermediate course on 2 Jun 2009 with me. If you cannot get the mail merge to work then I should be able to explain this to you on that day!!

I hope this has answered your query.

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
MCT

Fri 29 May 2009: Automatically marked as resolved.

· Microsoft Access: Unleash the True Potential Today
· When To Use Access, When To Use Excel
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· Material covered on a Microsoft Access Course
· Have You Ever Wanted To Create A Combo Control On An Access Form?

Please browse our web site to find out more about
microsoft access training course and other Microsoft training courses.

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Mail merge

Mail merge

RE: Mail merge

Related articles

Access tip:

Hide Access Tables