Open Outlook and Reference a Field

[Guest]

I created a database that is being used by several departments. When a
record is created, the user notifies the person in the next department via
email that their is a record ready to be coded. The user will be able to
search for the Item ID that is referenced in the email. When the coding is
complete, the coder notifies the next department via that thier is a record
ready to be audited, etc.

I created a button that lauches outlook so the user does not have to leave
the main entry form.

Right now, the user clicks on the button to open outlook and then has to
enter the # of the Item ID in the body of the message. Is is possible for
the email to automatically reference the current record in the body of the
message which would be the [Item ID] field? So the only thing the user has
to do is send to the appropriate person.

Thanks,
JS

 

[Guest]

JS:

DoCmd.SendObject allows you to specify the body text:

SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject,
MessageText, EditMessage, TemplateFile)

In the MessageText parameter, simply include something like:

...., "Your Item ID is " & Me![ItemID] & ".", ...

Use the "SendNoObject" if you don't have an attachment. Search for
SendObject in VBA help for more details.

Bruce

 

[Guest]

Thank you Bruce for your response. I will give it a try!

JS:

DoCmd.SendObject allows you to specify the body text:

SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject,
MessageText, EditMessage, TemplateFile)

In the MessageText parameter, simply include something like:

..., "Your Item ID is " & Me![ItemID] & ".", ...

Use the "SendNoObject" if you don't have an attachment. Search for
SendObject in VBA help for more details.

Bruce

I created a database that is being used by several departments. When a
record is created, the user notifies the person in the next department via
email that their is a record ready to be coded. The user will be able to
search for the Item ID that is referenced in the email. When the coding is
complete, the coder notifies the next department via that thier is a record
ready to be audited, etc.

I created a button that lauches outlook so the user does not have to leave
the main entry form.

Right now, the user clicks on the button to open outlook and then has to
enter the # of the Item ID in the body of the message. Is is possible for
the email to automatically reference the current record in the body of the
message which would be the [Item ID] field? So the only thing the user has
to do is send to the appropriate person.

Thanks,
JS