Email Mail Merge w/ Attachment Problems Melissa 10/8/2008 6:43:13 PM Hello, I am using the article submitted by Doug Robbins to send an email with an attachment; however, I am running into a problem. I know I must be doing something wrong but I can't figure out what it is. Can someone please help? Here are the steps I've completed. I am using Microsoft 2003 for Outlook and Word. 1. Selected Microsoft Outlook 11.0 Object Library under Tools-References. 2. Created a new Directory under Tools-Letters&Mailings-Mail Merge 3. Selected Directory as my Document Type 4. Added an Email and Attachment column from my data source (excel document) 5. Executed this to a new document 6. Saved and closed 7. Created a new Word document 8. Selected Letters under Document Type 9. Go to Complete the Merge (step 6) 10. Run the Macro 11. An open file window appears as if it wants me to select a file. I've tried cancelling it and I've tried selecting the attachment. 12. The Enter the Subject message comes up. I enter a subject. 13. The message "a program is trying to automatically...." appears and I select Yes. I only have this setup to send one email, however, every time I try this it trys to send multiple documents. It opens a new Word document than this message reappears from step 13. It keeps cycling between a new Word document (every time the word document number changes to the next number). I got to Document45 before ending the program via the task manager. Nothing appears in my sent items either. What am I doing wrong? -- Melissa

RE: Email Mail Merge w/ Attachment Problems Melissa 10/8/2008 7:05:01 PM I just figured it out... In case anyone else has the same problem.... When the open file window appears, select the directory file you created. -- Melissa "Melissa" wrote: [Quoted Text] > Hello, > > I am using the article submitted by Doug Robbins to send an email with an > attachment; however, I am running into a problem. I know I must be doing > something wrong but I can't figure out what it is. Can someone please help? > > Here are the steps I've completed. I am using Microsoft 2003 for Outlook and > Word. > > 1. Selected Microsoft Outlook 11.0 Object Library under Tools-References. > 2. Created a new Directory under Tools-Letters&Mailings-Mail Merge > 3. Selected Directory as my Document Type > 4. Added an Email and Attachment column from my data source (excel document) > 5. Executed this to a new document > 6. Saved and closed > 7. Created a new Word document > 8. Selected Letters under Document Type > 9. Go to Complete the Merge (step 6) > 10. Run the Macro > 11. An open file window appears as if it wants me to select a file. I've > tried cancelling it and I've tried selecting the attachment. > 12. The Enter the Subject message comes up. I enter a subject. > 13. The message "a program is trying to automatically...." appears and I > select Yes. I only have this setup to send one email, however, every time I > try this it trys to send multiple documents. > > It opens a new Word document than this message reappears from step 13. It > keeps cycling between a new Word document (every time the word document > number changes to the next number). I got to Document45 before ending the > program via the task manager. Nothing appears in my sent items either. > > What am I doing wrong? > > -- > Melissa

Re: Email Mail Merge w/ Attachment Problems "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/8/2008 7:49:17 PM I think that is what the instructions say to do. -- 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 "Melissa" <Melissa[ at ]discussions.microsoft.com> wrote in message news:FBE60996-7A60-485F-B74C-384507674638[ at ]microsoft.com... [Quoted Text] >I just figured it out... In case anyone else has the same problem.... > > When the open file window appears, select the directory file you created. > > > -- > Melissa > > > "Melissa" wrote: > >> Hello, >> >> I am using the article submitted by Doug Robbins to send an email with an >> attachment; however, I am running into a problem. I know I must be doing >> something wrong but I can't figure out what it is. Can someone please >> help? >> >> Here are the steps I've completed. I am using Microsoft 2003 for Outlook >> and >> Word. >> >> 1. Selected Microsoft Outlook 11.0 Object Library under Tools-References. >> 2. Created a new Directory under Tools-Letters&Mailings-Mail Merge >> 3. Selected Directory as my Document Type >> 4. Added an Email and Attachment column from my data source (excel >> document) >> 5. Executed this to a new document >> 6. Saved and closed >> 7. Created a new Word document >> 8. Selected Letters under Document Type >> 9. Go to Complete the Merge (step 6) >> 10. Run the Macro >> 11. An open file window appears as if it wants me to select a file. I've >> tried cancelling it and I've tried selecting the attachment. >> 12. The Enter the Subject message comes up. I enter a subject. >> 13. The message "a program is trying to automatically...." appears and I >> select Yes. I only have this setup to send one email, however, every time >> I >> try this it trys to send multiple documents. >> >> It opens a new Word document than this message reappears from step 13. It >> keeps cycling between a new Word document (every time the word document >> number changes to the next number). I got to Document45 before ending the >> program via the task manager. Nothing appears in my sent items either. >> >> What am I doing wrong? >> >> -- >> Melissa

