Call Shell to run a mailmerge from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dixie - 17 Aug 2006 04:33 GMT

When I use Call Shell ("C:\program files\Microsoft
Office\Office11\winword.exe" "f:\templates\RewardsLetter.dot")

to open Word with a mailmerge template, it actually opens the tempate itself
instead of creating a new .doc file to do the mailmerge to. Is there a way
around this?

dixie

Reply to this Message

Doug Robbins - Word MVP - 17 Aug 2006 11:44 GMT

See fellow MVP Albert Kallal's "MergeSingleWord" utility at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When I use Call Shell ("C:\program files\Microsoft
> Office\Office11\winword.exe" "f:\templates\RewardsLetter.dot")
[quoted text clipped - 4 lines]
>
> dixie

Reply to this Message