Printing or faxing a report

  • Thread starter Thread starter andrea
  • Start date Start date
A

andrea

Hi All

I have set up a report which pulls customer information
from the customer table - including the customer email
address and fax numbers.
I would like to email the report to the customer (with
the email address picking up from the report), email to
myself and automatically put a constant expression in the
subject line.
Then, if the customer does not have an email address the
report should be faxed to them instead(fax number being
picked up from the report).
If anyone could help me with the code that would be
fantastic! If you could keep it simple as I'm very new to
all this that would be great
Thanks
 
Andrea,
I take it you have a form that allows you to select a Customer to report
on. On that form you should have an EmailAddress field and a Fax field, and
any other information about the customer that you'll need to send the email.

First, use the SendObject method to email the report to yourself. (ex.
YourEMailReport)

Next, if the form has an EmailAddress value, then use the SendObject
method to send the report, via email, to the customer... just the same way.

SendObject allows you to use Dynamic Subjects... Subjects that get their
value from field values and/or variables on your form.
ex. Subject argument... "Dear " & [FirstName] & " here's that Email
you requested."

OR... if EmailAddress is null, then open a different report (ex.
YourFaxReport... one that uses the fax as the printer), and send the fax
instead.
hth
Al Camp
 
Back
Top