I have a document in which i am merging data from a database. each record merged from the database has a unique primary key.



After mail merging a record into the document. I would like to save the document with a particular filename/format (docname.primarykey.doc e.g. Meeting.0321.doc). Although, this can be done manually each time I merge data, it is time consuming and increases the possibility of the user making mistakes. Therefore, I would like this to happen automatically every time i print the document with merged record data (a record will only be printed once in a particular document).

I have a rough idea of how to solve this problem. This is by using vb script (creating a command button). But i cant seem to work out how to assign merged data (of a particular record and field) to a variable. this is because i've never really worked with merged data using VB. if i can do this i think ill be able to solve the rest.

I hope what i have explained above is clear enough. I thank you all very much in advance. Your help is appreciated.