Query Result to "To" In Outlook Exporess...

[Bob Barnes]

I'd like to use a Query to get 2000 Records with an "Email" Field which is
not Null (no problem writing the Query) sent to Outlook Express in the
Contact or "To" Field...

Have NOT Posted this in Outlook Newsgroup.

Any ideas?

TIA - Bob

 

[Geoff]

Relatively easy to do using Outlook (part of Microsoft Office) because
Outlook supports VBA and Automation.

Can't be done (or, perhaps more strictly, can't be done easily) with Outlook
Express because Outlook Express does not support VBA or Automation. (If it
can be done at all with OE, then you probably need an add-in program of some
kind.)

Geoff.

 

[Bob Barnes]

Geoff,

I am at the Client right now. It wasn't Outlook Express. It IS Outlook. The
Access Query has 950 names, which I can concatenate as a Memo Field. Or,
would I send each Email address to Outlook individually?

Any sample code on the automation? I do a lot of Access-to-Exacl automation.

Thank you - Bob

 

[Geoff]

Hi Bob,

Any sample code on the automation? I do a lot of Access-to-Exacl
automation.

I've got some sample code for you. I've been tidying it up to make it
generic.
I'll let you have Monday.

Regards
Geoff

 

[Tony Toews]

I am at the Client right now. It wasn't Outlook Express. It IS Outlook. The
Access Query has 950 names, which I can concatenate as a Memo Field. Or,
would I send each Email address to Outlook individually?

Any sample code on the automation? I do a lot of Access-to-Exacl automation.

You will need to use VBA code to run through a recordset either:
1) concatenating the email addresses to a string along with a comma,
sem-colon or other appropriate separator character, such as comma or
semi-colon, and then send one email with
all the bcc addresses;
2) individually send the emails.

Your method of sending emails may have some restrictions as to the
number of email addresses in the bcc field or the length of data in
that field.

For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm