Attach document to the e-mail

D

D

Hi:

Is there any way that I can attach a document to the e-mail merge?

So, I have the body, but before sending I want to attach?!

Thanks,

Dan
 
D

D

Thanks Graham!

Outlook is checked but I get 'User defined type not defined' on:Dim
oOutlookApp As Outlook.Application

Thanks,

Dan
 
D

Doug Robbins - Word MVP

Check again and make sure that it is checked.

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

Doug Robbins - Word MVP

So you have got past the compile error "User type not defined"?

To give you any help, you will need to explain in more detail what you have
done.

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

D

Hi Doug:

Yes, the compile error is passed; With the main document open, that will be
in the e-mail body, I am clicking in the run macro - your code - it brings me
to the open/ look in, dialog box, I click the name of the file that I want to
attach and then is running/looping? for ever.

Thanks again for the help!

Dan
 
D

Doug Robbins - Word MVP

You have misread the instructions. It is the document created by executing
the catalog or directory type mailmerge main document that you need to
select when the File Open dialog appears. Please read the instructions
again very carefully and follow them exactly.

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

D

Sorry Doug! still, now is running, it stopped but does not send the email...

I do not know what is the "document created by executing the catalog"

I have 3 docs:

Th e-mail body
The Directory
The attachment.

I am missing the order of execution?

Thanks,

Dan
 
D

D

THANK YOU DOUG!; I GOT IT NOW!!

Thanks,

Dan

Order:

With the Directory opened, run macro, click the doc. email body when the
open box appears.

Thanks,

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top