Re: How do I attach documents to mail merge emails?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <abbg@xxxxxxxxxxxxxxx> wrote in message
news:71BA0235-9460-4884-98FF-77BCAFA973A2@xxxxxxxxxxxxxxxx
Hi Doug

Sorry to once again barge in, but I do not seem to be able to start a new
thread. I am still having problems with mail merge to e-mail with
attachments. This is what I'm doing ... perhaps you can let me know where
I'm
going wrong:


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

In Word I have 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 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 had
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.

Please help.

--
GVP


"Doug Robbins - Word MVP" wrote:

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

"Rod" <Rod@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E0E09FFB-43B0-4ED4-AD38-C1873506DC40@xxxxxxxxxxxxxxxx
I want to mail a document to several different people using mail merge
and
I
need to add attachments before the mail merge process sends the email.
How
do I do this.





.

Relevant Pages

  • Re: Saving mail merged letter seperately then emailing
    ... I have sent 4 new messages to you, one with the attachments in original ... Doug Robbins - Word MVP ... While Counter < Letters ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Certain properties of a Document that I cant find.
    ... Doug Robbins - Word MVP, ... allows you to put in the To; Cc;Bcc; Subject and also to Add Attachments. ... And then based on the format what property will give me the ...
    (microsoft.public.word.vba.general)
  • Re: Mail merge with excel attachment
    ... services on a paid consulting basis. ... Doug Robbins - Word MVP ... attachments, mailmerge - email message - current doc - selected my ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail merge with excel attachment
    ... Doug Robbins - Word MVP ... the current doc - selected recipients - included attachments - executed ... way, and execute the mail merge, however it does not send the ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 07 Crashes
    ... reference page just how to delete the Key. ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.docmanagement)