+ Reply to Thread
Results 1 to 4 of 4

Mail Merge with Excel document Word 2010

  1. #1
    Registered User
    Join Date
    03-05-2015
    Location
    United States
    MS-Off Ver
    2010 and 2013
    Posts
    3

    Mail Merge with Excel document Word 2010

    Hi,

    My name is Maria and I am having trouble doing a page break after doing the mail merge. I have a excel file that has three columns and Column "City" repeats city names and Column "Employee" and Column "Sales". What I'm trying to do is to show the city name one time and below a table in word that shows the employees and sales under the city. Then do a page break after another city.

    If anyone could help I will appreciate it. I have written If statment in the mail merge but it gives me an error.
    Attached Files Attached Files

  2. #2
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Mail Merge with Excel document Word 2010

    Its very simple you can take help from here

    http://www.aspose.com/docs/display/w...ing+Mail+Merge
    If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.

  3. #3
    Registered User
    Join Date
    03-05-2015
    Location
    United States
    MS-Off Ver
    2010 and 2013
    Posts
    3

    Re: Mail Merge with Excel document Word 2010

    Hi,

    I got the page break but what I don't get is the data to be in groups. For example, I have two sales people under Atlanta and I want the two sales people to be in the same page and then do a page break. The document named results is with the page break but then it shows the next page with Atlanta and the other sales person. How can you keep the sales persons together with the same city and then do a page break to start a new city with their sales person?

    Thank you for any input.

    Maria
    Attached Files Attached Files

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Mail Merge with Excel document Word 2010

    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
    or:
    http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
    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, see the attachments to the posts at:
    http://www.msofficeforums.com/mail-m...html#post23345
    http://www.msofficeforums.com/mail-m...html#post30327
    http://windowssecrets.com/forums/sho...l=1#post928391

    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

    In addition to a 'Many to One' merge, the latter handles:
    • Merge with Charts
    • Duplex Merge
    • Merge with FormFields
    • Merge with Attachments
    • Merge to Individual Documents
    • Merge, Print and Staple
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  2. Mail Merge from Excel in to Word document
    By levtweeney in forum Excel General
    Replies: 2
    Last Post: 07-08-2014, 10:59 AM
  3. Excel Macro to Import Data Into Word Mail Merge Document
    By djboyag in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2012, 10:09 AM
  4. DDE Excel 2010 Format with Mail Merge in Word 2010
    By usc1382 in forum Excel General
    Replies: 0
    Last Post: 01-18-2011, 01:21 PM
  5. Replies: 1
    Last Post: 01-06-2006, 06:35 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1