Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

Thread Tools Rate Thread Display Modes
Old 03-01-2002, 02:10 AM   #1
Junior Member
Join Date: Feb 2002
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Mail Merge One Record


Does anybody knows how to mail merge just one record of a table? (only the first for example).


Motorhead is offline   Reply With Quote
Old 03-04-2002, 06:58 PM   #2
Newly Registered User
doulostheou's Avatar
Join Date: Feb 2002
Location: St. Louis, MO
Posts: 314
Thanks: 1
Thanked 1 Time in 1 Post
Send a message via Yahoo to doulostheou
What I have done is made a form where the user selects the record he wants to MailMerge. They go to the appropriate number and the Word Document uses a query for the Mail Merge. That query uses the form in its criteria.

For instance, lets say your unique identifier is called "ID" and your form is named "FindRecord." The FindRecord form would have a field for "ID" and then in the query you would have the criteria for the ID field set to: Forms!FindRecord!ID.

I then place a button on the FindRecord form which opens the appropriate word document (The only way I know to do this is use: FollowHyperlink "C:/AppropriateLocation.doc").

When the Word document opens, it will only pull up the records in the query (which will only be the record displayed on the form).
doulostheou is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

All times are GMT -8. The time now is 10:14 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World