e-mail export

  • Thread starter Thread starter Steve
  • Start date Start date
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.
 
In the subject area of the macro put this
=[Forms]![NameOfYourForm]![report's/form's field]

Jim
 
Back
Top