Adding Names to auto email message

Hi There,

I am currently working on a workbook that will email myself automatically when the expiry date is close.

I am having trouble with adding the clients name to the email message when it is sent though.

For example i want it to have: The filters for "Clients name" need to be replaced. With Clients name being added from whatever is listed in the column.

If anyone could help me it would be very appreciated.

Thank you.

Not really sure what you mean by ... The filters for "Clients name" need to be replaced. With Clients name being added from whatever is listed in the column

The code seems to go through the list and check each to see whether to send or not (although it could all be done in one send, but that is another matter?)..

I am curious as to how it would send in one emial. How would the email be layed out?

Create an array of names, and then Join that into a string with a ; delimiter.

Ok Thanks for that i will give it a try