Re: Email Mail Merge w/ Attachment Problems Melissa 10/8/2008 7:56:01 PM I am sure it does but I am VB illiterate so it didn't come right out for me. I sure do appreciate you putting this document together. This helps me tremendously!! -- Melissa "Doug Robbins - Word MVP" wrote: [Quoted Text] > I think that is what the instructions say to do. > > -- > 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 > > "Melissa" <Melissa[ at ]discussions.microsoft.com> wrote in message > news:FBE60996-7A60-485F-B74C-384507674638[ at ]microsoft.com... > >I just figured it out... In case anyone else has the same problem.... > > > > When the open file window appears, select the directory file you created. > > > > > > -- > > Melissa > > > > > > "Melissa" wrote: > > > >> Hello, > >> > >> I am using the article submitted by Doug Robbins to send an email with an > >> attachment; however, I am running into a problem. I know I must be doing > >> something wrong but I can't figure out what it is. Can someone please > >> help? > >> > >> Here are the steps I've completed. I am using Microsoft 2003 for Outlook > >> and > >> Word. > >> > >> 1. Selected Microsoft Outlook 11.0 Object Library under Tools-References. > >> 2. Created a new Directory under Tools-Letters&Mailings-Mail Merge > >> 3. Selected Directory as my Document Type > >> 4. Added an Email and Attachment column from my data source (excel > >> document) > >> 5. Executed this to a new document > >> 6. Saved and closed > >> 7. Created a new Word document > >> 8. Selected Letters under Document Type > >> 9. Go to Complete the Merge (step 6) > >> 10. Run the Macro > >> 11. An open file window appears as if it wants me to select a file. I've > >> tried cancelling it and I've tried selecting the attachment. > >> 12. The Enter the Subject message comes up. I enter a subject. > >> 13. The message "a program is trying to automatically...." appears and I > >> select Yes. I only have this setup to send one email, however, every time > >> I > >> try this it trys to send multiple documents. > >> > >> It opens a new Word document than this message reappears from step 13. It > >> keeps cycling between a new Word document (every time the word document > >> number changes to the next number). I got to Document45 before ending the > >> program via the task manager. Nothing appears in my sent items either. > >> > >> What am I doing wrong? > >> > >> -- > >> Melissa > > >

Re: Email Mail Merge w/ Attachment Problems jmac60 10/9/2008 7:48:06 PM Doug... Where can I find your article? this is really slick! I'd like to learn how to do this. Thanks John "Doug Robbins - Word MVP" wrote: [Quoted Text] > I think that is what the instructions say to do. > > -- > 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 > > "Melissa" <Melissa[ at ]discussions.microsoft.com> wrote in message > news:FBE60996-7A60-485F-B74C-384507674638[ at ]microsoft.com... > >I just figured it out... In case anyone else has the same problem.... > > > > When the open file window appears, select the directory file you created. > > > > > > -- > > Melissa > > > > > > "Melissa" wrote: > > > >> Hello, > >> > >> I am using the article submitted by Doug Robbins to send an email with an > >> attachment; however, I am running into a problem. I know I must be doing > >> something wrong but I can't figure out what it is. Can someone please > >> help? > >> > >> Here are the steps I've completed. I am using Microsoft 2003 for Outlook > >> and > >> Word. > >> > >> 1. Selected Microsoft Outlook 11.0 Object Library under Tools-References. > >> 2. Created a new Directory under Tools-Letters&Mailings-Mail Merge > >> 3. Selected Directory as my Document Type > >> 4. Added an Email and Attachment column from my data source (excel > >> document) > >> 5. Executed this to a new document > >> 6. Saved and closed > >> 7. Created a new Word document > >> 8. Selected Letters under Document Type > >> 9. Go to Complete the Merge (step 6) > >> 10. Run the Macro > >> 11. An open file window appears as if it wants me to select a file. I've > >> tried cancelling it and I've tried selecting the attachment. > >> 12. The Enter the Subject message comes up. I enter a subject. > >> 13. The message "a program is trying to automatically...." appears and I > >> select Yes. I only have this setup to send one email, however, every time > >> I > >> try this it trys to send multiple documents. > >> > >> It opens a new Word document than this message reappears from step 13. It > >> keeps cycling between a new Word document (every time the word document > >> number changes to the next number). I got to Document45 before ending the > >> program via the task manager. Nothing appears in my sent items either. > >> > >> What am I doing wrong? > >> > >> -- > >> Melissa > > >

