Another Mail Merge question...

[eclipse33]

Hi,

I am opening a mail merge document from a button in Access. I created the mail merge document in Access and used a pre-built query as the data source for the mail merge. The query has two parameters passed to it...starting date and ending date that are taken from two text fields on the form.

Here is the code of on the button click

newWordFile = "C:\Lans\ConfirmationLetter1"
retValue = Shell("C:\Program Files\Microsoft Office\Office\WINWORD.EXE " & newWordFile, 1)


Ok...now the mail merge works fine on my local machine but if I copy the database and the word document (same folder) to another workstation....I get a "Can't find Data Source" error for the word doc.

Anyone know why?

Thanks
eclipse33

 

[Guest_imported]

The path for the file is probably not correct anymore. When you move the files the location C:\Lans\ConfirmationLetter1 isn't correct.

 

[eclipse33]

Hey Jim

Why? I created a folder with the same name on the workstation?