Re: Macro to open Word and Start Mail Merge
I am not a programmer.
I created a work around to this issue, creating a regular hyperlink to the document in one field, say 'A43' that linked to the .doc file.
Then I recorded a macro that clicked on that link and got this as a result:
Then I created a shape (button) over some text with a no-fill, no line format, and assigned the macro to it. That way I can incorporate the link into whatever macro I wish.
For me, this brings up the document, which already has the SQL Mail Merge source statement saved into it, so it requests to perform the sql statement each time I open the file.
This feature is exactly how I want it to be.