Hi Everyone,
I use MS excel to tabulate a list of prospect/ lead names. The names are in the format Title, First name, Middle name, Last name.
Q.1) I need to generate email addresses from the different combinations of the first name, middle name, and last name. The domain for the email address is also in the same row as the name but in a separate column. Can anyone help me understand the most efficient way to generate all possible such email address combinations in the same row as the name but separate columns, either using formulas or a macro? E.g: first.last@domain.com; first.middle@domain.com; first_middle.last@domain.com; etc.
Q.2) Once the email addresses have been generated I will use mail-merge to send an email to all the addresses generated in the previous step using MS Outlook. When i send the emails more than half the combinations will fail to deliver due to an incorrect email address. Is there a way that the excel sheet, with the email addresses, displays which email addresses successfully delivered to the recipient and which email addresses failed to deliver to the recipient? So I can save the correct email ID's and discard the incorrect ones.
Any help with either question will be immensely appreciated. My excel is quite substandard therefore being an empty cup i'll be happy with either formula or Macro solutions.
in case of queries i can be reached via email(listed below) or this thread. Looking forward to replies!
Best!
Assad Rana
assad.rana@gmail.com; ranabouy@gmail.com
PS: Although I've been using MrExcel for several years, this is my first post. So I was wondering if I can attach a sample Excel file for greater clarity.
I use MS excel to tabulate a list of prospect/ lead names. The names are in the format Title, First name, Middle name, Last name.
Q.1) I need to generate email addresses from the different combinations of the first name, middle name, and last name. The domain for the email address is also in the same row as the name but in a separate column. Can anyone help me understand the most efficient way to generate all possible such email address combinations in the same row as the name but separate columns, either using formulas or a macro? E.g: first.last@domain.com; first.middle@domain.com; first_middle.last@domain.com; etc.
Q.2) Once the email addresses have been generated I will use mail-merge to send an email to all the addresses generated in the previous step using MS Outlook. When i send the emails more than half the combinations will fail to deliver due to an incorrect email address. Is there a way that the excel sheet, with the email addresses, displays which email addresses successfully delivered to the recipient and which email addresses failed to deliver to the recipient? So I can save the correct email ID's and discard the incorrect ones.
Any help with either question will be immensely appreciated. My excel is quite substandard therefore being an empty cup i'll be happy with either formula or Macro solutions.
in case of queries i can be reached via email(listed below) or this thread. Looking forward to replies!
Best!
Assad Rana
assad.rana@gmail.com; ranabouy@gmail.com
PS: Although I've been using MrExcel for several years, this is my first post. So I was wondering if I can attach a sample Excel file for greater clarity.
