Forum Discussion
Value from Cell to Autofill Email
Hi, I'm going to start by saying I'm a total noob on excel so apologies if this is a dumb question. Basically I'm trying to make a tool where you fill in a form, click a button and the data from...
That would be
emailItem.Body = "Hello," & vbNewLine & vbNewLine & "Please be advised quote number: " & Range("D4").Value & " has been accepted in our system"
Note that I added spaces in the strings before and after the value of D4.
If the name Lyle (or whatever) is in E4, it could be
emailItem.Body = "Hello " & Range("E4").Value & "," & vbNewLine & vbNewLine & "Please be advised quote number: " & Range("D4").Value & " has been accepted in our system"
I'll give that a try! Thank you so much for your help 🙂