 |
 | 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 / July 2006Merged Attachment, Missing Message
The magic is almost working for me. I have read multiple posts, finally muddled through creating a macro and I can send to my list from Outlook, it looks like a one-to-one email, and there is a PDF attachment. Except, somewhere I've missed how to make my message show up. I have created a new Word doc, merged it, and then executed the macro - but I still get an empty message with the attachment. What am I doing wrong?? Are you referring to article "Mail Merge to E-mail with Attachments" at: http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm Have you actually executed the merge to a new document before running the macro.  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 > The magic is almost working for me. I have read multiple posts, finally > muddled through creating a macro and I can send to my list from Outlook, [quoted text clipped - 5 lines] > empty > message with the attachment. What am I doing wrong?? Doug, Sorry for my lack of etiquette; I'm a novice and didn't realize my mesg would post on the other guy's. Yes, I am referring to that article and yes, I actually executed a merge on a new document (call it A) resulting in a "letter" to each recipient on the list (NOT the directory doc, mind you). Then, I executed the macro from the merged doc A. The email went out with the attachment beautifully - except without doc A text. Any ideas? > Are you referring to article "Mail Merge to E-mail with Attachments" at: > [quoted text clipped - 11 lines] > > empty > > message with the attachment. What am I doing wrong?? Send me doc A so that I can take a look at it and see if there is any reason that it would not work. 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, > Sorry for my lack of etiquette; I'm a novice and didn't realize my mesg [quoted text clipped - 28 lines] >> > empty >> > message with the attachment. What am I doing wrong?? Forgive me if I have overstepped but I sent doc A to your email address yesterday p.m. I f I should have responded differently, please instruct. Otherwise - were you able to pin down my error(s)? Thanks again! > Send me doc A so that I can take a look at it and see if there is any reason > that it would not work. [quoted text clipped - 31 lines] > >> > empty > >> > message with the attachment. What am I doing wrong?? When I try to follow the instructions for enabling email merging with an attachment, I get "Compile Error: User-defined type not defined" after trying to run the macro. Can anyone help? I am using Outlook 2003, Word 2003 (Office 2003) on a WinXP machine. Here's what I did, per the instructions at http://word.mvps.org/FAQs/MailMerge/MertWithAttachmentsContent.htm - I downloaded and executed the Express ClickYes utility for Outlook. - I open both Outlook and Word 2003 - In Word, I created a Directory file per the instructions, saved and closed it. - In Word, I created and saved the macro from the above website and called it "Mail_Merge_With_Attachment". I saved and closed out of Visual Basic (or whatever window the Create Macro feature in Word opens. - I then created a mail merge document, selected the data to merge (an Excel file with company names, first names, etc). - I completed the merge, going through the last step and actually merging (that is, I select the "Merge - Electronic Mail" option. - I try to run the macro while in Word and get the Compile error noted above. Any help is appreciated! - Paul M. > The magic is almost working for me. I have read multiple posts, finally > muddled through creating a macro and I can send to my list from Outlook, it > looks like a one-to-one email, and there is a PDF attachment. Except, > somewhere I've missed how to make my message show up. I have created a new > Word doc, merged it, and then executed the macro - but I still get an empty > message with the attachment. What am I doing wrong?? When you have the Visual Basic editor open, click Tools|References, locate Microsoft Outlook nn.0 Object Library (e.g. Microsoft Outlook 11.0 Object Library) and check it. Then save everything and try again. Peter Jamieson > When I try to follow the instructions for enabling email merging with an > attachment, I get "Compile Error: User-defined type not defined" after [quoted text clipped - 34 lines] >> empty >> message with the attachment. What am I doing wrong?? Hi Apologies for barging in. I have the same problem and have followed your advice, but still get the same error message. Can anyone help? SignatureGVP > When you have the Visual Basic editor open, click Tools|References, locate > Microsoft Outlook nn.0 Object Library (e.g. Microsoft Outlook 11.0 Object [quoted text clipped - 40 lines] > >> empty > >> message with the attachment. What am I doing wrong?? If it is the "Compile Error: User-defined type not defined" error message that you are getting, all that I can suggest is that you go back and make sure that the necessary reference to the Microsoft Outlook nn.0 Object Library had been made. 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 > Apologies for barging in. I have the same problem and have followed your [quoted text clipped - 51 lines] >> >> empty >> >> message with the attachment. What am I doing wrong?? Make sure that you are making the reference within the correct Word project - e.g. make sure the macro is open and you have clicked somewhere in its text before making the reference. (There might be more to it than that, but that's where I would start). Peter Jamieson > Hi > Apologies for barging in. I have the same problem and have followed your [quoted text clipped - 51 lines] >> >> empty >> >> message with the attachment. What am I doing wrong??
|
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.