Send multiple emails with and to details from excel sheet using Outlook

[Dutchmaste]

I am trying to find a way to send multiple emails from a excel sheet, by using Outlook. The excel sheet I receive has a different range of values each time, but columns are always the same. It looks as followed:

Column A: Details A
Column B: "Computer_name" (This column is best to decide until which cell should be run)
Column C: Details B
Column D: Details C
Column E: "User_id" (Cell needs to be marked red if empty)



It should sent the email as followed:


To: "User_id" (then check user option in Outlook)
Subject: Test email


Dear all,


This is a test to see if we can make this work with help from a online community.


Computer: "Computer_name"
Last known user: "User_id"


If we could get this to work it would make it a lot easier for me to send each user emails from one excel sheet.


Kind regards,


....

 

[Macropod]

Have you considered using a mailmerge?