Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Mail Merge

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Mail Merge

Resolved · Low Priority · Version 2003

Reply Fri 23 Jul 2010, 16:21Delegate Jonathan said...

Jonathan has attended:
Access Intermediate course
Access Advanced course

Mail Merge

I have a set of documents which have been mail merged from queries in a my database. When I open these .dot documents manually with the database open, they load up and link automatically to the query I have set them up with. I have created a button to open these word documents straight from the access database, but unfortunately the link between the word document and the database is lost so it only shows the first page of the first record and I have to re-link the word document to the database. Is there a way around this?

For upcoming training course dates see: Pricing & availability

Reply Thu 29 Jul 2010, 09:58Trainer Jacob said...

RE: Mail Merge

Hello Jonathan

Thanks for your post outlining what you are trying to do.

We are confident we can reach a solution for you but it is something that is beyond the bounds of the support forum.

The next stage will be to review all your associated files to create a scope of work with duration (currently we estimate half a day with some VBA code) and associated costs (trainer time will need to be allocated).

If you are interested in taking this further please reply to my email.

Kind regards

Jacob

Wed 4 Aug 2010: Automatically marked as resolved.

Access articles

· Microsoft Access: Unleash the True Potential Today
· How To Make One Combo Show Values Determined By Another Combo In Access
· The Benefits of Certified Microsoft Training in Access
· How To Import Data Easily Into Access 2010
· Three Myths About Microsoft Access

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

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips