Results 1 to 3 of 3

Thread: Mail Merge

  1. #1
    New Lounger
    Join Date
    Jan 2016
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Red face Mail Merge

    Hi Everyone,

    I know that several post have been created talking about this topic, and the only thing I understood is that after doing some fancy stuff with the brackets, I only can create a new word document with several pages by merged field doing the "pivots" and then on the tutorial says "after the mail merge, you can email the new document..."

    But how can I email multiple messages to different people (of each page) with the proper merged information.

    I feel I need to do everything manually anyway.

    I attach some examples.

    Im using word 2010

    my main edited word coument is example and the merged file is "example merged".doc

    my database is example.xls


    how do I send like mail merge messages the created merged document without human intervention?
    resuming, I would like to email the pivot table. by supplier of the attached file.

    Please help.
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    You appear to be using a directory/catalogue merge setup from another thread in this forum, designed to produce documents. The process for producing a merge to email is somewhat different and the process is detailed in my Microsoft Word Catalogue/Directory Mailmerge Tutorial, which you can download from the 'Sticky' thread at the top of this forum:
    http://windowssecrets.com/forums/sho...merge-Tutorial
    The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters and emails. Do read the tutorial before trying to use the mailmerge document included with it.

    Another approach, easily adapted to your setup, would be to be to use a DATABASE field in conjunction with a normal letter merge and a macro to drive the process. For a recent solution along these lines, see: http://answers.microsoft.com/en-us/o...1-1996c14dca5d

    Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
    Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
    Doug Robbins at http://bit.ly/1hduSCB
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. The Following User Says Thank You to macropod For This Useful Post:

    maury1977mex (2016-01-12)

  4. #3
    New Lounger
    Join Date
    Jan 2016
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I used the add-in to get out of problems.

    Before posting I downloaded and read your tutorial but I think because Im a newbie on this the codes and macro I pasted generated errors.

    So with the examples on your tutorial and concatenated fields on excel I saved time on my work.

    But like someone said "I'll be back" because I know I can polish my mail/merging info.

    Thanks Paul.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •