Send Report by email to different people

[Clintimania]

Hello,
I am working on a Support Ticket system and I am working on setting it up where when the admin checks the "complete" box, that the db sends an email to that person letting them know their ticket has been updated.
So far I have most of it in place, but my problem is getting it to send it to the right person. I have a "user name" field on the ticket, so all I need to do is import the username from the form and add the domain on to the end of it. So I am trying it this way with no success.

I have a macro...
SendObject:
Object Type: Report
Object Name: report_email
Output Format: HTML
To: (Forms![Order_admin]![User Name])@scdmh.org

By my current failure, I see that the To: field in a macro does not work like this, but how can I achieve what I am trying to do here. If the username is abc00.. and it was in that field on the form, the macro would then send it to abc00@scdmh.org The form will be open when the macro is run.

If this isnt clear, let me know and Ill explain better.

 

[boblarson]

Change this:

To: (Forms![Order_admin]![User Name])@scdmh.org


to this

To: Forms![Order_admin]![User Name] & "@scdmh.org"

 

[Clintimania]

I put it in, it still says "unknown message recipient(s)" when it tries to send. I have the Order_admin form open and my user name in the User Name field so that it will email me whenever I get it working right. Anything else obvious that I might be missing?

 

[Clintimania]

Woot!

I added an "=" and it worked.

To: =Forms![Order_admin]![User Name] & "@scdmh.org"

Thanks Bob. I would have never put the domain in " " .

 

[Clintimania]

anyone who read what was here, please disregard