Emailing forms

[the bard]

After creating a form within Access 2007, I then have a command button to print off a copy which I fax to a third party. Is it possible to email it directly from within the programme? (Email and print would be even better as I need a hard copy).

 

[DCrake]

Your issue here is not being able to print off a form, it is the fact you should create a report based on the contents of the form then print the report, that what they are there for.

David

 

[the bard]

I need a form as it is an invoice and a form gives me exactly the layout I need.

I have a command button which prints out the form, but I am asking if it is possible to email the form, instead of faxing (using a separate fax machine).

 

[DCrake]

In order to send it electronically you first need to be able to save it in a format that can be opened by the user. Get over that problem then you can look at sending the file as an attachment in an email.

David

 

[the bard]

Is there a command I can use to print and save selection as pdf in file C://XXX ?

 

[suitejudyb]

Hi. Just solved that problem myself after months of printing and scanning. Download a free PDF converter from the internet - something like Cute PDF. To save a form as a PDF go to 'print' and the PDF converter appears in your list of printers. Enter the record number you want to convert and save it in a new folder- it will be in PDF format (it won't actually print). Then you can attach it to an email as you would any other document. That's what happens with mine anyway, dead easy!
Good luck. Judy

 

[the bard]

Brilliant! To make the process even quicker, is it possible to save and print in one go? I need a hard copy as well for filing.

 

[CEH]

If your using 2007, which you stated in your first post, you do not need any additional converter. 2007 has the ability to send in pdf format. I'm not sure how you would do this with a form.... Forms are to input and view data, not meant to be used as a document... Thats what reports are for. If you like how it looks simply design a report to look like your form.
And then Yes, you could make it print and send as an email attachment by clicking one button. You would simply combine onclick event code of the buttons into one button..... something like...

Private Sub cmdPrint_Click()


Dim stDocName As String

stDocName = "rptCurrent"

DoCmd.OpenReport stDocName, acNormal
DoCmd.SendObject acSendReport, stDocName, "acFormatPDF", "email@whatever.com", "", "", , " ", False, ""

something like that. Or if you wanted to keep a separate button for printing you could just use

Call cmdPrint
Docmd.Sendobject..............

 

[suitejudyb]

About saving and printing forms - I've always printed them anyway so now I save a copy as PDF and print one if I still need it. I also use reports and you can convert and save them, and print them in the same way.
I'm using Access 2003 but it's really incredibly simple, no weird codes or anything! Judy