Emailing to list

Hi,

I am using the following code to email a report to a list of users, the code basically prepares the data that will go in the "To..." field in outlook.

It does this my compiling a list of all cell where there is a valid email address found in a separate file call "email list.xlsx"

Rather than it just emailing to all address, i need the code to check specifically in column b (as there will be other columns for other reports) if the user wants the report or not - i use a simple Y or N to highlight if the user wants the report.

I would also like the code to adress the users so in the body of the email it would say "Dear Kevin, Peter and John....."

If anyone can help i would greatly appreciate.

Please Login or Register  to view this content.

To determine who gets a email, test using Offset to get contents of B column.

Please Login or Register  to view this content.

To personalize the email, you'll have to send each one a single email. This is different than you're current approach of building a distrubution string.

Please Login or Register  to view this content.