Send emails from Excel List

[Genesee]

I have a list of about 100 people to send an email to. I need to send an email to each individual in excel with an attachment and a personalised message. I don't want to type it because it will take too long. Any templates.

[AnitG]

Use MS-Word for a mail merge to email and Excel as the data source for the email addresses. This will merge everything into Outlook and be ready to send. Outlook may challenge (ask for confirmation) you to send in bulk assuming it's SPAM. Just follow the prompts.

[Koman]

There is abundant information on how to send email from Excel.I suggest you also use Clickyes (FREE), which allows you to create emails using simple code shown here.

 
As Object Dim myOutlook 
 As Object Dim myMailItem 
 variabileEmailDelDestinatario = "test@test.ext" 
 September otlApp = CreateObject ("Outlook.Application") 
 September otlNewMail otlApp.CreateItem = (olMailItem) 
 ActiveWorkbook.Path = fName & "\" & ActiveWorkbook.Name 
 With otlNewMail 
 . To = variabileEmailDelDestinatario 
 . Subject = "Message Subject" 
 . Body = "TEXT MESSAGE" 
 . Display 
 . Send 
 End With