Generating Automatic Emails From Excel
By Jhimber0905 on Wednesday, 17 June 2020
Posted in Kutools for Excel
Replies 3
Likes 0
Views 6K
Votes 0
Hello, 

I found a great link on this website to be able to create an automatic email in excel (as a reminder) when a certain date is approaching. That said, the code only opens up emails in outlook, it does not actually send them. Is there a script that would automatically send the emails that are generated?

Thank you!
Hello,
Would you lie to automatically send the emails that are generated in Excel when a certain date is approaching?
Thanks in advance.
Excelfans
·
3 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, that is what I am trying to do. What I don't understand is that each time I open the workbook and run the macro it makes me select the ranges that I want to have emails generated for. Can I choose a fixed range instead of having to select this data each time?
Jhimber0905
·
3 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Click on the Start Mail Merge menu and select the E-Mail Messages option. Click on the Select Recipients menu and select the Use Existing List option. Browse and select the Excel spreadsheet you created earlier, and then click on the Open button.
Lewis-H
·
3 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post