tom_blamire
Board Regular
- Joined
- Dec 13, 2012
- Messages
- 99
I have a macro which has a piece of code which is meant to put the value of a cell (name) into the text of the email. For some reason it doesn't want to play nice. Can anyone help me please?.
Code:
To = recip
.Subject = "Cloud Pricing"
.body = "Hi " & Range("B3").Value & vbCrLf & vbCrLf & _
"Please find attached a copy of your estimation for Cloud pricing." & vbCrLf & _
"All prices are valid for 30 days at time of receiving this email." & vbCrLf & vbCrLf & _
"If you have any problems then please let me know" & vbCrLf & vbCrLf & _
"" & vbCrLf & vbCrLf & _
"Kind regards" & vbCrLf & vbCrLf & _
""
.Attachments.Add LWorkbook.FullName
.Display