467,868 Members | 1,316 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,868 developers. It's quick & easy.

Open mail merged document in a form/report

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.
Apr 19 '07 #1
  • viewed: 1152
2 Replies
Expert 2GB
Did you try the Shell command like:

shell ("application and file to be started")

Apr 23 '07 #2
Expert Mod 16PB
  • You will need to make sure that the document that you require (IE already merged) is what you open up.
  • It's possible to invoke this from within the module of a report, but I can't think why you'd want to or what you would want to trigger it with.
Apr 26 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.