Attach member billing to email addresses

[destinman via AccessMonster.com]

I have written a program I am selling to Chamber of Commerces. I want to
attempt to add a feature where a user can email member billings via an email
attachement. Can someone direct me to someone or something that can give me
some guidance how to accomplish this. There may be a couple of hundred
emailings in one billing month. Any help would be grealy appreciated.

 

[Tony Toews [MVP]]

I have written a program I am selling to Chamber of Commerces. I want to
attempt to add a feature where a user can email member billings via an email
attachement. Can someone direct me to someone or something that can give me
some guidance how to accomplish this. There may be a couple of hundred
emailings in one billing month.

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

For sending multiple emails you will need to use VBA code to run
through a recordset either:
1) concatenating the email addresses to a string along with a comma,
sem-colon or other appropriate separator character, such as comma or
semi-colon, and then send one email with
all the bcc addresses;
2) individually send the emails.

Your method of sending emails may have some restrictions as to the
number of email addresses in the bcc field or the length of data in
that field.

For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.htm

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/