email report using data from a table

[Johannes Oerter]

Hi,

I have the following task where I need some help:

There are several teams of three to four persons.
For each team I have a report in order to give them feedback.
The team-members should receive the individual report by mail.
The address is saved in the database.

How can I let Access send the report to the three/four email-addresses
automatically?

Thank you for your help!!

Jo.

 

[AlCamp]

Johannes,
Use the SendObject function to email your report... in one of several
formats (HTML, Excel, RTF, MSDOS). SendObject uses your "default" mail
program, established in Windows, as the application that sends the report.
If you leave the TO argument in the SendObject blank, your email program
will come up (with the report attached), and allow you to manually send the
report to any individuals or groups that you have pre-defined in your mail
application.
No need to build an email address table/handler in Access.
hth
Al Camp

 

[Johannes Oerter]

Thank you! The thing is, that I have the email only in the database not in
Outlook. And what I want to avoid ist to type any address manually (as I am
going to send different reports to several teams...)
Any idea how that could work?

jo.

 

[AlCamp]

Johannes,
When you use the SendObject method in Access, your access report is
automatically "attached" to an email. You don't have to do anything....
the report doesn't have "to be in Outlook".... Access will take care of all
that.
In the SendObject arguments you can specify, via code, who you want to
send the email TO. Those recipients can come from an Access table, or even
better... you can use "groups" that you've pre-defined in Outlook (which you
can quickly select) during the emailing process.
Study up on the SendObject method, and you'll see that all aspects of the
email (TO, FROM, MESSAGE, CC, etc etc..) can be controlled to suit you're
particular needs.
SendObject will do what you request... so get in there and experiment
with it.... it will work.
hth
Al Camp