Form Exporting/e-mailing

  • Thread starter Thread starter Greta
  • Start date Start date
G

Greta

Access 2002...
I have a form that's built off a query.
I need to have this form exported or e-mailed each week
and the boss it's going to wants it to look just like it
does in Access.
I could export it and then e-mail, or directly e-mail, if
I could only get it to stop spreading out all over the
place.
Help.
Greta
 
There are 2 ways that come to mind for exporting and emailing a
report.

1. Output to RTF format. It is a universal format that should be
accessable by any windows machine (maybe even apple too). But, you
will lose some of the graphics that are on the report.

2. Another way is to ouput as PDF file. (My favorite) PDF is a virtual
universal format - just about everyone has Acrobat. The downside is
you have to have a PDF writer on your system to print to. There is a
free opensource way of setting this up. Instruction are here...
http://www.freewebs.com/coandco/faqs/MakePDF_HOWTO_Images.html
I have set this up on many different OSs and it works well.

One more of course is to check out Stephen Lebans site...
http://www.lebans.com/

- Jim
 
I'm not getting it.
I have Adobe...not just the reader...and I can't seem to
get the thing to export into Adobe.
g
 
I have only limited experience with Adobe Distiller, however I believe
it installs a printer just like the method I was mentioning.

To "export" you just print the report on that printer.

I must say that for programming purposes I like the Ghostcript/Redmon
method of creating a PDFWriter (printer) better. It is more straight
forward. Besides it's free!

- Jim
 
Hi Jim

If I want to send it using the sendobject method, how do I get it out as pdf
format?

Thanks
Richard
 
Hi Richard,
First install the PDFWriter "printer". Then print your report using
the PDFWriter. A file will be created in the destination folder that
you specify in the printer properties. Typically, the file will be
named NewPDF.pdf. Just rename the file to what you want and use it as
an attachment. This can be done in code.

- Jim
 
Hi Richard,

Tony Toew's website has a lot about sending reports, etc. as email
attachments. I recommend that you take a look at that:

http://www.granite.ab.ca/access/email.htm

Again, I like the Ghostscript/Redmon link I posted earlier for a
method of installing a PDF writer. I don't think Tony has a link to
that on the page.

- Jim
 
Thanks Jim

--


Jim Allensworth said:
Hi Richard,

Tony Toew's website has a lot about sending reports, etc. as email
attachments. I recommend that you take a look at that:

http://www.granite.ab.ca/access/email.htm

Again, I like the Ghostscript/Redmon link I posted earlier for a
method of installing a PDF writer. I don't think Tony has a link to
that on the page.

- Jim
Click to expand...
 
Back
Top