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

email a report copy of a form

P: n/a
I have the user fill in a form and then click a control to send a
notice to the lab that the form has been filled in along with the file
reference number. I'd like to attach a copy of the form to the email.
How do I
1. Autogenerate a report that is an exact copy of the input form.
2. Attach the report directly without saving a copy somewhere.

I'm using Lotus Notes so I think I need to use something like a Select
command on the report to grab something that can be attached. I know I
can save a copy to the local users drive and then attach that but that
seems like a poor way to go about it.

Thanks

Bill

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can create a snapshot report and then email that. They will have to have
the snapshot viewer installed.
Alex

"Bill" <bs****@watlow.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I have the user fill in a form and then click a control to send a
notice to the lab that the form has been filled in along with the file
reference number. I'd like to attach a copy of the form to the email.
How do I
1. Autogenerate a report that is an exact copy of the input form.
2. Attach the report directly without saving a copy somewhere.

I'm using Lotus Notes so I think I need to use something like a Select
command on the report to grab something that can be attached. I know I
can save a copy to the local users drive and then attach that but that
seems like a poor way to go about it.

Thanks

Bill

Nov 13 '05 #2

P: n/a
On 21 Jan 2005 05:21:05 -0800, "Bill" <bs****@watlow.com> wrote:
I have the user fill in a form and then click a control to send a
notice to the lab that the form has been filled in along with the file
reference number. I'd like to attach a copy of the form to the email.
How do I
1. Autogenerate a report that is an exact copy of the input form.
2. Attach the report directly without saving a copy somewhere.

I'm using Lotus Notes so I think I need to use something like a Select
command on the report to grab something that can be attached. I know I
can save a copy to the local users drive and then attach that but that
seems like a poor way to go about it.

Thanks

Bill

Hi
You don't need to convert to a report as you can generate a pdf
decument from the form and then email that.

If you want to do this manually, install a suitable pdf writer (search
Google for CutePDF for a free one) and print the form selecting the
pdf writer as the printer. You will have to provide a name for the
file. Then email the file.

(Note you can do this to anything you can print, it doesn't have to be
a form or in Access)

If you want to do it all automatically search more widely eg for
access outputto pdf

One totally free method to create the pdf file mentioned in this group
by Carol and Doug Hutcheson is to use ghostview and gsprint (see
http://www.cs.wisc.edu/~ghost/gsview/ ) . You can then use one of the
send mail methods with the pdf file as an attachment eg see Tony Toews
site.
David
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.