?
- -
Hi gang
I am having some problems with Access > Outlook emailing. I've read many
documents about Recordsets and the such, but still cannot overcome this
issue:
I have a table named Contacts which holds a field called EmailAddress . I
have worked out how to email the current record in the table by passing the
address through to Outlook. From time to time, I wish to email the entire
table (a mass e-mailout if you like), and have accomplished this to a
certain extent, whereby Access works through the recordset and generates a
seperate email for each contact. However, I'd like Access to pass through
all the address to the BCC field of ONE email.
Could anyone help me with this, as I'm tearing my hair out on this one!!!
NB, not all records have an email address filled in, so some sort of NULL
rule would be required I guess.
Thankyou in advance
Matt
I am having some problems with Access > Outlook emailing. I've read many
documents about Recordsets and the such, but still cannot overcome this
issue:
I have a table named Contacts which holds a field called EmailAddress . I
have worked out how to email the current record in the table by passing the
address through to Outlook. From time to time, I wish to email the entire
table (a mass e-mailout if you like), and have accomplished this to a
certain extent, whereby Access works through the recordset and generates a
seperate email for each contact. However, I'd like Access to pass through
all the address to the BCC field of ONE email.
Could anyone help me with this, as I'm tearing my hair out on this one!!!
NB, not all records have an email address filled in, so some sort of NULL
rule would be required I guess.
Thankyou in advance
Matt