Hello,
I have a spreadsheet in Excel with First & Last Name combined in one column and three other columns.The columns are as follows;
<tbody>
</tbody>
In total I have 350 rows. As you can see above come rows have same names and email address but the username and password are different.
I want to use a macro or mail merge in excel that will send an email to each person regarding their username & password. But I want to send only one email to a single recipient who may have multiple rows in the spread such as ChristineMurray shown in table above.
Is there a macro or mail merge function I can use that will perform the function of sending one email to single recipient who may have multiple rows and also each email to remaining unique persons/email addresses.
Any help/feedback would be appreciated!
-Arslan
I have a spreadsheet in Excel with First & Last Name combined in one column and three other columns.The columns are as follows;
First&Last Name | Username | Password | Email address |
ChristineMurray | CMurray_HP | Test!23 | Cmurray@tbh.com |
ChristineMurray | CMurray_GH | Pts.345 | Cmurray@tbh.com |
BrodySmith | BSmith_EP | Test123! | Bsmith@api.com |
BrodySmith | BSmith_SP | Temp!32 | Bsmith@api.com |
AdamLa Selva | ALa Selva_GSH | Pts.245 | Alaselva@gsh.com |
<tbody>
</tbody>
In total I have 350 rows. As you can see above come rows have same names and email address but the username and password are different.
I want to use a macro or mail merge in excel that will send an email to each person regarding their username & password. But I want to send only one email to a single recipient who may have multiple rows in the spread such as ChristineMurray shown in table above.
Is there a macro or mail merge function I can use that will perform the function of sending one email to single recipient who may have multiple rows and also each email to remaining unique persons/email addresses.
Any help/feedback would be appreciated!
-Arslan