I'm SO Close!

[andysgirl8800]

I could really use some help here! Apparently, completing a mail merge automation process is much more complicated than I originally thought. I have it doing absolutly everything I need it to do (open merge document, merge data, print, and close all in the background) but I am missing one critical but probably simple step. I want to merge just the CURRENT record only, not the entire database. I've read all 500+ posts concerning merging, but I'm still lost.

-how do I specify just the current record's information?
-do I need to create bookmarks, and how do I do this?
-how do I properly use the WHERE statement?

This may be the last thing I need to do with my database, if I can get it working right. Currently, it's trying to print all 883 records and takes about 10 minutes to run the command (probably because it's trying to pull all of the records instead of just one.) I will post my code, if you like. I know this is simple, but I can't work it out on my own. Please help me!

 

[MaximusArcher]

av u tried a seperate query based on the forms current record then hang the merge off this query?

 

[andysgirl8800]

I'm not sure how to do that...