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

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

Hello!

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

Thanx!

Motorhead is offline   Reply With Quote
Old 03-04-2002, 06:58 PM   #2
doulostheou
Newly Registered User
 
doulostheou's Avatar
 
Join Date: Feb 2002
Location: St. Louis, MO
Posts: 314
Thanks: 1
Thanked 1 Time in 1 Post
doulostheou
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
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 03:41 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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