Forum Discussion
Diana703
Sep 07, 2022Copper Contributor
Need Help with Excel Macro
I have a large excel sheet (macro enabled) that I want to send email from with specific data in each email. I have all working right but I can't get it to create an email to send to each email addre...
- Sep 12, 2022
See the attached version. The code is in Module1.
HansVogelaar
Sep 07, 2022MVP
I temporarily commented out the criteria, since they don't work, and don't make any sense to me. I got these three messages. Three different recipients, three different subjects, and (not shown) three different message texts. So the problem must lie elsewhere.
Diana703
Sep 12, 2022Copper Contributor
Can you send me the code you used to get the above? I tried editing mine and it didn't work. Thank you.
- HansVogelaarSep 12, 2022MVP
See the attached version. The code is in Module1.
- Diana703Sep 12, 2022Copper ContributorOh my gosh! This is working. I think I love you for being so patient with me and helping me with this. I could cry! Thank you, thank you, thank you!
- Diana703Sep 12, 2022Copper ContributorGosh, you are going to wish you'd never heard of me but there is one thing that it has stopped doing. It used to put the date when the emails were sent in the Email Sent column but now it's not doing that. Can you fix that part of the code yet and then I promise to leave you alone. Thank you!