Email from table

[Stu]

Hi ,
I have an access database which is used to store fees that , at the end of
each month , are summarised and sent out to the relevant people in a hard
copy report format so they are aware of what they owe.
I would like to streamline this process to use email and I have looked at
using a macro to send an email out which includes the report information.
My problem is that I have to specify each individual's email within the
macro or every time I send the mail.
I have approx 100 names in the database and in most cases only 50% will need
to see the report.
I have a table in the db that links the name of the person with an email
address so I wondered if it was possible to use that to only send an email to
the people that owe money ( this could be ascertained by running a query ).
Can anyone help ??

 

[Gijs van Swaaij]

Tricky problem... I am sure that Access does not have a mail function
of itself, but perhaps there are some extensions to Access that can do
this. Anyhow, you'd have to set up your own mail server, which is quite
tricky. Perhaps there are some good mass e-mail programs available
online, but you'd have to check that. Also, if you want to send your
reports via e-mail, you'd either have to export the data to text format
(for which you'll need to write a VBA module), or convert your reports
to PDF.

 

[Douglas J Steele]

Check the EmailSenate and EmailSenate2K samples Arvin Meyers has at
http://www.datastrat.com/DataStrat2.html

 

[BruceM]

Access does in fact have a way of sending e-mail. See Help for
DoCmd.SendObject. Reports can be sent using this function, although I have
not done so and can provide no specific experience-based guidance. I have
used SendObject to send an e-mail without an attachment. If the person's
e-mail address is a field in the record, that field can be placed in the To:
line of the message, but I do not know of a way to send a batch of e-mails
other than to run the code at each record. I'm not saying it can't be done,
because I just don't know. I'm just saying that I do not know of a way.

 

[Arvin Meyer]

Thanks Doug,

Those 2 examples have been recently updated to ignore records with Null
email addresses so that errors will be avoided.

I might also suggest Steve Arbaugh's email class which also works
flawlessly:

http://ourworld.compuserve.com/homepages/attac-cg/acgsoft.htm

and the Microsoft KB article:

http://support.microsoft.com/?id=145787
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access