Posts by awc

  • Macro to open Word and Start Mail Merge

    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:

    Code
    Range("A43").Select
    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.


    Simple.