Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Aug 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail merge Multiple Rows

    Hi guys,

    I would like to send an email to a group of different people involed in different projects by using an existing excel sheet with all the data:

    forum.jpg

    Id do it with mail merge from MS Word, but I see it creates a document for each row and I have recipients with more than one project and I want it all in the same email, not a separate email for each little project.

    Any help will be much appreciated.

    Thanks

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Star Lounger tgw7078's Avatar
    Join Date
    Jul 2010
    Location
    Seattle, WA., USA
    Posts
    82
    Thanks
    1
    Thanked 10 Times in 10 Posts
    If you are using Outlook as your email client, you are welcome to incorporate a procedure I wrote several years ago. Have a look at page 20 in a Word document I call "Access Links". You can download a zipped copy from here: http://www.accessmvp.com/TWickerath/...ccesslinks.zip.

    You'll also need a way of feeding this function a semicolon delimited list of email addresses, but that part is fairly easy. Post back if you need help doing that part.
    Tom Wickerath
    Microsoft Access MVP
    4/1/2006 - 3/31/2012

  4. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,783
    Thanks
    0
    Thanked 162 Times in 150 Posts
    You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
    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. Do read the tutorial before trying to use the mailmerge document included with it.

    For some worked examples (using Excel data files), see the attachments to the posts at:
    http://www.msofficeforums.com/mail-m...html#post23345
    http://www.msofficeforums.com/mail-m...html#post30327
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,481
    Thanks
    3
    Thanked 41 Times in 41 Posts
    Are you contemplating moving your Excel workbook to an Access database? If not, this thread should probably be moved to the Excel or Word forum.
    Wendell

  6. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,783
    Thanks
    0
    Thanked 162 Times in 150 Posts
    Indeed, if you want to do it with Excel data, 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 https://skydrive.live.com/?cid=5aedc...615E886B%21566
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  7. #6
    New Lounger
    Join Date
    Apr 2014
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am also trying to group multiple records in to one mail merged document. I decided to start with Microsoft's sample. I created an Excel document that matches their sample with the columns "City", "Employee" and "Sales"

    This is my code (an exact copy of theirs)

    HelenCode.JPG

    I still get one record per merged document, and that record displays only the Employee and Sales, not even the city.

  8. #7
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,783
    Thanks
    0
    Thanked 162 Times in 150 Posts
    You need to configure the document for a Directory/Catalog merge. Also, you'll find a much more comprehensive set of fields in my tutorial (http://windowssecrets.com/forums/sho...merge-Tutorial) - it's a Sticky Thread at the top of this forum.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  9. #8
    New Lounger
    Join Date
    Apr 2014
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Oh, I just found this little sentence in the tutorial: Word’s mailmerge tools include a facility (titled ‘Preview Results’ in Word 2007 & later) for previewing mailmerge output. Do not rely on the merge preview for either confirmation of a correct output content & formatting or mailmerge generation

    When I actually merged, everything was fine. Sheesh!

  10. #9
    New Lounger
    Join Date
    Apr 2014
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The tutorial is great! Thank you

  11. #10
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,783
    Thanks
    0
    Thanked 162 Times in 150 Posts
    Quote Originally Posted by goudlie64 View Post
    Oh, I just found this little sentence in the tutorial: Word’s mailmerge tools include a facility (titled ‘Preview Results’ in Word 2007 & later) for previewing mailmerge output. Do not rely on the merge preview for either confirmation of a correct output content & formatting or mailmerge generation

    When I actually merged, everything was fine. Sheesh!
    It's the little things that get you ... every time.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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