use of commas in e-mail function

[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

 

[Andi Mayer]

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.

[Provider 1] &"," &[state] & " is active.",