Generate an email with selected record pasted as body.

[David]

I have developed a call reporting and tracking database in my environment.
When closing calls and following up, I like to get back to the user with the
information entered into the web page and the resolution/disposition of the
call.

What I'd like to do is create a form where I can, with the addition of a
simple button, copy the open record as the body of an email. I've done this
manually by simply copying and pasting, but I'd like to automate the process
for my other techs. I can do the form fine, but the code for the button
eludes me. Ideas?

Thanks!

Dave

 

[Tony Toews]

I have developed a call reporting and tracking database in my environment.
When closing calls and following up, I like to get back to the user with the
information entered into the web page and the resolution/disposition of the
call.

What I'd like to do is create a form where I can, with the addition of a
simple button, copy the open record as the body of an email. I've done this
manually by simply copying and pasting, but I'd like to automate the process
for my other techs. I can do the form fine, but the code for the button
eludes me. Ideas?

SendObject is the simple answer. For more answers though see the
Access Email FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Derek Brown]

Write a query that extracts the informatio you wnat.

Create a macro that uses the send object action. Send the query to
the name specified