+ Reply to Thread
Results 1 to 3 of 3

Mail Merge from Excel in to Word document

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    Newcastle upon Tyne
    MS-Off Ver
    Excel 2010
    Posts
    36

    Mail Merge from Excel in to Word document

    Hi All

    I have a excel document (Activities) with a list of names and activities people have chosen (See attached sheet)

    I need to take the "Forname", "Surname" and "Reg" details from the "Monday" sheet as well as their linked activities (Under the P1, P2, P3, P4 and P5 headers) and add these to the attached word document as a Mail Merge.

    I also need to do this from the "Tuesday" sheet also

    Is this possible? I have looked but found it really hard to do.

    I have attached an example of what the finished page should look like.

    Any advice/help is much appreciated

    Kindest Regards

    Kevin
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Mail Merge from Excel in to Word document

    Hi Kevin

    I think that the answer to your question "Is this possible" is "No". Well, it is not possible for me with my very limited mail merge experience - I cannot see how to handle, for instance, where someone is not on Monday's activities, but is on Tuesday's.

    My solution is to add 5 more periods to Monday's sheet and Lookup the values from Tuesday's sheet. (You may need to do a look up in Tuesday from Monday to cover my issue in paragraph above.

    The problem with this, is that you need some unique identifier. You need to add a column (and I would suggest on the left, otherwise you will have to use index / match instead of vlookup). Into this column you need to add either their unique registration number, or concatenate their forename and last name (and hope that you do not have 2 "John Smith"s)

    I hope that the above has given you a pointer - do get back to me if I can explain further.

    Regards
    Alastair
    Last edited by aydeegee; 07-08-2014 at 10:08 AM.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Mail Merge from Excel in to Word document

    You can't do what you want without creating a single data source for Word to use in a Mail Merge. Word needs 1 row per record (Person) with all fields for that record in the same row.

    If the Data Source is a Word table the maximum number of fields is 62. If the source is Excel, you should be able to exceed this number. If the source is an Access table the max is around 255 fields....Excel should be about the same unless that has changed over the years.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Mail merge to Word Document
    By Banaticus in forum Excel General
    Replies: 8
    Last Post: 08-08-2013, 04:28 AM
  2. Modifying Word Document Properties using Mail Merge and data in Excel
    By veejar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-28-2012, 01:29 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. Replies: 2
    Last Post: 11-09-2007, 07:54 AM
  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