Mailing to a distribution group in Excel

[Guest]

I've got a macro (thanks to Ron de Bruin's website) which generates a mail
message to e-mail accounts in a list in Col B subject to certain criteria
being met.

Everything works fine when the list in Col B contains "genuine" e-mail
accounts but if I try to use an existing Outlook Distribution Group instead
e.g. STAFF_ALL_TEACHERS in say cell B2 no message is sent to those recipients.

The group works fine in Outlook if I enter it manually so it's not the group
itself but presumably the syntax I'm using.

I would prefer to use Distribution Groups in my Excel sheet as it reduces
maintenance when changes have to be made.

Any ideas as to how I can make this work?

 

[Ron de Bruin]

Hi nospaminlich

Use this then

.Recipients.Add "STAFF_ALL_TEACHERS"

Instead of To

 

[Guest]

Hi Ron

That's brilliant. Thanks a lot for the response and for the info on your
site without which I would never have been able to get this off the ground