Exporting specific data from an access record into a mail message

A

al

Hi,

Is there a way I can have certain fields from a particular
record on an access database appear on a new mail message
automatically.

I have a call logging system created in access, I wish to
sometimes have the call log number and the problem appear
on the message body of a new mail message, so I can send
this to my boss.

I can do the sendobject property, to sent the call as an
attachment, but I would prefer to just send data from a
couple of fields and have it appear on a new mail message
automatically, instead of me having to type a new mail
message and copy the data from access to the mail message
body.

Is there some VBA code that would allow me in Access or
outlook to be able to automate this process.

Any help would be much appreciated.

Al.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top