Re: Email Mail Merge w/ Attachment Problems Melissa 10/9/2008 7:52:10 PM Here you go. http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm -- Melissa "jmac60" wrote: [Quoted Text] > Doug... > Where can I find your article? this is really slick! I'd like to learn how > to do this. > > Thanks > John > > "Doug Robbins - Word MVP" wrote: > > > I think that is what the instructions say to do. > > > > -- > > 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 > > > > "Melissa" <Melissa[ at ]discussions.microsoft.com> wrote in message > > news:FBE60996-7A60-485F-B74C-384507674638[ at ]microsoft.com... > > >I just figured it out... In case anyone else has the same problem.... > > > > > > When the open file window appears, select the directory file you created. > > > > > > > > > -- > > > Melissa > > > > > > > > > "Melissa" wrote: > > > > > >> Hello, > > >> > > >> I am using the article submitted by Doug Robbins to send an email with an > > >> attachment; however, I am running into a problem. I know I must be doing > > >> something wrong but I can't figure out what it is. Can someone please > > >> help? > > >> > > >> Here are the steps I've completed. I am using Microsoft 2003 for Outlook > > >> and > > >> Word. > > >> > > >> 1. Selected Microsoft Outlook 11.0 Object Library under Tools-References. > > >> 2. Created a new Directory under Tools-Letters&Mailings-Mail Merge > > >> 3. Selected Directory as my Document Type > > >> 4. Added an Email and Attachment column from my data source (excel > > >> document) > > >> 5. Executed this to a new document > > >> 6. Saved and closed > > >> 7. Created a new Word document > > >> 8. Selected Letters under Document Type > > >> 9. Go to Complete the Merge (step 6) > > >> 10. Run the Macro > > >> 11. An open file window appears as if it wants me to select a file. I've > > >> tried cancelling it and I've tried selecting the attachment. > > >> 12. The Enter the Subject message comes up. I enter a subject. > > >> 13. The message "a program is trying to automatically...." appears and I > > >> select Yes. I only have this setup to send one email, however, every time > > >> I > > >> try this it trys to send multiple documents. > > >> > > >> It opens a new Word document than this message reappears from step 13. It > > >> keeps cycling between a new Word document (every time the word document > > >> number changes to the next number). I got to Document45 before ending the > > >> program via the task manager. Nothing appears in my sent items either. > > >> > > >> What am I doing wrong? > > >> > > >> -- > > >> Melissa > > > > > >

