How to email a batch of reports

  • Thread starter Thread starter Leslie Isaacs
  • Start date Start date
L

Leslie Isaacs

I am using access97, windows 2k.

I have a macro that currently prints out a series of reports.
Is it possible for the same series of reports instead to be output as
attachments to a single email?
I know I could output each report as a file, then create the email and
attatch the files, but this is going to be a very often-repeated process and
it would be much better if the macro could output all the files
automatically as seperate attachments to the single email - ideally picking
up the email address from a form that would be currently open.

I have played around with the SendObject command, but so far have not been
able to achieve what I want.

Hope someone can help.

Leslie Isaacs
West Kirby Health Centre.
 
Leslie,

You need to use Outlook automation; provided you are using Outlook. Are you
using Outlook or some other e-mail program?

Todd
 
Leslie,

The url to Tony Toews website which Chris Reville gave will give you
some relevant information. The short answer to your question is that
this can not be done with macros, and you need to use VBA procedures to
build the list of files you want to attach to your email. Unfortunately
this is not a trivial task.
 
Steve

Thanks for your reply.

I don't think my VBA skills are up to this, so I will need someone to do the
necessary: would you be interested?

Essentially the task would be as follows:

The current form will contain fields [client_name] and
[client_email_address], plus various yes/no fields (represented as
check-boxes) corresponding to various reports. Where the yes/no field is
True, the client requires that corresponding report.
I need to be able to click a button that will output all the required
reports (typically between 4 and 8, out of about 25 'possibles') for the
current client, 'stacked' as attachments to new email opened in Outlook.
Some of the reports would need to be output as excel files - which I have
found can sometimes be problematic with regard to layout (i.e. column
headings). The rest of the reports could be output as excel files or as any
other type most likely to be universally accessable to clients.
Also, it would be extremely useful if one partcular report (one that would
need to be output as an excel file) could also have the 'track changes'
attribute set (by code) to 'true' - ideally just for columns A to G (all
rows) (!). Can that be done?

I should also add that the PCs running the application are running Office97,
whereas some of the clients (to whom the excel and other output is to be
emailed) will be running Office2000 or later.

Please let me know if this is something that you would be willing/able to
do, and if so what other information you would require in order to give me
an indication of likely timescale and cost (I would prefer to work on a
fixed fee basis rather than an hourly rate).

Many thanks
Leslie Isaacs
 
Back
Top