Mailing to a distribution group in Excel
 

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?

Mailing to a distribution group in Excel
 

Hi nospaminlich

Use this then

.Recipients.Add "STAFF_ALL_TEACHERS"

Instead of To

--
Regards Ron de Bruin
http://www.rondebruin.nl



"nospaminlich" wrote in message ...
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?

Mailing to a distribution group in Excel
 

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

"Ron de Bruin" wrote:

Hi nospaminlich

Use this then

.Recipients.Add "STAFF_ALL_TEACHERS"

Instead of To

--
Regards Ron de Bruin
http://www.rondebruin.nl



"nospaminlich" wrote in message ...
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?