Need to add additional fields to display in e-mail generated from macros in form

[penbell]

Cross posted in forms section



I have taken an existing template (Issue Tracker) and added additional fields such as (but not limited to) Address, FirstName, Last Name, Telephone# and I need to add some of these fields to the e-mail and print function that is in the OnClick properties so that they appear in the e-mail or print that is generated from the command button(s).

In the "Subject" properties of the e-mail, the macros is shown as =Replace(Replace("Issue |1: |2","|1",Nz([ID],"")),"|2",Nz([Title],"")), where and how do I add "address" so that it appears in the subject line of the e-mail that is generated?

I originally posted a thread in the forms forum, I am not a savy Access user and I was unaware if the e-mail was generated from VBA code or Macros but have now determined that it is a Macros. I did receive a response to my query in the "forms" section of these forums however the suggestion did not work.

Thanks in advance!

[pbaldy]

What exactly did not work? Did it produce an error? Incorrect result?

[penbell]

Hi Paul,

There is an error message that pops up when I try to save the changes

The 'EMailDatabaseObject' macro action has an invalid value for the 'subject' argument.

[pbaldy]

And what was that value? I'd try

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

[penbell]

This did not result in an error message but did not give me the desired result, the address field was not added into the subject line in the e-mail.

[pbaldy]

Can you attach the db here?

[penbell]

Attachment 28587 here is the concern tracker (zipped)

[pbaldy]

How does one recreate your issue?

[penbell]

I amended to the subject line as per the attached. In the form I then opened the existing form and clicked on the "e-mail" command button, the e-mail that is generated did not put the address in the subject line.

[pbaldy]

Which form?

[penbell]

In the issues detail form.

[pbaldy]

Well, this argument:

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

produces this subject:

Issue 1: Dog at large at 4823 - 56 Avenue

which seems correct to me.

[penbell]

That looks quite lovely but is not what appears on mine, I must be adding it to the wrong area. Can you advise a step by step process for where I go to add this in to the argument. I was going to the "Issue Details form", changed to "design view", under design view clicked "property sheet", hit the "... "button beside On Click, made the changes and hit save. Changed back to "form view" pulled up an existing form and hit the e-mail command button. Still missing the address on the subject line.

I am sorry to be taking up so much of your time, I have never worked in the back end of the system before.

[pbaldy]

That's what I have in the Subject argument in the embedded macro behind the cmdEmail button on the Issue Details form.