Microsoft Office Forums - View Single Post - How do you add a line from a fillable word document into a VBA that you are using to email out

gmaxey · 09-28-2020, 08:04 AM

What are you using as the "fillable" field? If you use as content controls titles say "Author" then you could use:

Code:

sMsgBody = sMsgBody & "Please find attached my completed referral form for a woman to your services" & vbCr & vbCr
     sMsgBody = sMsgBody & "Kind Regards," & vbCr
sMsgBox = sMsgBody & Doc.SelectContentControlsByTitle("Author").Item(1).Range.Text

     .body = sMsgBody