+ Reply to Thread
Results 1 to 11 of 11

Mail Merge From Excel

  1. #1
    Registered User
    Join Date
    10-19-2016
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    87

    Mail Merge From Excel

    Hi,

    I have an Excel file (attached) which I need to mail merge to Word.

    I have Students A to H that I need to mail merge into separate letter documents with 4 statements per student.

    The statements are all in row 1 of the spreadsheet and each row below row 1 shows me (by use of an X) which 4 statements are to be allocated to each student.

    Is this spreadsheet format possible for a mail merge?

    Many thanks for looking at this problem I have.

    Regards,
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Mail Merge From Excel

    you can mail merge from anything. take a look at the attached archive as an example. but this uses ms access, not excel. doesn't matter though. same concept applies.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-19-2016
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    87

    Re: Mail Merge From Excel

    Thanks, I'll take a look.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,178

    Re: Mail Merge From Excel

    If you are still looking, search the Web for "Charles Kenyon". He has great tips and vast knowledge of MailMerge/MsWord - Also look for Paul Epstein ( aka macropod)
    Due to Forum rules, I'm not allowed to post links to another forum they are very active on... ( this rule is obsolete as far as I'm concerned...)

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

    Re: Mail Merge From Excel

    Quote Originally Posted by Pepe Le Mokko View Post
    Due to Forum rules, I'm not allowed to post links to another forum they are very active on...
    Since when?
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

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

    Re: Mail Merge From Excel

    Quote Originally Posted by cosmica67 View Post
    I have an Excel file (attached) which I need to mail merge to Word.

    I have Students A to H that I need to mail merge into separate letter documents with 4 statements per student.
    You can do this with a very simple mailmerge using your Excel workbook as attached.

    See: https://support.microsoft.com/en-us/...b-0a948fa3d7d3

  7. #7
    Registered User
    Join Date
    10-19-2016
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    87

    Re: Mail Merge From Excel

    That's great. Thanks for the recommendations. I'll definitely have a look.

  8. #8
    Registered User
    Join Date
    10-19-2016
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    87

    Re: Mail Merge From Excel

    That's very useful. Thanks for the link!

  9. #9
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,178

    Re: Mail Merge From Excel

    Quote Originally Posted by macropod View Post
    Since when?
    See forum Rule nr 10

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

    Re: Mail Merge From Excel

    Hmm, a rule that, as worded, is generally ignored - as a search on any of the potentially 'competing' forum names will soon reveal. For example:
    MS Answers - 6841 threads
    mrexcel - 8451 threads
    msofficeforums - 319 threads
    stackoverflow - 1734 threads
    tek-tips - 7780 threads
    vbaexpress - 1711 threads

    Or maybe they're considered as complimentary rather than as competing...

  11. #11
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,178

    Re: Mail Merge From Excel

    The thing is, I got a warning for violating that rule some time ago

+ 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. Running Word Mail Merge from Excel 2010 - Mail Merge workbook fails
    By pl05.lau@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  2. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  3. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  4. Mail Merge on Excel?
    By thebottomline in forum Excel General
    Replies: 1
    Last Post: 03-03-2010, 01:38 PM
  5. Help with Excel & Mail Merge
    By jsomer2000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2008, 04:49 AM
  6. Can I merge an excel list to an excel sheet like mail merge in wor
    By chcoach in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2006, 03:15 PM
  7. [SOLVED] merge with Word How can I get excel to mail merge zip codes plus 4 correctly?
    By Kathy at Sauder Feeds in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2005, 07:05 AM

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