Printing or faxing a report

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
 
A

AlCamp

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top