Emailing through Excel

Question

Having issues with sending emails through Excel. It's not synced for out email and excel.

Answer 1

Hi @HREA KPVG,

Welcome to the Microsoft Q&A forum.

Thank you for contacting us. Please allow me to provide you with the following information:

The issue you’re experiencing when sending emails from Excel may be caused by the following reasons:

1. Outlook is not installed or not set as the default.
2. Office or Excel installation is corrupted.
3. Add-ins in Excel or Outlook are causing conflicts.
4. Antivirus software or firewall is blocking the connection between Excel and the email application.

Suggested troubleshooting steps:

Step 1: Check the default email application

• Open Control Panel > Default Programs.
• Scroll down to find Outlook, click on it, and set it as the default for file types (.eml, .hol…) and mailto links.

Step 2: Repair or update Office

• Go to Control Panel > Programs > Programs and Features.
• Find Microsoft Office > right-click > select “Change” > “Online Repair”.
• After the repair is complete, restart your computer and try again.

Step 3: Disable Add-ins in Excel

• Open Excel > File > Options > Add-ins.
• Under “Manage”, select “COM Add-ins” > click “Go”.
• Uncheck all add-ins > click OK > restart Excel and try sending the email again.

Step 4: Check antivirus/firewall software

• Temporarily disable antivirus software or firewall and try sending the email from Excel again.
• If it works, reconfigure the security software to allow Excel and Outlook to function properly.

Step 5: Alternative solutions

• If you still cannot send emails, you can:
  • Save the Excel file and send it manually via email.
  • Share the file via OneDrive or SharePoint.

 I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.   

Thank you for your patience and your understanding. If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.

I look forward to continuing the conversation.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 2

If you're having issues with sending emails through Excel, it may be related to how Excel is configured to interact with your email client. Here are a few things you can check:

1. Default Email Program: Ensure that Outlook is set as your default email program. If you're using the New Outlook for Windows, be aware that it may not fully support the mail merge feature from Excel as the Classic Outlook does.
2. Email Configuration: Verify that your email account is properly configured in Outlook. You can check this by sending a test email directly from Outlook to ensure it works outside of Excel.
3. Permissions: Make sure that the user account you are using has the appropriate permissions to send emails through the email service.
4. Excel Code: If you are using VBA to send emails, ensure that the code is correctly set up to reference the email addresses and body text appropriately. You can refer to examples of sending emails from Excel using VBA for guidance.

If the issue persists, consider switching back to Classic Outlook if you are currently using the New Outlook, as it supports the full functionality needed for mail merges with Excel.

---

References:

• Sending Email to a List of Recipients Using Excel and Outlook
• Merge to Email problem - please help - Microsoft Q&A