Including Text Form Field info in the subject line of an email

Gadget · #1 09-08-2016, 11:22 AM

Am using the following to send a Word form as an email:

Private Sub Document_New()
Options.SendMailAttach = True
ActiveWindow.EnvelopeVisible = True
With ActiveDocument.MailEnvelope.Item
.Subject = "Hospitality Services Request Form - [Name of Lawyer]"
.Recipients.Add "#Room Booking - HFX; #Housekeeping"
End With

If ActiveWindow.View.TableGridlines = True Then
ActiveWindow.View.TableGridlines = False
End If
End Sub

Is there a way to include information a user types into a Text Form Field (Bookmark name: bkLawyer) in the subject line of the email?

macropod · #2 09-08-2016, 08:43 PM

You might try something along the lines of:

Code:

Private Sub Document_New()
Options.SendMailAttach = True
ActiveWindow.EnvelopeVisible = True
With ActiveDocument.MailEnvelope.Item
  .Subject = "Hospitality Services Request Form - " & _
    ActiveDocument.Bookmarks("bkLawyer").Range.Text
  .Recipients.Add "#Room Booking - HFX; #Housekeeping"
End With
ActiveWindow.View.TableGridlines = False
End Sub

However, given it's a Document_New macro, it's not apparent to me that your 'bkLawyer' bookmark would have any meaningful content at that stage.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Including Text Form Field info in the subject line of an email	Gadget	Word	0	09-08-2016 10:55 AM
Outlook - Add text to subject line when sending a reply email	rparker85	Outlook	3	12-12-2011 10:26 AM
Copy plain text message including sender, recipient, and subject	distancesprinter	Outlook	0	01-22-2010 12:49 PM
How can I fill in form I received in email that used underlines instead of text field	Gail L.	Word	2	05-17-2009 12:38 PM
getting additional characters in email subject line	namishtiwari	Outlook	1	04-21-2009 11:21 PM