Rammy
New Member
Dear Ninjas,
Hope you guys are doing good!!!!
I have 1year holidays data with me now I would like to create one excel tool with the combination of VBA & outlook.
· I would like to Run this tool on daily basis to know if any holidays are there for tomorrow, the information should pick from “Holiday Database” and display in “user interface” in the body of the e-mail.
· I would like to paste the e-mail contacts to text box/ somewhere.
· Once I click send e-mail button it should send the e-mail and show the user form message saying that “E-mail sent successfully”.
Note; this tool should work Excel 2000 to 2013 versions.
Please help me with this matter and provide me the step by step process notes for my future reference.
Kindly find the enclosed Excel attachment for your reference.
I really appreciate the way you help me always.
Hope you guys are doing good!!!!
I have 1year holidays data with me now I would like to create one excel tool with the combination of VBA & outlook.
· I would like to Run this tool on daily basis to know if any holidays are there for tomorrow, the information should pick from “Holiday Database” and display in “user interface” in the body of the e-mail.
· I would like to paste the e-mail contacts to text box/ somewhere.
· Once I click send e-mail button it should send the e-mail and show the user form message saying that “E-mail sent successfully”.
Note; this tool should work Excel 2000 to 2013 versions.
Please help me with this matter and provide me the step by step process notes for my future reference.
Kindly find the enclosed Excel attachment for your reference.
I really appreciate the way you help me always.