Email Reports

  • Thread starter Thread starter M
  • Start date Start date
M

M

I have a database which has two tables. I have to a send
report as an attachment to 950 email-ids. The problem is I
have to send the same report with different information
to each of these ids simultaneously.

The report gets its information from a query formed by the
join of the two tables.

I want to be able to create a report for each row in the
query and send the information(report) as an attachment to
the corresponding email id's in the query simultaneously.

The other problem is we use groupwise. So i should be able
to send the report as an attachment via groupwise.

Has anyone done anything like this?
 
About mail option:

I don't know about groupwise, but it is MAPI compliant?
I mean, by having groupwise installed, can you e-mail from MS Word, for
example?

If so, I can help you.
I wrote a mail module code which uses MSMAPI.OCX control to allow sending
mail with any MAPI compliant mail client (so the code works with Outlook
Express, MS Outlook, Eudora mail, Netscape Messenger, IncrediMail.

It allows sending mail to as many recipients, either as To, CC or BCC, using
as many attachments as you like, and it also allow logging into MAPI session
if necessary (for example, Outlook Express doesn't require this)

About generating a report for each record in the query, there are several
options:

1. You can open the report in a loop with the Where parameter, filtering on
each ID, to allow you to create the report for a single record, then export
it to Snapshot report, and then attach the outputted report to the e-mail
message. In order to use this approach, it is necessary that your recipients
to have Access Snapshoot viewer installed, to be able to view the
attachment.
2. Another option is to merge your every record with a Word file to generate
the report as Word DOC, then attach it.
This can be done by automating Word and filling the DOC with data from
Access. Then you can attach the Word doc to the e-mail. This option could be
better since there are several users who have Word then those who have
Access snapshoot viewer. And even for those who doesn't have word, you can
include in the body of the message a link to MS Word viewer, which can be
downloaded free.

If you need more info or assistance on this issue, you can e-mail me.

HTH,
Bogdan Zamfir
 
I dont think groupwise is MAPI complaint 'coz i cannot
email from MSWord.

I have to send different attachments to different ppl
based on their id. I want this to be done automaticaaly.
On click on the button the program should be able to get
the id and select the attachment (say "id.rtf") form a
folder ans send an email.

I am not sure how to use the while loop.

Second option will work fine if I have to send multiple
documents to group of ppl but I have to send Seperate
documents to seperate ppl. Like I have to send a.doc to B
and b.doc to A. Not send a.doc,b.doc to A & B.
Am i making any sense?

Thanks
 
M said:
I have a database which has two tables. I have to a send
report as an attachment to 950 email-ids. The problem is I
have to send the same report with different information
to each of these ids simultaneously.

The report gets its information from a query formed by the
join of the two tables.

I want to be able to create a report for each row in the
query and send the information(report) as an attachment to
the corresponding email id's in the query simultaneously.
Click to expand...

See the "Emailing reports as attachments from Microsoft Access" and
"Sample Code illustrating looping through a DAO recordset" pages at
the Access Email FAQ at my website.
The other problem is we use groupwise. So i should be able
to send the report as an attachment via groupwise.
Click to expand...

There are some Groupwise links at the same page..

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
 
Thank you Bogdan Zamfir & Tony. The looping idea and The
sample code for looping really helped. I think my database
will work now.

M
 
Back
Top