Re: Email Mail Merge w/ Attachment Problems jmac60 10/9/2008 8:01:01 PM Thanks for the quick response! "Melissa" wrote: [Quoted Text] > Here you go. > > http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm > > > > -- > Melissa > > > "jmac60" wrote: > > > Doug... > > Where can I find your article? this is really slick! I'd like to learn how > > to do this. > > > > Thanks > > John > > > > "Doug Robbins - Word MVP" wrote: > > > > > I think that is what the instructions say to do. > > > > > > -- > > > 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 > > > > > > "Melissa" <Melissa[ at ]discussions.microsoft.com> wrote in message > > > news:FBE60996-7A60-485F-B74C-384507674638[ at ]microsoft.com... > > > >I just figured it out... In case anyone else has the same problem.... > > > > > > > > When the open file window appears, select the directory file you created. > > > > > > > > > > > > -- > > > > Melissa > > > > > > > > > > > > "Melissa" wrote: > > > > > > > >> Hello, > > > >> > > > >> I am using the article submitted by Doug Robbins to send an email with an > > > >> attachment; however, I am running into a problem. I know I must be doing > > > >> something wrong but I can't figure out what it is. Can someone please > > > >> help? > > > >> > > > >> Here are the steps I've completed. I am using Microsoft 2003 for Outlook > > > >> and > > > >> Word. > > > >> > > > >> 1. Selected Microsoft Outlook 11.0 Object Library under Tools-References. > > > >> 2. Created a new Directory under Tools-Letters&Mailings-Mail Merge > > > >> 3. Selected Directory as my Document Type > > > >> 4. Added an Email and Attachment column from my data source (excel > > > >> document) > > > >> 5. Executed this to a new document > > > >> 6. Saved and closed > > > >> 7. Created a new Word document > > > >> 8. Selected Letters under Document Type > > > >> 9. Go to Complete the Merge (step 6) > > > >> 10. Run the Macro > > > >> 11. An open file window appears as if it wants me to select a file. I've > > > >> tried cancelling it and I've tried selecting the attachment. > > > >> 12. The Enter the Subject message comes up. I enter a subject. > > > >> 13. The message "a program is trying to automatically...." appears and I > > > >> select Yes. I only have this setup to send one email, however, every time > > > >> I > > > >> try this it trys to send multiple documents. > > > >> > > > >> It opens a new Word document than this message reappears from step 13. It > > > >> keeps cycling between a new Word document (every time the word document > > > >> number changes to the next number). I got to Document45 before ending the > > > >> program via the task manager. Nothing appears in my sent items either. > > > >> > > > >> What am I doing wrong? > > > >> > > > >> -- > > > >> Melissa > > > > > > > > >

Re: Email Mail Merge w/ Attachment Problems Sarah 10/31/2008 8:21:01 PM Hi, I'm apparently missing something very simple, but I can't seem to get anything to attach to the emails. The macro sends the emails correctly, except with no attachments. Any suggestions? Thanks, Sarah "jmac60" wrote: [Quoted Text] > Thanks for the quick response! > > "Melissa" wrote: > > > Here you go. > > > > http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm > > > > > > > > -- > > Melissa > > > > > > "jmac60" wrote: > > > > > Doug... > > > Where can I find your article? this is really slick! I'd like to learn how > > > to do this. > > > > > > Thanks > > > John > > > > > > "Doug Robbins - Word MVP" wrote: > > > > > > > I think that is what the instructions say to do. > > > > > > > > -- > > > > 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 > > > > > > > > "Melissa" <Melissa[ at ]discussions.microsoft.com> wrote in message > > > > news:FBE60996-7A60-485F-B74C-384507674638[ at ]microsoft.com... > > > > >I just figured it out... In case anyone else has the same problem.... > > > > > > > > > > When the open file window appears, select the directory file you created. > > > > > > > > > > > > > > > -- > > > > > Melissa > > > > > > > > > > > > > > > "Melissa" wrote: > > > > > > > > > >> Hello, > > > > >> > > > > >> I am using the article submitted by Doug Robbins to send an email with an > > > > >> attachment; however, I am running into a problem. I know I must be doing > > > > >> something wrong but I can't figure out what it is. Can someone please > > > > >> help? > > > > >> > > > > >> Here are the steps I've completed. I am using Microsoft 2003 for Outlook > > > > >> and > > > > >> Word. > > > > >> > > > > >> 1. Selected Microsoft Outlook 11.0 Object Library under Tools-References. > > > > >> 2. Created a new Directory under Tools-Letters&Mailings-Mail Merge > > > > >> 3. Selected Directory as my Document Type > > > > >> 4. Added an Email and Attachment column from my data source (excel > > > > >> document) > > > > >> 5. Executed this to a new document > > > > >> 6. Saved and closed > > > > >> 7. Created a new Word document > > > > >> 8. Selected Letters under Document Type > > > > >> 9. Go to Complete the Merge (step 6) > > > > >> 10. Run the Macro > > > > >> 11. An open file window appears as if it wants me to select a file. I've > > > > >> tried cancelling it and I've tried selecting the attachment. > > > > >> 12. The Enter the Subject message comes up. I enter a subject. > > > > >> 13. The message "a program is trying to automatically...." appears and I > > > > >> select Yes. I only have this setup to send one email, however, every time > > > > >> I > > > > >> try this it trys to send multiple documents. > > > > >> > > > > >> It opens a new Word document than this message reappears from step 13. It > > > > >> keeps cycling between a new Word document (every time the word document > > > > >> number changes to the next number). I got to Document45 before ending the > > > > >> program via the task manager. Nothing appears in my sent items either. > > > > >> > > > > >> What am I doing wrong? > > > > >> > > > > >> -- > > > > >> Melissa > > > > > > > > > > > >

