Concatenation problem

[dntel123]

Hey,

Can someone tell me the correct syntax for this line of code:

Me![txtBody].Value = "Dear " & strName "This Email is to notify you that you have received grade point " & lstSelectContacts.Column(2, 0) "in " Me!cmbModules.Value

I think im getting the concatenation wrong: or i need to use variables?

Thanks a lot

 

[jardiamj]

You are missing three ampersands the ones are in bold and red.

Me![txtBody].Value = "Dear " & strName [COLOR=Red][B]&[/B][/COLOR] "This Email is to notify you that you have received grade point " & lstSelectContacts.Column(2, 0) [B][COLOR=Red]&[/COLOR][/B] "in " [COLOR=Red][B]&[/B][/COLOR] Me!cmbModules.Value

have a nice day. Cheers!