![]() |
|
#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? |
|
|
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 |
| 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 |
getting additional characters in email subject line
|
namishtiwari | Outlook | 1 | 04-21-2009 11:21 PM |