Mail Merge Documents gets 1st record data

[vicky1362002]

Hello All,

I am using mail merge to get the data on a word document and open it up. I am using this code to get the document opened up with the data of a particular ID:

wks.MailMerge.DataSource.FindRecord Forms!Notice!Combo9, "ID"

The above code is a part of the code i am using for a button so that when i click that button i get the data on the word document of the same ID (on the form where i click the button)

It was working before, but all of a sudden it stopped working, now whenever i click the button to get the word document, it performs the merge but gets me the word document with the data of the 1st record .

for example, if the ID on the form is 10, the mail merge document gets the data of the ID=1, to solve it i need to do the merge again, but doing merge everyday doesn't sound good. It automatically merged the data for that particular ID yesterday, but today when i checked it again, it doesn't work. What could be the problem and where?

Hope you understood my problem.

Please feel free to post any questions if you have.

Thanks
Vik

 

[vicky1362002]

Is there anyone who can help me out with the above?

I would appreciate any help.

Thanks,
Vik