Macro for customised Email Subject Line Help

pcride

Registered User.
Local time
Today, 11:03
Joined
Nov 28, 2008
Messages
43
Hi, I have a Form, user presses a button to launch Outlook and populate an email. The subject currently has

=Replace(Replace("Issue |1: |2","|1",Nz([ID],"")),"|2",Nz([Title],""))

I need to add another field to this called Status. But simply adding the last bit of code bolded there, I get an error, maybe I am just missing something simple?


=Replace(Replace("Issue |1: |2","|1",Nz([ID],"")),"|2",Nz([Title],"")) ,Nz([Status],""))

Error

"The 'Email Database Object' macro action has an invalid value for the 'Subject' argument
 
Thanks. Yea I don't know what it means. I downloaded an access db template for meeting notes. You would think by just adding a new field using the same syntax would work,but I think I am missing a , or " or ) is all.
 

Users who are viewing this thread

Back
Top Bottom