Emailing Just ONE Record

[HLTAYLOR]

We want to inlcude a button on a form that will open an Outlook message showing only that ONE record. I've seen lots of blogs about this out on the web, but they all involve VBA, and I'm a Macro Girl . I do not know how to work in VBA. Any help?

[rpeare]

Are you saying you are not going to use VBA you only want to use Macros or are you saying you need help with the VBA

[HLTAYLOR]

Thanks for your reply. I'm saying that I don't know how to use VBA, so I would rather use macros. But if the VBA were simple enough to where I could just substitute my form name into it, I think I could do it.

[rpeare]

I'm assuming you've got the record you want to send on your form when you click your button.

Are you talking about sending a report, a file attachment or something like a screen shot of the record in the body of the email.

The first two are relatively easy, the third I've never tried but may be possible.

Is the email recipient always the same or is that meant to be filled out by the operator before the email is sent?

[HLTAYLOR]

I really want a pdf or some sort of "picture" of the form, since the email is a reminder to fill it out. The addressee will be filled in by the sender.

[rpeare]

here's a method to create a screen shot file:

http://stackoverflow.com/questions/2...ccess-with-vba

The other method is to export your form to a PDF similar to what you'd do with a report, however you should be aware that if you are using a continuous form it'll print ALL the items in the subform, not just the one you've got your cursor on.

as long as you're only sending one attachment per email you can use the SENDOBJECT command to send the email with an attachment fairly easily, here's a reference:

http://www.fmsinc.com/microsoftacces...endobject.html

[HLTAYLOR]

My form is 2 pages long, so I wouldn't be able to use the screenshot, correct?

[rpeare]

to email a single record or screen shot a single record, probably not

You can likely pick the information you want from the record you want and email that rather than trying to screen shot/pdf a document though.

[HLTAYLOR]

I got it! I made a report that looked exactly like the form. I made a button on the form that, when clicked, runs a parameter query for the info for that record, and puts it in my look-alike form. Then I used EmailDatabaseObject to create an email with an attached pdf of the form. Thanks for all the help!