How can I send automatic emails to multiple people from excel?

Question

Hello,

I am building a training matrix where icon sets indicate the status of someone's training. I have completed this part.

I now need to send an automatic email from the matrix to the staff member, line manager and L&D coordinator when the training is about to expire or expired.

I need to make the process easy so that others can replicate it.

Is this possible?

Answer 1

OpenAI generated answer:

You can send automatic emails to multiple people from Excel by using the mail merge feature in Microsoft Word. Here are the steps:

1. Open your Excel file and make sure that your data is organized in columns with headers.
2. Open a new Word document and click on the "Mailings" tab.
3. Click on "Start Mail Merge" and select "Email Messages".
4. Click on "Select Recipients" and choose "Use an Existing List".
5. Browse for your Excel file and select it.
6. Choose the sheet that contains your data and click "OK".
7. Insert the fields that you want to include in your email by clicking on "Insert Merge Field".
8. Compose your email message and click on "Preview Results" to see how your email will look like.
9. Click on "Finish & Merge" and choose "Send Email Messages".
10. Select the recipients that you want to send the email to and click "OK".

Your emails will be sent automatically to the selected recipients.

Answer 2

Went through the step-by-step process. Still doesn’t send emails.

Answer 3

How to add CC mails also in this

Answer 4

How do I add an attachment?

Answer 5

Is there a way to make the list of emails it's being sent to private, i.e., the recipients will only see a list name nof every email it's being sent to?