VBA to send email to unique mail id given in a cell with the subsequent columns

Prince27

New Member
Joined
Nov 24, 2012
Messages
37
Hi,
There are 4 columns in excel as shown below:

Email
Name
Location
Number
abc@gmail.com
aaa
CA
123
abc@gmail.com
bbb
TX
223
xyz@gmail.com
ccc
NJ
333

<tbody>
</tbody>

I need a VB Code to send separate emails to unique mail id's with column 2, 3 & 4 in a table format.(Mails should automatically send to mail id's given in column1)

1 email for each Unique mail id.


Output should be as follows:

For abc@gmail.com

Name
Location
Number
aaa
CA
123
bbb
TX
223

<tbody>
</tbody>

For xyz@gmail.com

Name
Location
Number
ccc
NJ
333

<tbody>
</tbody>


Thank you for your help.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Watch MrExcel Video

Forum statistics

Threads
1,109,149
Messages
5,527,098
Members
409,745
Latest member
CharlesAlsop

This Week's Hot Topics

Top