Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
How do i set up a normal distribution in excel? | New Users to Excel | |||
how do i convert MS Word mailing labels into an Excel mailing lis. | Excel Discussion (Misc queries) | |||
Selecting Distribution List when Mailing from Excel | Excel Programming |