I keep getting the "An operator is expected here" error message.
To eliminate that specific error message, you can use this expression:
Contact Management::Email Address with Name & ";" & ISO Agent::Email Address
That doesn't guarantee that this will work, however. Since both fields are in two different tables and I do not know what table is "current" (via the current layout), I can't promise that this expression will successfully combine the two values as this depends on valid relationship.
Also, I seem to recall that there was an issue with SMTP emails when the name is included with the email address. You may find you can only use the actual email addresses here.
Your body calculation could be either of these two expressions:
Notes::Text & ¶ & Contact Management::Service Category & ¶ & Notes::Date_Created
List ( Notes::Text; Contact Management::Service Category; Notes::Date_Created)
Again, you are referring to data from two tables. If your current layout is based on Contact management and you have a valid relationship to Notes, this should work.
Here's another issue associated with SMTP emails that you may need to take into consideration:
This is one of many acknowledged bugs that can be found in the Known Bug List thread here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: http://www.4shared.com/file/8orL8apk/FMP_Bugs.html
Okay, I changed up the "To"field slightly. Here's what I have now, and these are all being pulled from the same table.
Contact Management::SNEmail1 & ";" Contact Management::SNEmail2 & ";" Contact Management::SNEmail3 & ";" Contact Management::SNEmail4
I still get the "An operator is expected here" error. Any further tips?
You left out some ampersands (&).
Contact Management::SNEmail1 & ";" & Contact Management::SNEmail2 & ";" & Contact Management::SNEmail3 & ";" & Contact Management::SNEmail4
Cool, thanks again so much for your time.
I have one more for you and then I'll be good - The body:
"** Please DO NOT reply to this email.**
This is a courtesy notification regarding an update on a merchant account. Please contact your representative if further action is required."
I've decided to just include the Notes::Text field along with the standard disclaimer at the top. I'm getting that same operator error here when I click off. I'm sure it's something as easy as the ampersands and semi-colons in the right place but I'm not having luck coming up with the proper combination.
Once again - thank you.
Any chance you could help me out one last time? I would very much appreciate your input. Thanks!
Please post the problem expression so I can see what might be the problem. (Also, the part of your expression that is highlighted by this error is often a key clue as to why you are getting an error message.)
Here's a screen shot of the script...
The highlighted section is in Notes::Text (the bolded section).
Same problem as before. you need an ampersand to concatenate the text in quotes with the text in Notes::Text. That's the missing operator.
Since you likely want Notes Text to not appear immediately after the last period in the quoted text, you probably need to use:
"Text in quotes here" & ¶ & Notes::Text
Thanks again for your help, worked like a charm. Have a great New Year!