Hi, i am trying to open up a document, that is already mailmerged with the correct data (and fields).
I have written the letter, and added the relevant table source, along with the required fields, and it works. once the mail merge button is pressed, then all a letter is developed for all of the related records.
i then tried to open that by putting a command button in a form and a report, and in the form, only the program oopens.
I then tried using a macro, "C:\Program Files\Microsoft Office\OFFICE11\Winword.exe" "C:\Documents and Settings\Masum.SHOKOTH\My Documents\PaymentOverdue.doc" "C:\Documents and Settings\Masum.SHOKOTH\My Documents\ProvidePaymentOverdue".
This opens up the file, but it then says error, and a blank document is opened.
Is it possible to have a button or a link that opens up the document, and is already mail-merged (without the user havin to do it themselves)
and can it be placed inside a report, or will i have to use a form.