SendObject - not as an attachment

[Matt Garndner]

I am trying to create a macro that will send a record from a form to a
specific email address. I am using SendObject, at this works the way that it
should, but I DO NOT want the record to be sent as an attachment.

I would like for it to appear in the body of the email!

Is this possible?

Thanks in advance!

 

[Steve Schapel]

Matt,

No, this is not possible with a macro. You will need to use a
third-party email control, such as the Total Access Emailer from
www.fmsinc.com, or use Automation code in a VBA procedure. Having a
look through here mightr point you in the right direction...
http://www.granite.ab.ca/access/email.htm

 

[Zadok @ Port of Seattle]

Put the fields you want in the Message Text field (an Action Argument for the
Send Object macro command).

ex.
=[Forms]![frmName]![Field1]

It's pretty basic but surely better than a clunky attachment.
Zadok

 

[Sandy]

This worked for me.

To make this more flexible, I created a field on my form that concatenated
all the data I wanted to send. You can insert text, URLs and other content as
well.

Here is an example:

=[firstname] & " " & [lastname] & " has applied for the positon of " &
[position] & ". Please open the Resumes database at [\\resumes\database] to
review this resume. Please also update the tracking tab."

This allows you to reference only one field -- [Field1] in the example
below-- and avoid a sting too long error.

Hope this helps!
sandy