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? |
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 |