Mail merge with excel attachment

[paula]

I need to send a mailmerge email, with a word and excel attachment. I have
created the mail merge email, attach the files in the regular way, and
execute the mail merge, however it does not send the attachements. Can anyone
help?

 

[Doug Robbins - Word MVP]

I am not sure what you mean by "in the regular way" as Word does not have
that capability "out of the box"

See the article "Mail Merge to E-mail with Attachments" at

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


--
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

 

[Graham Mayor]

See the article prepared by fellow MVP Doug Robbins at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Gail]

Could someone run me through the details of the setup of this article?

 

[Doug Robbins - Word MVP]

What part of it don't you understand?

--
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

 

[Gail]

Hi
I do not know how to create a separate Directory type mail merge main doc. I
currently have my data source in an excel doc and have created two separate
columns for my attachments. I them merged this into my word doc, executed it
to a new doc and ran the macro. An error message appear as follows: Compile
error: User-defined type not defined.

 

[Doug Robbins - Word MVP]

The article goes into quite a bit of detail about how the catalog (or in XP
and later, it is called directory) type mailmerge document is set up.

--
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

 

[Gail]

Hi Doug

Not sure you got my reply yesterday so here goes. I have still had no luck.
This is exactly what I do, step by step.


I have my letter in word (Let 1) and my data source in excel (data 1)

In Word I have opened a new doc, I then mail merge – chose directory – used
the current doc – selected recipients – included attachments – executed the
mail merge to a new doc – saved it (gail1) and closed it.

I then. opened the letter (Let 1) I want to send out by email with the
attachments, mailmerge – email message – current doc – selected my data
source (data 1) – included my address block and greeting line – preview email
messaging – executed the mail merge to a new doc – made sure that Microsoft
Office Outlook 11.0 Object Library is selected – ran the macro (which I
copied and pasted).

The following error message: “Compile error: user-defined type not definedâ€
appears and the line “Dim oOutlookApp As Outlook.Application†in the macro is
highlighted.

Hope you can help.

GVP

 

[Doug Robbins - Word MVP]

I posted the following response to your message in another thread yesterday.
You should keep to the one thread so that it is easier to find the
responses.

I don't really know what is causing the reference to be ignored. It is the
first time that I have heard of it happening. In the References dialog in
the Visual Basic Editor, when the Microsoft Office Outlook 11.0 Object
Library is selected, what appears in the lower section of the dialog where
the location of the file is shown?

--
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

 

[Gail]

Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M

Language: Standard

 

[Doug Robbins - Word MVP]

Is this

Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M

all there is?

It should be

Location: C:\Program Files\Common Files\Microsoft Shared\Office
11\msoutl.olb

--
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

 

[Gail]

Yes
--
GVP

Is this

Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M

all there is?

It should be

Location: C:\Program Files\Common Files\Microsoft Shared\Office
11\msoutl.olb

--
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

 

[Doug Robbins - Word MVP]

I gather from your response that you are saying that

Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M

is all there is.

If that is the case, I think that you will need to repair the installation
of Office using the Add/Remove Programs application in the Control Panel.

--
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