Send to all the email addresses collated in a query

[Guest]

I have developed a pretty simplistic program to track customer prospects. I
have a query which results in a datasheet of all their email addresses. I
would now like to be able to automatically generate an email email to all of
those addresses generated by the query. Can anyone tell me how to get those
addresses in to my email (Thunderbird)?

 

[[MVP] S.Clark]

Solve by the inverse, I think.

Assuming that T-bird has an Export and Import routine, and that the file
that it exports is the same format that it would expect for import... do the
following.

1. From Thunderbird, export a list of contacts to a text file. Open that
text file. Note the structure of the file. Column Names, order, data, etc.

2. Create an Access query to export the data into a format that mimics that
Thunderbird file.

3. Use the Thunderbird import feature to import the Access contacts.

 

[Guest]

Thanks Steve. But what I'm attempting to do is create a command button from
my Access switchboard menu that, when clicked, exports the email addresses
info directly into a blank email (as a recipient string?) . At that point, I
can add pertinent information and/or attachments, and send.

So far, I've been able to create a macro which generates the email addresses
(as text), and auto insert this "object" into the To: field of T-bird.
Problem is that I need the actual address string, not the table "object".

I'm not a programmer, and I've built this database program largely by trial
and error, but I can't seem to figure this one out.
Neil

 

[[MVP] S.Clark]

The SendObject method can help with that.

Docmd.SendObject ...