ExcelBanter - Excel Macro with custom subject line

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Macro with custom subject line (https://www.excelbanter.com/excel-discussion-misc-queries/247400-excel-macro-custom-subject-line.html)

Nilotpol[_2_]

Excel Macro with custom subject line

Excel sheet contains information like the following.

Name Number Email
Paul 123456
Robert 654321

Name = a1
number = b1
Email = c1

the data listed accordingly.

Email to be composed as

To:

hi Paul,

you <number

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

how do i do it?

thanks

All times are GMT +1. The time now is 06:33 AM.