Attachment difficulties!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hunza321 - 21 May 2005 14:08 GMT

I am following the instructions from
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
I am using Windows 98 and Word 2000.
I have Outlook installed but use Outlook Express for email.
I check the item Microsoft Outlook 9.0 Object Library under Word
Tools|Macro|VB Editor|Tools|References.
I can create a separate Catalogue identifying the required attachment (a PDF).
I can execute the mail merge, to a new document.
With the new document open I can run the macro as instructed, but experience
the following:
1) The correct number of personalised emails is created but none have an
attachment.
2) At some point during my experiments the personalised emails stopped being
created in Outlook Express and are now created in Outlook.
3) The macro appears not to be saved and has to be re-created for each mail
merge.
4) The Microsoft Outlook 9.0 Object Library un-checks itself after each mail
merge.

Please help me to solve these problems?

Reply to this Message

Doug Robbins - 21 May 2005 17:29 GMT

The fact that the files were not attached points to there being a difference
between the actual path\filename and the path\filename that appears in the
catalog mailmerge document. Just one extra space will cause it not to work.

The macro should be created in either the normal.dot template (not
necessarily recommended), or in another template that you place in the Word
startup folder. Any template in that location becomes an Add-in to Word and
the code in it can be used in all documents.

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 am following the instructions from
> http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
[quoted text clipped - 21 lines]
>
> Please help me to solve these problems?

Reply to this Message

Hunza321 - 21 May 2005 21:40 GMT

Thanks for your guidance Doug.

I did type an incorrect path\filename and placing the macro as .DOT in the
WORD\startup file makes it always available through Word|Tools|Macro|Macros.

However, the Microsoft Outlook 9.0 Object Library still un-checks itself
after each mail merge and the personalised emails are created in Outlook,
whereas I want them created in Outlook Express.

The un-checking is a nuisance but if I can’t create these emails in Outlook
Express, then all this learning will be of no value.

Any solutions please?

> The fact that the files were not attached points to there being a difference
> between the actual path\filename and the path\filename that appears in the
[quoted text clipped - 30 lines]
> >
> > Please help me to solve these problems?

Reply to this Message

Doug Robbins - 22 May 2005 07:20 GMT

It is the Microsoft Outlook Object Library that is being used, therefore it
is Outlook, not Outlook Express that will send the emails. There is no
Outlook Express Object Library that can be used.

I have the macro as an add-in and the Outlook Object Library remains checked
at all times.

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

> Thanks for your guidance Doug.
>
[quoted text clipped - 53 lines]
>> >
>> > Please help me to solve these problems?

Reply to this Message