Hello All,
Request your support on below 2 topics.
1. The requirement is to send auto email through excel. The email addresses, cc address, subject and body of the email is keyed in particular cells in the same excel. Individual emails has to be sent with the subject and body of email from the same row. I have programmed it already in which all the above particulars for individual email (please refer to the attached excel) But i could not make it further to add further. Once all the entries are made in the excel, all the individual emails should be sent by EmailSend command.
2. In cell "H3" the subject is auto generated by the name of the person and the entry time. But the value of time is generated in decimal value and not in time format. Request your suggestion for correction.
Thanks in advance for the solution.
Mohith
Hi Mohith,
The attached file will do what you want.
I've modified the message body as it didn't need the time in the string, I'm picking that up from the cell on the worksheet.
This blog post may help you out with any further emailing you need to do
regards
Phil
Hello Philip,
Greetings! Hope you're doing fine!!
Its working. Thank you for your support.
Can the email be sent automatically? I mean when there is an input for a particular row and the subject is generated (column H from the excel), can the email be triggered automatically without giving the manual command "send email"?
It would really helpful if we can have this solution.
Thanks & Best Regards,
Mohith
Hi Mohith,
Yes this can be done, though I'd caution against triggering an email when the Body of the message in Col H is entered. What if you make a mistake in typing and need to edit? Too late, the email has already been sent.
You can use another column as a trigger? When you enter some text into Col I the email for that row is sent?
Regards
Phil
Hello Philip,
Am trying to avoid manual intervention in sending the email. I agree to the risk of mistakes but will ensure the mistakes are avoided.
Please suggest how this can be done when the body of the message is entered in col H.
Thanks in advance for your support.
Best Regards,
Mohith
Hi Mohith,
Please see attached file. When the message body is changed on a particular row, and email is sent to the email address on that row.
Of course, when you delete that message body an email is sent. Hence why I cautioned against doing it this way.
Regards
Phil
Hello Philip,
Thanks for the updated file.
When the name or the time is modified in the file, the email is not getting triggered (the subject is col H will be auto updated as it is linked). What was observed is when the cell in col H is edited manually, the email is getting triggered.
In your previous post you suggested for using another column to trigger email. Can this column be the input column, col B? This input is linked with be linked to all other columns gets filled so email can be triggered once this column has an input.
Thanks in advance for your solution.
Best Regards,
Mohith
Hi Mohith,
You asked for the email to be sent when the body of the message is entered in Col H and that is what the code does. But it''s easy to modify - see attached.
When you now make a change to Col B and email will be sent.
Regards
Phil
Hello Philip,
I am getting run time error in the new file.
Could you please check?
Thanks & Best Regards,
Mohith
Hi Mohith,
Try this. You can add whatever fields you want to the Body cell, but you can leave out the time as the code adds this.
Regards
Phil
Hello Philip,
The program is working. Thanks for your support.
Best Regards,
Mohith
You're welcome.
