Create VBA to send individual emails out to different receipients based from the excel template provided. There are 2 tabs (Customer & Supplier), each tab requires to be sent by different email accounts in Outlook
1 Both Customer & Supplier tabs are similar and requirements are the same
2 Emails should be sent individually to each recipient using the columns contained in each spreadsheet
3 1 button to send all emails in each tab (i.e. tabs customer and supplier should be used and sent separately)
4 When button is clicked there should be a confirmation message if wish to send emails to avoid accidently clicking the button
5 Once email is sent, there should be a confirmation for example a 'tick' or 'sent' text populated in a column (I)
1 My outlook has multiple email accounts. I.e. I need emails from the customer tab to be sent using my account A, and supplier emails to be sent by account B.
How can this be achieved? - can the selected account be based of a cell in the spreadsheets? See below images
12 freelancers are bidding on average $73 for this job
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards.
Hi! I'm interesting your project very well. I am mastering excel and vba. And also I have many experience and good skill about web development. Let's go ahead with me
Hey, It looks like an interesting project and i would love to take it. You can go through my reviews so that you could be confident about your faith in my abilities. Hope to chat with you soon Sajid
hello, i am interested in your project. i'd love to help you create the macro to send emails on both tabs. i will need some more details over chat. waiting to hear from you, thank you.