MailMerge Macro Problem

[SimonFinn]

Hi Guys

Im modifying a macro written by someone else which uses mail merge. they where using the default path (My Docs), but it seems to not run on my machine, which may be the conversion from win 98 to 2k

Im not used to macros so this will proberbly be a silly mestake on my behalf, ive changed the path to:

WINWORD.EXE"C:\MailMerge\MailMerge.doc

but it is still having probs

thanks Si

 

[SkipVought]

Hi,
Your path does not look correct.

Try copying the Address from your Windows Exploring window. Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SimonFinn]

Hi Skip

Yep the path is correct, my mailmerge docs are stored in:

C:\MailMerge
and the document is: MailMerge.Doc

Or is the format that ive written it in wrong?

Thanks Si

 

[SkipVought]

Have you checked your macro security. If it's High, your macros will not run. Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SimonFinn]

Macros security is set to low:

The macro runs, but i get the error:

"Microsoft access cant invoke the application using the RunApp action.
The path to the application is invalid, or a component of the application is missing.
Check the path in Windows Explorer or File Manager"

any ideas (sorry should have posted the error before)

Thanks Si

 

[SkipVought]

Where is the application that you are running ie where is the code? It should be either in an active document or your document template. Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SimonFinn]

Hi Skip

Sorry about the delay:

The code: WINWORD.EXE"C:\MailMerge\MailMerge.doc

is in access

Is that what u wanted to know?

Thanks Si

 

[SkipVought]

I am not Access guru. You might need to go to the Access forum. But...

WINWORD.EXE"C:\MailMerge\MailMerge.doc

just does not look quite right -- just a gut reaction.

C:\MailMerge\MailMerge.doc

would seem more like it. (???) Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com