mail merge not working with office 2013

Anonymous
2013-03-08T16:24:00+00:00

Trying to do a mail merge with office 2013.  I've done this for years with other versions of office (2003, 2007, 2010) but it's not working with 2013 for some reason.  I'm following all the steps, but the emails aren't getting sent.  Is there some way that the profile or something is set up wrong so that word isn't sending this properly? I've also tried to send via outlook, but in outlook I can't choose an excel spreadsheet for the list of contacts. 

What is wrong with this?  someone plesae help me!  My outlook profiles are all messed up becasue i use icloud to sync the calendar and contacts, but i use pop/stmp (whatever that means) for my email....

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

82 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2017-04-06T23:09:45+00:00

    After reading many trails on this subject, the solution was fairly simple...

    Make sure Microsoft Mail (not just Outlook) is set up to send emails on the same account.

    Both plain text and HTML email merges worked without issues.

    Was this answer helpful?

    0 comments
  2. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2016-11-08T00:20:52+00:00

    Use the Merge with Attachments facility (you do not need to actually have attachments) on my Merge Tools Add-in.

    You can download the MERGE TOOLS ADD-IN.zip file from the following page of my One Drive:

    http://bit.ly/1hduSCB

    Then extract the files from the archive and read

    “READ ME – Setting up and using the Merge Tools Add-in.docx

    to see how to install and use the various tools.  Using those tools, it is possible to perform the following types of merge that cannot be done with Mail Merge “out-of-the-box”:

    • Merge to e-mail messages either with or without attachments, with the documents created by the merge being sent as either Word or PDF attachments or as the body of the e-mail message.
    • Merge to individual documents in either Word or PDF format with the filenames being supplied by the data in one of the fields in the data source
    • Many to One type merges, which can be used for creating documents such as invoices where there are multiple records in the data source that have common data in one of the fields
    • Merging to a document that will include a chart that is unique to each record in the data source
    • Merging a document with Content Controls
    • Merging a document that contains Legacy FormFields
    • Duplex Merges
    • Merging to a printer that will collate and staple the output created from each record in the data source.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-11-07T15:37:33+00:00

    Outlook 2013:  I was able to execute an email merge and send messages using Plain Text as the format.  But I was not able to execute it afterward in HTML format.  Plus, Outlook required me to Allow every single individual email before it would send it.  I only had about a dozen names in my list, so while irritating, this was not onerous, but it will be when I have to send about 100 emails next month.

    Was this answer helpful?

    0 comments
  4. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2016-10-14T22:20:17+00:00

    What type of merge are you trying to perform.  Unless it is a Many to One situation, where you have multiple records with some of them having common data in a particular field and you want all of those records to be used in the output (e.g. with an invoice), you should not be using the Many to One utility.

    If you send me a copy of the mail merge main document and the data source, referencing this thread in the covering email message, I will check them out and let you know what you need to do to get it to work properly.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2016-10-14T20:09:59+00:00

    Merge Tools did not work for me or else I didn't know how to use it.  I have an excel sheet that has one sheet, first row titles.  The option "many to one" had an error - calculation error?  Don't remember.  But I deleted it because it also prevented Word from remembering that I had associated a data source from this computer.

    Here's what's happening on my end, and maybe someone can make a recommendation that doesn't involve altering my computer.

    I formerly was able to do merge documents until I edited my options to NOT send right away.  Which I needed because I have to edit the emails individually before they go out.  NOW email mail merge doesn't work unless I send as plain text, which I can't.   HELP!

    Was this answer helpful?

    0 comments