By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,401 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

Mail Report

P: n/a
Hi,

When you create buttons from the wizard you can go on report options
and select mail report. This sends a report in a chosen format to the
mail software as an attachment.

There are two issues here the first being is there a way to set it up
where it doesnt list everything in the report. For example I have a
supplier database when the user selects the report they go to a
specfic order from that order they viewed in the form, it doesnt
display every record! Access doesn't give an option to do this when
you use there wizard for creating a mail report.

The second thing is how can I get the mail sofware to display the
suppliers e-mail, this way when the mail software loads up with the
attachment I dont have to keep putting the supplier address in, it
will be automatic.

Any ideas on these two issues?

Thanks Dave.

Feb 9 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Feb 9, 11:19 am, "Dave" <david_l...@hotmail.comwrote:
Hi,

When you create buttons from the wizard you can go on report options
and select mail report. This sends a report in a chosen format to the
mail software as an attachment.

There are two issues here the first being is there a way to set it up
where it doesnt list everything in the report. For example I have a
supplier database when the user selects the report they go to a
specfic order from that order they viewed in the form, it doesnt
display every record! Access doesn't give an option to do this when
you use there wizard for creating a mail report.

The second thing is how can I get the mail sofware to display the
suppliers e-mail, this way when the mail software loads up with the
attachment I dont have to keep putting the supplier address in, it
will be automatic.

Any ideas on these two issues?

Thanks Dave.
I have the same question, I wonder if in the event procedure, you
could refer to a list email addresses? I'm sure there is a way... We
need a pro.

Feb 10 '07 #2

P: n/a
On Feb 9, 1:19 pm, "Dave" <david_l...@hotmail.comwrote:
Hi,

When you create buttons from the wizard you can go on report options
and select mail report. This sends a report in a chosen format to the
mail software as an attachment.

There are two issues here the first being is there a way to set it up
where it doesnt list everything in the report. For example I have a
supplier database when the user selects the report they go to a
specfic order from that order they viewed in the form, it doesnt
display every record! Access doesn't give an option to do this when
you use there wizard for creating a mail report.

The second thing is how can I get the mail sofware to display the
suppliers e-mail, this way when the mail software loads up with the
attachment I dont have to keep putting the supplier address in, it
will be automatic.

Any ideas on these two issues?

Thanks Dave.

I'm guessing that the wizard is using DoCmd.SendObject to mail your
report?
If so, read about it in the help files. It explains how to use this
function - including the mail fields and wether or not it is sent
automatically. At the time of running this proceedure, whatever source
the report uses as a filter or criteria must be availble to it. If it
comes from a form, make sure the form is open when this runs. Your
explanation of what your doing is a little too vague to be more
specific though.

Feb 10 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.