Re: OT: Netiquette and Programatically Emailling Attachments

Tim Marshall <TIMMY!@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I've googled on how to email pdfs and found some good information on
what is (I think) late binding of the Outlook model to an A2003
application I've developed to email reports. The concept is that my app
creates numerous reports on accounts and, for each account, a pdf is
generated. Then, based on the email for the financial manager listed,
the app emails them all the pdfs for which they are listed as a
financial manager.

Why not email them one PDF file containing one report for all the accounts for which
they are financial manager? That should just be a slightly different Where clause.

Can anyone offer a suggestion as how to best handle this? Sending
individual emails for 40 odd reports that one manager might get seems
pretty awful, but so too does a single email with 40 odd attachments!
Or is the latter option as horrible as it seems? Limit it to 5 (or some
number) attachments per email?

I think most email software wouldn't do a good job of displaying that many
attachments efficiently.

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
.

Relevant Pages

  • Re: OT: Netiquette and Programatically Emailling Attachments
    ... Store the preferences. ... Another is to put the reports on the Intranet, ... Then, based on the email for the financial manager listed, ... but so too does a single email with 40 odd attachments! ...
    (comp.databases.ms-access)
  • OT: Netiquette and Programatically Emailling Attachments
    ... I've googled on how to email pdfs and found some good information on what is late binding of the Outlook model to an A2003 application I've developed to email reports. ... Then, based on the email for the financial manager listed, the app emails them all the pdfs for which they are listed as a financial manager. ... Most managers will receive one, or at most, two reports, ie, two attachments in an email. ...
    (comp.databases.ms-access)
  • Re: The ugly side of business - long
    ... The ugly side of business - long ... It has always been my understanding that with each upgrade in Quickem that ... seperate accounts for net worth reports. ... mix business accounts with personal accounts. ...
    (rec.woodworking)
  • RE: Need help with Elseif statement
    ... reports/cobinations, still the mapping of accounts are a pain, but a user can ... > who was hired to just set up reports. ... Because this is a very large city, accounts are added ... >> table and then to the one with the common description, group the query by the ...
    (microsoft.public.access.queries)
  • RE: Need help with Elseif statement
    ... who was hired to just set up reports. ... exceptions in some of the accounts which I didn't go into (example: ... > 411XXX Property Taxes $10,000.00 ... > table and then to the one with the common description, group the query by the ...
    (microsoft.public.access.queries)