Attaching a document with the merge to email feature.

[Joebuu]

I am trying to use the merge to email feature and I was
wondering if I can do this task with it. I have it all
setup data sources, main document, and it works fine but
I need to send another attachment with the merged
document. So I want it to send the merged document as
normal, but I also want it to attach a different document
to the email and send it out. Is there a way to do that?

Thanks,
Joe

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Joe

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

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


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Ted Horsch]

Hi Doug,

I've tried your solution and I can't get it to work. I
get as far as running the macro and it crashes on a
compile error on the statement

Dim oOutlookApp As Outlook.Application

I'm not a VB programmer; I just copied your macro into
word and ran it, without really understanding what it's
doing. I did not get a file open dialog, just the error
msg.

Office XP W2Kpro. I'm trying to attach the same document
to all recipients.

Any suggestions?

Thanks,

Ted

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

That would be because you have not set a reference to the Outlook Object
Library as discussed in the article.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP