Excel VBA email sending
Budget: $10 – $30 USD
automating another spreadsheet and sending emails to a list of recipients, based on a number of criterias
This is the unstructured data set---
Remember the emails should start with Hi <<First name>>
The following functions have to be automated:
1. Deleting PermID, Organization type, Primary RIC, Phone number type, Preferred contact method, preferred language, Status and all other columns to the right of Notes (right of Column R).
2. For columns of additional emails and additional phone number, add their respective values to their corresponding cells in primary email and phone number by placing a ; after the primary type. If the cell is blank, this rule can be ignored. Delete the additional emails and additonal phone number columns once this is done.
3. Cut paste column B (Organization column) to a column before A (before Name).
4. Filtering Org Response for 'No'.
5. Custom sort Organization column from A to Z and then Name column from A - Z.
6. If there is Bangalore Polling in the name column, that row should be deleted.
7. Add a column where the user can type the email ID which has to be CC'd while sending emails.
8. Add another column where the first name can be extracted using the formula =LEFT(name,FIND(" ",name)-1).
9. Add another column where the user can type emails and subject line to be sent to all those with No in Org response.
10. The email should be sent from the user's account. Emails should be sent individually to Emails in the primary email column and those in the CC column should be CC'd. Names which belong to the same organization will be sent only one email by ensuring email addresses are added in the same mail.
This is the unstructured data set---
Remember the emails should start with Hi <<First name>>
The following functions have to be automated:
1. Deleting PermID, Organization type, Primary RIC, Phone number type, Preferred contact method, preferred language, Status and all other columns to the right of Notes (right of Column R).
2. For columns of additional emails and additional phone number, add their respective values to their corresponding cells in primary email and phone number by placing a ; after the primary type. If the cell is blank, this rule can be ignored. Delete the additional emails and additonal phone number columns once this is done.
3. Cut paste column B (Organization column) to a column before A (before Name).
4. Filtering Org Response for 'No'.
5. Custom sort Organization column from A to Z and then Name column from A - Z.
6. If there is Bangalore Polling in the name column, that row should be deleted.
7. Add a column where the user can type the email ID which has to be CC'd while sending emails.
8. Add another column where the first name can be extracted using the formula =LEFT(name,FIND(" ",name)-1).
9. Add another column where the user can type emails and subject line to be sent to all those with No in Org response.
10. The email should be sent from the user's account. Emails should be sent individually to Emails in the primary email column and those in the CC column should be CC'd. Names which belong to the same organization will be sent only one email by ensuring email addresses are added in the same mail.