e-mail export

S

Steve

I have created a basic satellite feed logging database. A
report is extracted and posted on our local network
Outlook Public Folders. This is achieved using a macro
and the SendObject command to send a report. This works
OK except that I need to display the contents of one of
the report's/form's fields in the Subject field of the e-
mail so that each e-mail will have a 'report specific'
subject to identify it, instead of a generic subject. Does
anyone have an elegant solution for me. I am a Visual
Basic novice, but quite intimate with normal Access
functions.
Thanks in advance,

Steve.
 
J

Jim/Chris

In the subject area of the macro put this
=[Forms]![NameOfYourForm]![report's/form's field]

Jim
 

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