Macro for customised Email Subject Line Help

[PCRIDE]

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

 

[AOB]

What kind of object are you 'setting' with this line? You appear to be adding your Status as some kind of argument (arg1, arg2) but not knowing the left hand side of the line makes it impossible to know? The equals sign, though, contradicts that, although the error message suggests a multi-argument object, so this is very confusing. Can you provide the full line rather than just the assignment? And also any declaration for whatever is on the left hand side?

Regardless, you have too many brackets in that second argument (one opening, two closing)

Is the Status supposed to be part of the subject, in the same way the ID and Title are?

If so, why not just :

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

As an aside - why complicate matters by including the |X placeholders and then replacing them? Why not just build the string?

="Issue " & Nz([ID], "") & ": " & Nz([Title], "") & " " & Nz([Status], "")

I'm sure I've misunderstood something here though so please post the full line of code and the objects in play...