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
13 freelancers are bidding on average $69 for this job
Hi Mate, I have created a macro to do something similar to this, I can show that as demo if you’re interested. Ping me to discuss more. Thanks Aman Jha
Yes, I can develop this macro to switch between Outlook accounts. Please reply, thank you!
Greeting, I have understood your Send batch emails from Excel Template using VBA task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Daha Fazla
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
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.
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
Hi, I am a MBA from one of the top B-schools in India. In terms of professional experience, I have worked in consulting and banking domain in various roles and responsibilities. I have been freelancing from the past Daha Fazla
I can develop Excel macro which send email with outlook using VBA. I have developed number of different database and office solutions.
Hi there, I consider myself to be the perfect choice for your job post regarding Data Processing, Excel, Microsoft Outlook, Visual Basic, Visual Basic for Apps . Do you want to know the reason why? Hire me and you’ll Daha Fazla
I have read your requirement that you want to have a button to send email to all recipients listed, using multiple outlook account, I am proficient in using Excel VBA macros, your proposal can be done easily and quickl Daha Fazla
Your requirements seem clear. I assume that you wish to keep adding new customers and suppliers to the bottom of each table? So once you have sent a email to the first 10 customers and Column "I" has the word "Sent Daha Fazla