A Excel VBA Script that can help to automate the monthly-billing, invoice, and reminder mail, sent to corporate partners and clients, to save mundane and repetitive work. With Advanced features like automatic invoice pdf attachments, key matching, table data in mail etc.
- Use Of Outlook library 12.0 or greater recommmended.
- Connect with Microsoft Excel 2010 or greater recommended.
- Attach code to a macro button, and use via button
- Provided AutoMail Excel File, includes premade template for using the code.
- Choose Which Mail by running other macro included
- AutoMailSheet - contains the to and id key element
- TemplateSheet - contains the template for elements, and other default setting
- Placeholder Variable - inspired from velocity, it replaces the placeholder with the concerned data
- Table Formation - build up a table when required
- Status update - updates your send request
- From - Choose a default mail to send it from, using the other macro also provided
DEVELOPED BY: MUDIT RUSTAGI, UNDER MENTORSHIP FROM NIKHIL SHARMA
LIVE ON: 17th July, 2019