Question Send email command with a twist

[Joe8915]

I have accomplish everything in sending a object in a email. Now for the twist. In the subject matter, I woud like to include three fields. Is there a way to where I can do this?

For example, lets say the field is call color and in that field I have selected Red. I want red to show up in the Subject matter in the email.

Take any thoughts on how I can do this.

 

[pbaldy]

It would have helped if you posted your existing code, so we knew which method you used. Generally:

strSubject = "You choose the color " & Me.CallColor

In other words, you concatenate fixed text with your fields.

 

[Joe8915]

Paul, thanks for the quick reply. Ok let me try this again (my fault). I want to send an email out. I want in the subject line of the email the field color to end up in the subject line.
Here is the bottom line. IF I have three fields in my form, I want those to show up in the subject line of the email. I don't think it’s possible myself.

 

[pbaldy]

Why not?

strSubject = "You choose the color " & Me.CallColor & " plus a shape of " & Me.Shape & " and a whatever of " & Me.Whatever

 

[Joe8915]

Paul, see the attach in what I am referring to. Also thanks for being so patience with me.

 

[pbaldy]

That looks like the email; what's the code that creates it?

 

[Joe8915]

I just use the macro "send object"

 

[pbaldy]

I don't use macros, but try this type of thing in the subject:

"You choose the color " & Forms!FormName.CallColor & " plus a shape of " & Forms!FormName.Shape & " and a whatever of " & Forms!FormName.Whatever

 

[stopher]

I don't use macros, but try this type of thing in the subject:

"You choose the color " & Forms!FormName.CallColor & " plus a shape of " & Forms!FormName.Shape & " and a whatever of " & Forms!FormName.Whatever

You might need to put = at the beginning

[COLOR="Red"]=[/COLOR]"You choose the color " & Forms!FormName.CallColor & " plus a shape of " & Forms!FormName.Shape & " and a whatever of " & Forms!FormName.Whatever

 

[pbaldy]

Thanks stopher; a brief test reveals that you do need the =. Warned you I didn't use macros!