473,320 Members | 1,991 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

email a report copy of a form

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
2 2169
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Chuck Farah | last post by:
I am unsuccessfullly trying to display an outlook email from a vb web forms (.net) outlook 2002 #1. is it possible to use outlook client email from a web form using the outlook object model...
2
by: Bob Quintal | last post by:
I have a report that prints a single record. Normally it's enter one record, then print it. This works great. New requirement: Each record needs to be printed to an individual ..pdf file from...
3
by: Lore Leuneog | last post by:
Hello Which command do I've to use to set the focus on a control placed on a report in Design-View. Ctrl.SetFocus and Cmd.GoToControl don't work for a report. The aim is to copy the control...
1
by: Nathan Bloomfield | last post by:
Does anyone know if there is any documentation which relates to Access2k + ? or can anyone help adjust the code? I am having trouble converting the DAO references. TITLE :INF: How to...
3
by: Saintor | last post by:
I have a record with with a quantity value. I have to print one record for each quantiy with a counter, incrmementing on each copy. I wan't to avoid to use many docmd.openreport instructions. ...
1
by: CrostonScottish | last post by:
I have this code which generates an email for new records that have not been sent before. I want to alter it so it will attach a copy of the record formatted as a report which looks loosly like the...
3
by: Richard Hollenbeck | last post by:
I am very sorry about the (almost) re-post, but you will see that my first question wasn't very clear; I have another question I posted this morning called, "in DAO: Run time error 3061 Too few...
3
by: creative1 | last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however,...
3
by: jambonjamasb | last post by:
Hi I have two tables: email_tbl Data_table Data table is is used to create a Form Data_form
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.