Posts by awc

    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:

        Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

    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.