Mail merge with excel attachment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

paula - 27 Jun 2006 11:30 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 27 Jun 2006 12:24 GMT

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

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

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

Reply to this Message

Graham Mayor - 27 Jun 2006 12:42 GMT

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

Signature

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

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

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

Reply to this Message

Gail - 27 Jul 2006 12:18 GMT

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

Signature

GVP

> See the article prepared by fellow MVP Doug Robbins at
> http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
[quoted text clipped - 3 lines]
> > way, and execute the mail merge, however it does not send the
> > attachements. Can anyone help?

Reply to this Message

Doug Robbins - Word MVP - 28 Jul 2006 18:29 GMT

What part of it don't you understand?

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

> Could someone run me through the details of the setup of this article?
>
[quoted text clipped - 5 lines]
>> > way, and execute the mail merge, however it does not send the
>> > attachements. Can anyone help?

Reply to this Message

Gail - 31 Jul 2006 11:40 GMT

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.

Signature

GVP

> What part of it don't you understand?
>
[quoted text clipped - 7 lines]
> >> > way, and execute the mail merge, however it does not send the
> >> > attachements. Can anyone help?

Reply to this Message

Doug Robbins - Word MVP - 31 Jul 2006 12:05 GMT

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.

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

> Hi
> I do not know how to create a separate Directory type mail merge main doc.
[quoted text clipped - 19 lines]
>> >> > way, and execute the mail merge, however it does not send the
>> >> > attachements. Can anyone help?

Reply to this Message

Gail - 02 Aug 2006 11:10 GMT

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

> 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.
[quoted text clipped - 22 lines]
> >> >> > way, and execute the mail merge, however it does not send the
> >> >> > attachements. Can anyone help?

Reply to this Message

Doug Robbins - Word MVP - 02 Aug 2006 18:26 GMT

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?

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

> Hi Doug
>
[quoted text clipped - 61 lines]
>> >> >> > way, and execute the mail merge, however it does not send the
>> >> >> > attachements. Can anyone help?

Reply to this Message

Gail - 03 Aug 2006 15:25 GMT

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

Language: Standard

Signature

GVP

> 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
[quoted text clipped - 71 lines]
> >> >> >> > way, and execute the mail merge, however it does not send the
> >> >> >> > attachements. Can anyone help?

Reply to this Message

Doug Robbins - Word MVP - 03 Aug 2006 20:08 GMT

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

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

> Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M
>
[quoted text clipped - 83 lines]
>> >> >> >> > way, and execute the mail merge, however it does not send the
>> >> >> >> > attachements. Can anyone help?

Reply to this Message

Gail - 04 Aug 2006 08:29 GMT

Yes

Signature

GVP

> Is this
>
[quoted text clipped - 94 lines]
> >> >> >> >> > way, and execute the mail merge, however it does not send the
> >> >> >> >> > attachements. Can anyone help?

Reply to this Message

Doug Robbins - Word MVP - 04 Aug 2006 21:24 GMT

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.

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

> Yes
>
[quoted text clipped - 110 lines]
>> >> >> >> >> > the
>> >> >> >> >> > attachements. Can anyone help?

Reply to this Message

Rate this thread: