locked
ACCESS TO WORD MAIL MERGE - is the following possible.. RRS feed

  • Question

  • Basically, I know how to create a normal mail merge already but now I am planning to code it in a different way. I was wondering if anyone knows how to do this/ has done this themselves.

    I want the user to click a macro in my database (As usual), then the coding will tell Access where to save the file. The user will be asked if they wish to use their template or a blank document (or there could be seperate macros for the two options). If the user wants to use their template access will automatically find the template and input details in the correct places. After this word will stay open so that the user can edit it and print it as needed.

    I am using Office 2010 just so you know...

    Any pointers or ideas would be great!

    Thanks

    Rebecca.

    Thursday, August 26, 2010 2:02 PM

Answers

  • See the following posted quite a while ago by Albert Kallal:

    Quote

    Actually, use my merge sample. it don't give that warning, and you don't
    have to change registiry stuff etc.

    The sample I have can be found here:
    http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

    What is nice/interesting about my sample is that is specially designed to
    enable ANY form with ONE LINE of code....

    Thus, each time you build a new form, you can word merge enable it with
    great ease.

    Make sure you read the instructions from above, and you should eventually
    get to the follwoing page
    http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


    Note that the merge can also use a query, and thus you don't have to merge
    just "one" record..

    After the merge occurs, you get a plain document WITHOUT any merge fields,
    and this allows the end user to save, edit, or even email the document
    (since the merge fields are gone after the merge occurs).

    Give the above a try…


    -- Albert D. Kallal    (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com


    unQuote

    -- Hope this helps.

    Doug Robbins - Word MVP,
    dkr[atsymbol]mvps[dot]org
    Posted via the Community Bridge

    "R_McCallan" wrote in message news:3823233b-0c55-47e8-9f4d-252d5d80409f@communitybridge.codeplex.com...

    Basically, I know how to create a normal mail merge already but now I am planning to code it in a different way. I was wondering if anyone knows how to do this/ has done this themselves.

    I want the user to click a macro in my database (As usual), then the coding will tell Access where to save the file. The user will be asked if they wish to use their template or a blank document (or there could be seperate macros for the two options). If the user wants to use their template access will automatically find the template and input details in the correct places. After this word will stay open so that the user can edit it and print it as needed.

    I am using Office 2010 just so you know...

    Any pointers or ideas would be great!

    Thanks

    Rebecca.


    Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org
    • Marked as answer by Jennifer Zhan Monday, August 30, 2010 2:16 AM
    Friday, August 27, 2010 10:19 PM