Is there a way to populate the SUBJECT field of the email with the following:
Forms![fPRList]![SUPPLIER]
i've tried pasting this into the subject field but it doesn't populate correctly only states the expression.
thanks in advance
Is there a way to populate the SUBJECT field of the email with the following:
Forms![fPRList]![SUPPLIER]
i've tried pasting this into the subject field but it doesn't populate correctly only states the expression.
thanks in advance
I would expect that to work, but I don't use macros. Maybe it needs an equals sign at the beginning?
fyi, I deleted your duplicate thread.
great that did the trick
tks