Dutchmaste
New Member
- Joined
- Jun 14, 2016
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
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,
....
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,
....
