![]() |
#7
|
||||
|
||||
![]()
If you want to retain the signature, you need to set a range to the start of the message body and paste into that range e.g.
Code:
Option Explicit Private Sub EmailData() Dim OutApp As Object Dim OutMail As Object Dim OutInsp As Object Dim OutDoc As Word.Document Dim oFld As Word.FormField Dim oRng As Word.Range Dim oStart As Range Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) With OutMail .To = "EmailAddressHere" .Subject = "SubjectHere" .Display End With Set OutInsp = OutMail.GetInspector Set OutDoc = OutInsp.WordEditor ActiveDocument.Content.Copy Set oStart = OutDoc.Range(Start:=0, End:=0) oStart.PasteAndFormat Type:=wdFormatOriginalFormatting For Each oFld In OutDoc.Range.FormFields Set oRng = oFld.Range If oFld.Type = wdFieldFormCheckBox Then If oFld.CheckBox.Value = True Then oRng.InsertSymbol _ Font:="Wingdings", _ CharacterNumber:=-3842, _ Unicode:=True Else oRng.InsertSymbol _ Font:="Wingdings", _ CharacterNumber:=-3985, _ Unicode:=True End If Else oRng.Text = oFld.Result End If Next oFld Set oFld = Nothing Set oRng = Nothing Set oStart = Nothing Set OutInsp = Nothing Set OutMail = Nothing Set OutDoc = Nothing Set OutApp = Nothing End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Joachim | Word | 4 | 03-08-2013 01:56 AM |
Copy all comments & cell contents (i.e. data) to word? | IanM | Excel | 0 | 07-03-2010 11:14 PM |
Copy the contents of a dcoument and paste it several times in a new document | Gerjanst | Word VBA | 0 | 06-30-2010 12:51 PM |
![]() |
Dolfie_twee | Word VBA | 1 | 06-22-2010 07:54 AM |
Auto populate formfield from dropdown menu | jmofstead | Word | 0 | 02-26-2010 10:35 AM |