![]() |
#1
|
|||
|
|||
![]()
Hi Guys,
I have a small form and added an email button to assist clients to submit it easier and to structure the subject lines Code:
Private Sub CommandButton1_Click() Dim OL As Object Dim EmailItem As Object Dim Doc As Document Application.ScreenUpdating = False Set OL = CreateObject("Outlook.Application") Set EmailItem = OL.CreateItem(olMailItem) Set Doc = ActiveDocument Doc.Save With EmailItem .Subject = "SUBJECT LINE" .Body = "BODY MESSAGE" & vbCrLf & _ "SECOND LINE BODY MESSAGE" & vbCrLf & _ "THIRD LINE BODY MESSAGE" .To = "TEST@EMAIL.COM" .Importance = olImportanceNormal .Attachments.Add Doc.FullName .Display End With Application.ScreenUpdating = True Set Doc = Nothing Set OL = Nothing Set EmailItem = Nothing End Sub I am new to VBA, so I really don't know what I am doing and used google to help. What I want to do is use information users enter. So I have a uch of content controls for example "date1, commodity, location" etc. Is there a way I can use the information entered into the fields to form a subject line? |
|
![]() |
||||
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 |
![]() |
rparker85 | Outlook | 3 | 12-12-2011 10:26 AM |
Batch adding text to email subject lines in Outlook | paulkaye | Outlook | 0 | 12-05-2011 06:38 AM |
Adding fields to a calendar event beyond subject and location | willauqs | Outlook | 0 | 07-08-2011 01:10 PM |
![]() |
namishtiwari | Outlook | 1 | 04-21-2009 11:21 PM |