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