Patriot2879
Well-known Member
- Joined
- Feb 1, 2018
- Messages
- 1,259
- Office Version
- 2010
- Platform
- Windows
Hi Good morning, please can you help me i have a macro to send an email and for the subject i want to add the text in the textbox2 into the subject heading i have done this in the code below but get an error please can you help?
Code:
With NewMail
.Subject = "Late Outage request - " & ThisWorkbook.Sheets("Sheet1").Range & "Sheet1.TextBox2.Value & """