Share via

Help Mail Merge wont send email and complete!

Anonymous
2023-06-17T04:29:24+00:00

Hello, I am trying to complete a mail merge and cannot get Word to send the email. I have set up the spreadsheet and the merge completes just fine. However, when I click finish and send email it goes through the motions as if it is sending the email but it never sends. I open outlook and there is nothing in my sent or drafts folder. I know the email is working because I can send and receive from my primary and secondary addresses in outlook. Please help I really need to get this completed. I never had problems like this with older versions of the programs. I am using microsoft 365 and the latest version of outlook.

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-20T19:13:57+00:00

    Hi Melissa,

    Were you able to get your emails to send? I'm having the same issue!

    Thanks,

    Becky

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2023-06-17T21:17:45+00:00

    Thank you I have tried all of that and nothing seems to work.

    3 people found this answer helpful.
    0 comments
  3. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2023-06-17T07:28:09+00:00

    In the Merge to E-mail dialog, try changing the Mail format. Sometimes, once it has sent the messages in one format, it is then possible to go back and select the original format and the messages will then be sent in that format.

    Alternatively, use the Merge with Attachments facility on my Merge Tools Add-in that is contained in the MERGE TOOLS ADD-IN.zip file that you can download from:

    https://mergetoolsaddin.com/

    Extract the files from the archive and read the:

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

    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 .  The email messages can, if necessary, also be sent to CC and BCC addresses.
    • 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[A1]
    • Duplex Merges
    • Merging to a printer that will collate and staple the output created from each record in the data source.

    The requirements for using the system are:

    • The mail merge main document must be of the Letters type, though that does not mean that the output cannot be sent as an e-mail message where relevant.
    • For the Many To One, Merge with Attachments and Merge to Individual Docs utilities, the data source may be either a table or query in an Access database, or in the form of an Excel worksheet. For the Chart Merge utility, see the Mail Merging with Charts document that is included in the Merge Tools Add-in Zip file for additional requirements for the data source for use with that utility
    • For a data source in the form of an Excel worksheet, the field names must be in the first row of the worksheet and there must be a field name in all of the cells in that row that are within the range of columns that contain the data.
    • For both types of data source, the field names must contain only alphanumeric characters (No @,#,$,%,&,(,), etc) and the field names must not start with a numeric character (0-9). The number of characters in the field names, including spaces, must not be more than 40.

    [A1]

    2 people found this answer helpful.
    0 comments
  4. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2023-06-19T04:06:14+00:00

    Try my MergeTools Add-in. If you need assistance with it, contact me by email at the address in my signature.

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2023-06-17T05:23:07+00:00

    Hi Melissa U,

    I’m Segunfunmi an Independent Advisor and Microsoft user like you. Thanks for posting the query here in this forum.

    I’m sorry you’re having trouble with your mail merge. Try changing the format of the messages from HTML to Plain Text or vice versa. It has been reported that this will sometimes "unblock" the system.

    You can use the links below to learn more.

    https://support.microsoft.com/article/source-for-a-mail-merge-4cfcf038-1bc4-4a73-b5e3-a3303302db13

    https://support.microsoft.com/article/61aace0d-72c2-4259-acfc-c9d7eba45e27

    https://support.microsoft.com/article/messages-0f123521-20ce-4aa8-8b62-ac211dedefa4

    Best regards segunfunmi

    1 person found this answer helpful.
    0 comments