Automatically Email Individual Reports to a group of Suppliers

[FSHOTT]

I have a table of groups of suppliers (tblSupplierGroups) that contain the
fields GroupName and SupplierID. Also I have a table of SupplierEmailInfo
(tblSupplierEmailInfo) that contains the fields SupplierID,
SupplierContactName & SupplierEmailAdd (Address).
I then have a Supplier report (rptSupplierReportCard) which is a monthly
summary of supplier results i.e. summary of supplier shipments received for
the month (on-tome, late, rejects). I have a report which allows the user to
select the Year, Month & SupplierID for these reports.
What I want to do is create a form that will allow a user to select a group
of suppliers from the above table and then create an individual reports for
each supplier in the group (for the selected years & months) and then Email
them to the respective supplier contact.
I have been reading several discussion group responses on this subject and
am now at the point where I am thoroughly confused. In the articles I have
been reading they say there is no easy way to get around the MS Outlook
Security patch. I found an article on using the Windows XP CDO messaging as
any alternative but do not know if this is usable. Also I need to be able to
check for null or empty SupplierReportCard reports for the selected
SupplierID, Year(s) & month(s). I appreciate any help I can get on this.
Thank You in advance.

 

[Mark Andrews]

You could checkout our email module
http://www.rptsoftware.com/products/email/
it has examples very similar to what you want to do.

Our code works with a third party dll (I prefer that method instead of
dealing with Outlook), however you could tweak the code a little and use
Outlook if you wanted to as well. Others will have to answer all the
conditions and senerios if you decide to use Outlook for sending email.

I personally find smtp dlls easier to work with (with more functionality),
just my opinion. The email module code provides a good basis for creating
batch reports in various ways and emailing them with user defined templates.

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com

 

[FSHOTT]

Mark Thank You for the feedback. My objective is to learn how to do this
myself.

 

[Mark Andrews]

Reading the manual that comes with our software should shed some light on
how we approached it.
Also running the demo would give you a feel for possible approaches.
Note: if you purchase some source code you are still building the
application yourself.
Perhaps, add up the hours you spend at the end of figuring it all out and
multiply by your hourly wage
to see how much it costs to figure it out.

Not trying to say anything is wrong with putting the work in, sometimes you
learn it better that way,
Just that time vs. money should always be a consideration,
I wish you luck in your endeavors,
Mark

 

[chong]

Reading the manual that comes with our software should shed some light on
how we approached it.
Also running the demo would give you a feel for possible approaches.
Note: if you purchase some source code you are still building the
application yourself.
Perhaps, add up the hours you spend at the end of figuring it all out and
multiply by your hourly wage
to see how much it costs to figure it out.

Not trying to say anything is wrong with putting the work in, sometimes
you learn it better that way,
Just that time vs. money should always be a consideration,
I wish you luck in your endeavors,
Mark

 

[Tony Toews [MVP]]

What I want to do is create a form that will allow a user to select a group
of suppliers from the above table and then create an individual reports for
each supplier in the group (for the selected years & months) and then Email
them to the respective supplier contact.

There are two separate issues here.

1) How to create individual reports

1a) For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

1b) See the Sample Code illustrating looping through a DAO recordset
page at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

1c) You probably want to send the reports as PDF files
Creating PDF files from within Microsoft Access
http://www.granite.ab.ca/access/pdffiles.htm

2) How to email the reports as files
Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony