What e-mail client are you using? If, for example, you're using Outlook, you
should be able to automate it so that it's not necessary to include an
attachment. If, however, you're using Outlook Express (or Windows Mail),
automation isn't possible.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"sweeneysmsm" wrote in message
...
Mr. Meyer's sample worked just fine with the necessary adaptation. Thank
you
so much. I guess I had hoped for one that I could just use to send e-mail
but
perhaps in Access one always has to structure the initial form to send an
"object". I can always have them delete the attachment later.

Thank you for your help.

Mary

"Douglas J. Steele" wrote:

See whether Arvin Meyer's EmailSenate2K at
http://www.datastrat.com/DataStrat2.html meets your needs.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"sweeneysmsm" wrote in message
...
I have created a membership database for an organization. There is a
field
for Member's e-mail address.

Is there a way to send an e-mail to ALL memberS or certain memberS
based
on
a query (e.g. a notice) from Access? If so, how does one set this up.

Any insight greatly appreciated.

Mary