Generate word document, generate email, search field

[plomikrz]

Hi,
I'm new to MS access and know nothing about VBA programming. I'm trying to create a database wich will enable me to do the following things in a form:
- search for a record by any of the field value
- button that generates a word document according to current record and sends it directly to a default printer. I'd like this button to add a date in one of the fields in current record
- button that generates an email with specific function mailbox in "From" field. This generated email should use an email template and fill in 2 fields from the database

Does anybody have any working solution for those functions? I tried to google it, but there is no solution when I get to the details as sending to a printer or including specific mailbox in From field.



I would appreciate your help.

BR,
Krzysztof

[ranman256]

Word is not needed, Access has a built in report document designer, print with 1 command:
docmd.openReport "rMyReport"

Put the date in a form and sending email can be done with 1 command:
Docmd.sendObject acSendForm, "fMyForm", acFormatPdf, sTo,,,sSubj, sBody