How do I mail merge from Word to Outlook with merge subject field

HELP!!

I have a mass email I need to send with personalised contents from an Excel
database. I have created the merge from Word all fine, but now I need to
insert merge fiels into the email subject line - is this possible to do to
send from Word doc to Outlook?

It can be done with MAPILab's Mailmerge toolkit add-in for Outlook
http://www.mapilab.com/outlook/mail_merge/ See if the trial version works
for you.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Alex wrote:
HELP!!

I have a mass email I need to send with personalised contents from an
Excel database. I have created the merge from Word all fine, but now
I need to insert merge fiels into the email subject line - is this
possible to do to send from Word doc to Outlook?

If you are familiar with VBA, you can use Word's MailMerge events and
VBA to specify the subject for each email.

e.g. in the VBA Editor, Insert a new Class Module, name it
EventClassModule, and insert the following code:

Public WithEvents App As Word.Application

Private Sub App_MailMergeBeforeRecordMerge(ByVal Doc As Document, Cancel
As Boolean)

' set this to be the exact name (uppercase/lowercase are significant
here) of the field you want to use
Const strSubjectFieldName = "mysubjectfield"
Doc.MailMerge.MailSubject = _
Doc.MailMerge.DataSource.DataFields(strSubjectFiel dName).Value
End Sub

In an ordinary module, put the following VBA

'---
Dim x As New EventClassModule

Sub MergeWithEvents()

EnableEventHandler

' Do the merge
ActiveDocument.MailMerge.Execute Pause:=False

' The events fire for all documents
' so disable them
DisableEventHandler

End Sub

Sub EnableEventHandler()
Set x.App = Word.Application
End Sub

Sub EnableEventHandler()
Set x.App = Nothing
End Sub
'---

Then, with your mail merge main document open, run the MergeWithEvents
subroutine to run your merge

Peter Jamieson

http://tips.pjmsn.me.uk

Alex wrote:
HELP!!

I have a mass email I need to send with personalised contents from an Excel
database. I have created the merge from Word all fine, but now I need to
insert merge fiels into the email subject line - is this possible to do to
send from Word doc to Outlook?