Send Single Record From Form

[kristijo]

Hi,
I would like to be able to place a button on my invoice form that will allow me to e-mail the individual invoice to the person being billed (the e-mail address is included on the form). I created a macro that works to send a PDF file of all of the records and I am having trouble figuring out how to send just the current record. I would also like to have the e-mail address automatically populated based on the e-mail address on the current record.

I am pretty new to Access so the simpler the solution the better

Thank you!
KJO

[June7]

Forms are intended for screen viewing. Reports are intended for printing. Build a report. Apply filter to report when opening.

Do you want to include record info in the body of the email or do you want to attach the record as a PDF?

[kristijo]

Forms are intended for screen viewing. Reports are intended for printing. Build a report. Apply filter to report when opening.

Do you want to include record info in the body of the email or do you want to attach the record as a PDF?

I built the invoicing system using the book Learning MS Access by Greg Bowden. The step-by-step process included building the invoice form which prints in the format I want. Now, I want to be able to e-mail each individual record as a PDF.

Any ideas?

Thanks,
KJO

[June7]

A report is the best vehicle for output to printer or PDF. A form can be made to do this but usually not as nice. Either way, must filter to the single record you want to output.