 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2006Attach document to the e-mail
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 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 <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi: > [quoted text clipped - 5 lines] > > Dan Thanks Graham! Outlook is checked but I get 'User defined type not defined' on:Dim oOutlookApp As Outlook.Application Thanks, Dan > See the article prepared by fellow MVP Doug Robbins at > http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm [quoted text clipped - 8 lines] > > > > Dan Check again and make sure that it is checked. SignatureHope 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 Graham! > [quoted text clipped - 17 lines] >> > >> > Dan It is checked Doug! But it does not do anything... Thanks, Dan > Check again and make sure that it is checked. > [quoted text clipped - 19 lines] > >> > > >> > Dan Doug it running for ever! what I am missing? Thanks, Dan > Check again and make sure that it is checked. > [quoted text clipped - 19 lines] > >> > > >> > Dan 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. SignatureHope 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 > Doug it running for ever! what I am missing? > [quoted text clipped - 25 lines] >> >> > >> >> > Dan 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 > So you have got past the compile error "User type not defined"? > [quoted text clipped - 30 lines] > >> >> > > >> >> > Dan 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. SignatureHope 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 - 46 lines] >> >> >> > >> >> >> > Dan 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 > You have misread the instructions. It is the document created by executing > the catalog or directory type mailmerge main document that you need to [quoted text clipped - 51 lines] > >> >> >> > > >> >> >> > Dan Oops! too excited Doug! I did not get the e-mail body; just the attachment! > Sorry Doug! still, now is running, it stopped but does not send the email... > [quoted text clipped - 67 lines] > > >> >> >> > > > >> >> >> > Dan 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 > Sorry Doug! still, now is running, it stopped but does not send the email... > [quoted text clipped - 67 lines] > > >> >> >> > > > >> >> >> > Dan |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.