Re: Email Mail Merge w/ Attachment Problems "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/2/2008 6:07:19 AM The filepath and name of the attachments in the directory document that you create probably does not match the actual filepath and name of the files that you want to send. It must be exactly the same. One space in the wrong place will prevent the file from being attached. -- 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 "Sarah" <Sarah[ at ]discussions.microsoft.com> wrote in message news:1C235866-BE4A-403D-8DCF-654EADC4B56B[ at ]microsoft.com... [Quoted Text] > Hi, > > I'm apparently missing something very simple, but I can't seem to get > anything to attach to the emails. The macro sends the emails correctly, > except with no attachments. Any suggestions? > > Thanks, > Sarah > > "jmac60" wrote: > >> Thanks for the quick response! >> >> "Melissa" wrote: >> >> > Here you go. >> > >> > http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm >> > >> > >> > >> > -- >> > Melissa >> > >> > >> > "jmac60" wrote: >> > >> > > Doug... >> > > Where can I find your article? this is really slick! I'd like to >> > > learn how >> > > to do this. >> > > >> > > Thanks >> > > John >> > > >> > > "Doug Robbins - Word MVP" wrote: >> > > >> > > > I think that is what the instructions say to do. >> > > > >> > > > -- >> > > > 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 >> > > > >> > > > "Melissa" <Melissa[ at ]discussions.microsoft.com> wrote in message >> > > > news:FBE60996-7A60-485F-B74C-384507674638[ at ]microsoft.com... >> > > > >I just figured it out... In case anyone else has the same >> > > > >problem.... >> > > > > >> > > > > When the open file window appears, select the directory file you >> > > > > created. >> > > > > >> > > > > >> > > > > -- >> > > > > Melissa >> > > > > >> > > > > >> > > > > "Melissa" wrote: >> > > > > >> > > > >> Hello, >> > > > >> >> > > > >> I am using the article submitted by Doug Robbins to send an >> > > > >> email with an >> > > > >> attachment; however, I am running into a problem. I know I must >> > > > >> be doing >> > > > >> something wrong but I can't figure out what it is. Can someone >> > > > >> please >> > > > >> help? >> > > > >> >> > > > >> Here are the steps I've completed. I am using Microsoft 2003 for >> > > > >> Outlook >> > > > >> and >> > > > >> Word. >> > > > >> >> > > > >> 1. Selected Microsoft Outlook 11.0 Object Library under >> > > > >> Tools-References. >> > > > >> 2. Created a new Directory under Tools-Letters&Mailings-Mail >> > > > >> Merge >> > > > >> 3. Selected Directory as my Document Type >> > > > >> 4. Added an Email and Attachment column from my data source >> > > > >> (excel >> > > > >> document) >> > > > >> 5. Executed this to a new document >> > > > >> 6. Saved and closed >> > > > >> 7. Created a new Word document >> > > > >> 8. Selected Letters under Document Type >> > > > >> 9. Go to Complete the Merge (step 6) >> > > > >> 10. Run the Macro >> > > > >> 11. An open file window appears as if it wants me to select a >> > > > >> file. I've >> > > > >> tried cancelling it and I've tried selecting the attachment. >> > > > >> 12. The Enter the Subject message comes up. I enter a subject. >> > > > >> 13. The message "a program is trying to automatically...." >> > > > >> appears and I >> > > > >> select Yes. I only have this setup to send one email, however, >> > > > >> every time >> > > > >> I >> > > > >> try this it trys to send multiple documents. >> > > > >> >> > > > >> It opens a new Word document than this message reappears from >> > > > >> step 13. It >> > > > >> keeps cycling between a new Word document (every time the word >> > > > >> document >> > > > >> number changes to the next number). I got to Document45 before >> > > > >> ending the >> > > > >> program via the task manager. Nothing appears in my sent items >> > > > >> either. >> > > > >> >> > > > >> What am I doing wrong? >> > > > >> >> > > > >> -- >> > > > >> Melissa >> > > > >> > > > >> > > >