Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
I'm using the directions from Doug Robbins "Mail Merge to E-mail with
Attachments" article. I've done the prep, created the directory merge with email addresses and document names. I've created the letter merge to a new document and run the macro. Every thing seems to work correctly at the start--I get the "Enter the subject..." and the rest of the preliminary stuff. Then it starts to do it's work and I answer Yes to "A program is trying to automatically send e-mail..." for the 3 addresses in my sample list. But at this point it seems to hang and I continue getting this Information box for Document 4, Document 5, Document 6, etc. until I Ctrl-Break to stop the process. When I look at the macro contents it points to this section: End With Set oItem = Nothing ActiveDocument.Close wdDoNotSaveChanges Counter = Counter + 1 Wend Any ideas about what my problem is and how I can correct it? I'm so close and yet so far away. Thanks, Lyndie |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
Have you activated the Express Click Yes utility?
What you see in the Visual Basic Editor after pressing Ctrl-Break, doesn't really mean anything is wrong with that section of the code. In the letter that you are trying to email with the attachments, how many Sections are there? -- 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 "LyndieBee" wrote in message ... I'm using the directions from Doug Robbins "Mail Merge to E-mail with Attachments" article. I've done the prep, created the directory merge with email addresses and document names. I've created the letter merge to a new document and run the macro. Every thing seems to work correctly at the start--I get the "Enter the subject..." and the rest of the preliminary stuff. Then it starts to do it's work and I answer Yes to "A program is trying to automatically send e-mail..." for the 3 addresses in my sample list. But at this point it seems to hang and I continue getting this Information box for Document 4, Document 5, Document 6, etc. until I Ctrl-Break to stop the process. When I look at the macro contents it points to this section: End With Set oItem = Nothing ActiveDocument.Close wdDoNotSaveChanges Counter = Counter + 1 Wend Any ideas about what my problem is and how I can correct it? I'm so close and yet so far away. Thanks, Lyndie |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
For my test file, it is a one-liner attachment with only one section. Do I
need section break at the end of the text? "Doug Robbins - Word MVP" wrote: Have you activated the Express Click Yes utility? What you see in the Visual Basic Editor after pressing Ctrl-Break, doesn't really mean anything is wrong with that section of the code. In the letter that you are trying to email with the attachments, how many Sections are there? -- 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 "LyndieBee" wrote in message ... I'm using the directions from Doug Robbins "Mail Merge to E-mail with Attachments" article. I've done the prep, created the directory merge with email addresses and document names. I've created the letter merge to a new document and run the macro. Every thing seems to work correctly at the start--I get the "Enter the subject..." and the rest of the preliminary stuff. Then it starts to do it's work and I answer Yes to "A program is trying to automatically send e-mail..." for the 3 addresses in my sample list. But at this point it seems to hang and I continue getting this Information box for Document 4, Document 5, Document 6, etc. until I Ctrl-Break to stop the process. When I look at the macro contents it points to this section: End With Set oItem = Nothing ActiveDocument.Close wdDoNotSaveChanges Counter = Counter + 1 Wend Any ideas about what my problem is and how I can correct it? I'm so close and yet so far away. Thanks, Lyndie |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
In answer to your Express ClickYess utility, yes I have downloaded it and it
works fine. Thanks! "LyndieBee" wrote: For my test file, it is a one-liner attachment with only one section. Do I need section break at the end of the text? "Doug Robbins - Word MVP" wrote: Have you activated the Express Click Yes utility? What you see in the Visual Basic Editor after pressing Ctrl-Break, doesn't really mean anything is wrong with that section of the code. In the letter that you are trying to email with the attachments, how many Sections are there? -- 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 "LyndieBee" wrote in message ... I'm using the directions from Doug Robbins "Mail Merge to E-mail with Attachments" article. I've done the prep, created the directory merge with email addresses and document names. I've created the letter merge to a new document and run the macro. Every thing seems to work correctly at the start--I get the "Enter the subject..." and the rest of the preliminary stuff. Then it starts to do it's work and I answer Yes to "A program is trying to automatically send e-mail..." for the 3 addresses in my sample list. But at this point it seems to hang and I continue getting this Information box for Document 4, Document 5, Document 6, etc. until I Ctrl-Break to stop the process. When I look at the macro contents it points to this section: End With Set oItem = Nothing ActiveDocument.Close wdDoNotSaveChanges Counter = Counter + 1 Wend Any ideas about what my problem is and how I can correct it? I'm so close and yet so far away. Thanks, Lyndie |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
I believe I misunderstood your question. There are 5 section. A Next Page
Section Break after each of the letters, and a Continuous Section Break at the end of the document. "Doug Robbins - Word MVP" wrote: Have you activated the Express Click Yes utility? What you see in the Visual Basic Editor after pressing Ctrl-Break, doesn't really mean anything is wrong with that section of the code. In the letter that you are trying to email with the attachments, how many Sections are there? -- 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 "LyndieBee" wrote in message ... I'm using the directions from Doug Robbins "Mail Merge to E-mail with Attachments" article. I've done the prep, created the directory merge with email addresses and document names. I've created the letter merge to a new document and run the macro. Every thing seems to work correctly at the start--I get the "Enter the subject..." and the rest of the preliminary stuff. Then it starts to do it's work and I answer Yes to "A program is trying to automatically send e-mail..." for the 3 addresses in my sample list. But at this point it seems to hang and I continue getting this Information box for Document 4, Document 5, Document 6, etc. until I Ctrl-Break to stop the process. When I look at the macro contents it points to this section: End With Set oItem = Nothing ActiveDocument.Close wdDoNotSaveChanges Counter = Counter + 1 Wend Any ideas about what my problem is and how I can correct it? I'm so close and yet so far away. Thanks, Lyndie |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
It was not the attachment about which I was asking the number of Sections.
It was the mail merge document that is going to be emailed and to which the other document/file is going to be attached. That is the document that is created by executing the merge to a new document and which is to be the Active Document when the macro is run. -- 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 "LyndieBee" wrote in message ... For my test file, it is a one-liner attachment with only one section. Do I need section break at the end of the text? "Doug Robbins - Word MVP" wrote: Have you activated the Express Click Yes utility? What you see in the Visual Basic Editor after pressing Ctrl-Break, doesn't really mean anything is wrong with that section of the code. In the letter that you are trying to email with the attachments, how many Sections are there? -- 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 "LyndieBee" wrote in message ... I'm using the directions from Doug Robbins "Mail Merge to E-mail with Attachments" article. I've done the prep, created the directory merge with email addresses and document names. I've created the letter merge to a new document and run the macro. Every thing seems to work correctly at the start--I get the "Enter the subject..." and the rest of the preliminary stuff. Then it starts to do it's work and I answer Yes to "A program is trying to automatically send e-mail..." for the 3 addresses in my sample list. But at this point it seems to hang and I continue getting this Information box for Document 4, Document 5, Document 6, etc. until I Ctrl-Break to stop the process. When I look at the macro contents it points to this section: End With Set oItem = Nothing ActiveDocument.Close wdDoNotSaveChanges Counter = Counter + 1 Wend Any ideas about what my problem is and how I can correct it? I'm so close and yet so far away. Thanks, Lyndie |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
It sounds like you did not use the same datasource to create that document
as you used to create the directory document in which then filenames of the attachments appear, or at least did not merge the same number of records each time. -- 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 "LyndieBee" wrote in message ... I believe I misunderstood your question. There are 5 section. A Next Page Section Break after each of the letters, and a Continuous Section Break at the end of the document. "Doug Robbins - Word MVP" wrote: Have you activated the Express Click Yes utility? What you see in the Visual Basic Editor after pressing Ctrl-Break, doesn't really mean anything is wrong with that section of the code. In the letter that you are trying to email with the attachments, how many Sections are there? -- 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 "LyndieBee" wrote in message ... I'm using the directions from Doug Robbins "Mail Merge to E-mail with Attachments" article. I've done the prep, created the directory merge with email addresses and document names. I've created the letter merge to a new document and run the macro. Every thing seems to work correctly at the start--I get the "Enter the subject..." and the rest of the preliminary stuff. Then it starts to do it's work and I answer Yes to "A program is trying to automatically send e-mail..." for the 3 addresses in my sample list. But at this point it seems to hang and I continue getting this Information box for Document 4, Document 5, Document 6, etc. until I Ctrl-Break to stop the process. When I look at the macro contents it points to this section: End With Set oItem = Nothing ActiveDocument.Close wdDoNotSaveChanges Counter = Counter + 1 Wend Any ideas about what my problem is and how I can correct it? I'm so close and yet so far away. Thanks, Lyndie |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
Hi,
I tried to do the same (using the emailmergewithattachments macro) and didn't get really far. Visual basic points to the 'Dim oOutlookApp As Outlook.Application' line. I merged a word table with an excel db. That word table contains in the first column the emails, in the second the attachment name and location. I tried with the first row as the headings or not. I then merged my excel db with a word template letter. ANd upon running the macro, it doesn't work, opening visual basic as previously said. Any help much appreciated. Thanks "LyndieBee" wrote: I'm using the directions from Doug Robbins "Mail Merge to E-mail with Attachments" article. I've done the prep, created the directory merge with email addresses and document names. I've created the letter merge to a new document and run the macro. Every thing seems to work correctly at the start--I get the "Enter the subject..." and the rest of the preliminary stuff. Then it starts to do it's work and I answer Yes to "A program is trying to automatically send e-mail..." for the 3 addresses in my sample list. But at this point it seems to hang and I continue getting this Information box for Document 4, Document 5, Document 6, etc. until I Ctrl-Break to stop the process. When I look at the macro contents it points to this section: End With Set oItem = Nothing ActiveDocument.Close wdDoNotSaveChanges Counter = Counter + 1 Wend Any ideas about what my problem is and how I can correct it? I'm so close and yet so far away. Thanks, Lyndie |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
Joris wrote:
Hi, I tried to do the same (using the emailmergewithattachments macro) and didn't get really far. Visual basic points to the 'Dim oOutlookApp As Outlook.Application' line. From the vba editor Tools References - check the Microsoft Outlook option. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
I'm also having trouble with the same variable declaration. I do have the
Outlook Reference checked, but it still fails to recognize the type. Outlook 2003, Word 2003, Windows XP. -- Allan S. Warrior Microsoft Office Specialist Master Instructor "Graham Mayor" wrote: Joris wrote: Hi, I tried to do the same (using the emailmergewithattachments macro) and didn't get really far. Visual basic points to the 'Dim oOutlookApp As Outlook.Application' line. From the vba editor Tools References - check the Microsoft Outlook option. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#11
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
The reference is to the "Microsoft Outlook 11.0 Object Library"?
Are you able to use Outlook to send a document by selecting Send from the File menu in Word? -- 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 "Allan S. Warrior" warriora at yahoodotcom wrote in message ... I'm also having trouble with the same variable declaration. I do have the Outlook Reference checked, but it still fails to recognize the type. Outlook 2003, Word 2003, Windows XP. -- Allan S. Warrior Microsoft Office Specialist Master Instructor "Graham Mayor" wrote: Joris wrote: Hi, I tried to do the same (using the emailmergewithattachments macro) and didn't get really far. Visual basic points to the 'Dim oOutlookApp As Outlook.Application' line. From the vba editor Tools References - check the Microsoft Outlook option. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#12
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Email Merge with Attachment
Sorry, I was being an idiot. Or at least demonstrating very poor attention to
detail. I clicked the reference, but missed the checkbox. When I went back in to check once again, I discovered my error. Once corrected it worked great. I blame Friday-mind. -- Allan S. Warrior Microsoft Office Specialist Master Instructor "Doug Robbins - Word MVP" wrote: The reference is to the "Microsoft Outlook 11.0 Object Library"? Are you able to use Outlook to send a document by selecting Send from the File menu in Word? -- 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 "Allan S. Warrior" warriora at yahoodotcom wrote in message ... I'm also having trouble with the same variable declaration. I do have the Outlook Reference checked, but it still fails to recognize the type. Outlook 2003, Word 2003, Windows XP. -- Allan S. Warrior Microsoft Office Specialist Master Instructor "Graham Mayor" wrote: Joris wrote: Hi, I tried to do the same (using the emailmergewithattachments macro) and didn't get really far. Visual basic points to the 'Dim oOutlookApp As Outlook.Application' line. From the vba editor Tools References - check the Microsoft Outlook option. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you add an attachment to a mail merge email? | Mailmerge | |||
mail merge to email with attachment | Mailmerge | |||
How do I add an attachment to an email merge? | Mailmerge | |||
how can you send a email merge to over 200 with an attachment | Mailmerge | |||
how to add an attachment to an email merge | Mailmerge |