S
steveconst
most grateful for any help...
I work for a company in which we have three distinct regions - europe
asia, america. we have blanket notifications for three three regions i
which we have to send a chain of three e-mails to a unique group o
e-mail addresses for each region - a notification, update an
resolution.
each region has a unique set of e-mail addresses to send this to. th
three lists are of around 200 addresses each. i have the e-mail list
in unique text files, separated so that i can cut and paste fro
notepad and dump the addresses straight into the 'bcc' field, and the
send. i have the templates set up for the e-mails, and just need to cu
and paste the addresses before sending.
my query is - is there some way to do this automatically, so that i ca
keep the text file (or change it to some other source where i update th
e-mail addresses) updated with the addresses, but run a macro o
something that pulls the addresses and puts them straight in the bc
field?
as i have three separate e-mails to send out each time, i find it'
much easier to maintain one list of addresses per region rather tha
having the addresses already in the bcc fields of the templates. ie.
only have to update the one list of addresses in the text file, rathe
than updating the notificaion, update and resolution templates with ne
addresses.
the issue is that the three global regions need to access thes
templates to send - the templates are stored on our global intranet.
is there an easy solution for this? i hope i have written this in
too-confusing manner...
thanks for any advice
s
I work for a company in which we have three distinct regions - europe
asia, america. we have blanket notifications for three three regions i
which we have to send a chain of three e-mails to a unique group o
e-mail addresses for each region - a notification, update an
resolution.
each region has a unique set of e-mail addresses to send this to. th
three lists are of around 200 addresses each. i have the e-mail list
in unique text files, separated so that i can cut and paste fro
notepad and dump the addresses straight into the 'bcc' field, and the
send. i have the templates set up for the e-mails, and just need to cu
and paste the addresses before sending.
my query is - is there some way to do this automatically, so that i ca
keep the text file (or change it to some other source where i update th
e-mail addresses) updated with the addresses, but run a macro o
something that pulls the addresses and puts them straight in the bc
field?
as i have three separate e-mails to send out each time, i find it'
much easier to maintain one list of addresses per region rather tha
having the addresses already in the bcc fields of the templates. ie.
only have to update the one list of addresses in the text file, rathe
than updating the notificaion, update and resolution templates with ne
addresses.
the issue is that the three global regions need to access thes
templates to send - the templates are stored on our global intranet.
is there an easy solution for this? i hope i have written this in
too-confusing manner...
thanks for any advice
s