Excel Automation of Emails
Teslim sırasında ödenir
Help me create an excel sheet. The purpose of the excel sheet is to create email nurturing campaigns to a list of emails with a click of a button using the Developer Tab > "insert" > "button" on excel.
Sheet 1, Labeled as Emails, will have Column A with First Name, Column B with Last Name, Column C as Email Address. Column D will be date in which the first Email address was sent. Column E is the time in which the first email was sent. Column F is the date in which the second email is scheduled to send. Column G is the time in which the second email is scheduled to be sent. Column H is the date in which the third email is scheduled to send. Column I is the time in which the third email is scheduled to be sent.
There should be a button on Emails Sheet that will send the emails on Column A.
Sheet 2, Labeled as Email Templates. Column A will be labeled as personas. Column B will be Subject Line #1 which would be the subject line of the first email sent. Column C would be Body #1 which would be the body of the first email sent. Column D would be Subject Line #2 which would be the subject line of the 2nd email sent, and etc until Body #3.
Email 1 and 2 should be sent at once while leveraging Outlook's built-in delay delivery feature. The delay between the first and second email set in seconds will be input on the Email Template Sheet in Cell C2. It is very important that when I click send, I don't have to keep the excel sheet open to ensure that the second email will be sent. The delay will be 1 week between emails for 99% of the time.
Each body email will start with "Hi [name]", before sending out an email, the [name] Variable needs to be changed with the corresponding first name from Column A from Sheet 1. Sheet 2, Labeled as Email Templates, in Cell H2 will be the delay between Email 1 and 2, and Email 2 and 3. Cell H1 will be labeled as Time Delay.
Proje NO: #36708342
I have read your requirement and I can easily work on this. I have more than 8 years of experience in IT field. And I have mainly experience on .net and c#. I have vast experience on .net,c#, desktop application, web a Daha Fazla
Bu iş için 30 freelancer ortalamada $161 teklif veriyor
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day
Hi there! As I have read, I see you need help creating an excel sheet for your project and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and Daha Fazla
Hello, I understood the project but have few doubts, please text me so i can clear all my questions right away and to confirm my skills and expertise you can have a look to my profile
Desarrollador | Visual Basic | c# |.net | Sql Server | com más de 26 años de experiencia con conocimientos en Dynamics Gp | Power bi | Dynamics 365 | Dexterity | Python | Angular | Php