Excel Macro with custom subject line

N

Nilotpol

Excel sheet contains information like the following.

Name Number Email
Paul 123456 [email protected]
Robert 654321 [email protected]

Name = a1
number = b1
Email = c1

the data listed accordingly.

Email to be composed as

To: [email protected]

hi Paul,

you <number>

everyday the data changes with total number. Ranges from 5 -50 or
more.

how do i do it?

thanks
 
Top