use of commas in e-mail function

  • Thread starter Thread starter Lauren B.
  • Start date Start date
L

Lauren B.

I have prompts written throughout my forms that result in the opening of an
e-mail with selected language in the text. As part of the language, I have
fields that automatically populate the e-mail for example:

My e-mail reads: Provider 1 is active.
VBA code reads: [Provider 1] & " is active.",

I need my e-mail to read: Provider 1, State, is active.

I have a State field on my form, and I understand that I need to incorporate
it in my code; however, I do not know how to write the code so that there is
a comma immediately after "Provider 1" and "State"

How do I indicate commas in the text of the e-mail without causing an error
in the code?

Thank you in advance for any assistance.

LB
 
I have prompts written throughout my forms that result in the opening of an
e-mail with selected language in the text. As part of the language, I have
fields that automatically populate the e-mail for example:

My e-mail reads: Provider 1 is active.
VBA code reads: [Provider 1] & " is active.",

I need my e-mail to read: Provider 1, State, is active.
Click to expand...
[Provider 1] &"," &[state] & " is active.",
 
Back
Top