Insert merge fields from list in the Subject line

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TimE - 06 Jun 2006 23:32 GMT

Is it possible to insert a merge field into the subject line?

Reply to this Message

Doug Robbins - Word MVP - 07 Jun 2006 04:53 GMT

It can be done using a modification of the method in the article "Mail Merge
to E-mail with Attachments" at:

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Is it possible to insert a merge field into the subject line?

Reply to this Message

TimE - 07 Jun 2006 17:59 GMT

Thank you Doug.

I think I understand what needs to be done, but I get an error when running
the macro.

Compile Error:
User-defined type not defined

Dim oOutlookApp As Outlook.Application

From this section of code:

Dim Source As Document, Maillist As Document
Dim Datarange As Range
Dim Counter As Integer, i As Integer
Dim bStarted As Boolean
Dim oOutlookApp As Outlook.Application
Dim oItem As Outlook.MailItem
Dim mysubject As String, message As String, title As String

Again, thank you for your assistance.

> It can be done using a modification of the method in the article "Mail Merge
> to E-mail with Attachments" at:
>
> http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
>
> > Is it possible to insert a merge field into the subject line?

Reply to this Message

Doug Robbins - Word MVP - 08 Jun 2006 04:45 GMT

That is because you did not follow the instructions and set the reference to
the Outlook Object Library.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thank you Doug.
>
[quoted text clipped - 26 lines]
>>
>> > Is it possible to insert a merge field into the subject line?

Reply to this Message