If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Can you send a mail merge to a large group WITH an attachment?
J Wilkie -
I was in the exact same spot you are in, and I understand how frustrating it can be to get so close only to have that “0 Messages Sent” box laughing at you. It turns out that my problem was that I was not merging the document that I wanted to email out into a new document before running the macro. From the final letter you wish to merge, go to “Finish and Merge” under the “Mailings” tab and select “Edit Individual Documents…” your mail merge document will be exported to a new document that will have all the letters with the correct information listed one right after the other (see Doug Robbin’s last post on 1/5/2007 or steps 7 and 8 of alexandros.papadopoulos’s outline). Then from THAT screen, run the macro and everything should work out for you. Good Luck "J Wilkie" wrote: I have followed all the instructions, have a directory file called Directory Source.xls and Directory.doc and have started a new Word document with the VBA (MS 2007) developer area open. I have got to the stage of having a Word file open with my mail merged letters and on MS 2007 toolbar have created a macro , copying the code given Doug Robbin's file. When I run the macro I get the window, in which I link in Directory.doc and I get a pop up window asking me for subject of emails - almost there - then I get a pop up window saying 0 emails sent. Where am I going wrong? as I seem to be right at the very end? I have checked email addresses (actually I managed to send emails with no attachments yesterday - but today no emails at all. ) Any help appreciated. "Doug Robbins - Word MVP" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm That method works in Word 2007 -- 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 "Wendy" wrote in message ... Alexandros I like the break down of the instructions you provided for this problem. I however am working with MS Office 07 and the steps don't work the same. Can you tell me how to do this in 07? "LMK@work" wrote: I want to do a mail merge with 400+ recipients. Is it possible to attach a PDF file? |
#22
|
|||
|
|||
Can you send a mail merge to a large group WITH an attachment?
Yes, you must follow the instructions.
-- 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, originally posted via msnews.microsoft.com "DPJAEGER" wrote in message ... J Wilkie - I was in the exact same spot you are in, and I understand how frustrating it can be to get so close only to have that “0 Messages Sent” box laughing at you. It turns out that my problem was that I was not merging the document that I wanted to email out into a new document before running the macro. From the final letter you wish to merge, go to “Finish and Merge” under the “Mailings” tab and select “Edit Individual Documents…” your mail merge document will be exported to a new document that will have all the letters with the correct information listed one right after the other (see Doug Robbin’s last post on 1/5/2007 or steps 7 and 8 of alexandros.papadopoulos’s outline). Then from THAT screen, run the macro and everything should work out for you. Good Luck "J Wilkie" wrote: I have followed all the instructions, have a directory file called Directory Source.xls and Directory.doc and have started a new Word document with the VBA (MS 2007) developer area open. I have got to the stage of having a Word file open with my mail merged letters and on MS 2007 toolbar have created a macro , copying the code given Doug Robbin's file. When I run the macro I get the window, in which I link in Directory.doc and I get a pop up window asking me for subject of emails - almost there - then I get a pop up window saying 0 emails sent. Where am I going wrong? as I seem to be right at the very end? I have checked email addresses (actually I managed to send emails with no attachments yesterday - but today no emails at all. ) Any help appreciated. "Doug Robbins - Word MVP" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm That method works in Word 2007 -- 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 "Wendy" wrote in message ... Alexandros I like the break down of the instructions you provided for this problem. I however am working with MS Office 07 and the steps don't work the same. Can you tell me how to do this in 07? "LMK@work" wrote: I want to do a mail merge with 400+ recipients. Is it possible to attach a PDF file? |
#23
|
|||
|
|||
Can you send a mail merge to a large group WITH an attachment?
Thank you for your posting Alexandros. Your instructions made the original
ones a bit clearer - enough so that now it works! Just a quick question - has anyone found a way to be able to send these emails out "on behalf of" someone (ie, the boss). Thanks a bunch, -- Elizabeth A. Bañuelos MS Office Specialist (MOS) Master Ontario, Canada "alexandros.papadopoulos" wrote: DLS, I can feel your pain as I just spent a couple of hours reading a two-paragraph HOWTO and feeling stupid. I believe it could be written in simpler words, along these lines: 1. Start with a fresh Word document. Go to Tools - Macro - Visual Basic Editor 2. In the Visual Basic Editor window, go to Tools - References and make sure that an item called "Microsoft Outlook 11.0 Object Library" is selected (ticked). Click OK and leave the VBE window open. 3. (optional) Install ExpressClickYes from http://www.contextmagic.com/express-clickyes/ if you have a lot of emails to send and can't afford to wait 5'' and click "Yes" once for every single email that will be sent. 4. Create a new Excel spreadsheet. + On the first column use "email" as the column header and enter all email addresses you wish to send messages to. + On the second column use "file" as the column header and enter the full path to the file that should be sent to the particular address. The full path should be of the form "C:\Documents and Settings\myusername\My Documents\report.doc" or "http://full.path.org/filename.xls" + Save the file as "Directory Source.xls" and close it. 5. Start a new Word document. Start the mail merge wizard. (I assume you know how to do plain mail merge - if not, please look for help in simpler articles and once you've mastered plain mail merge - without attachments - come back to this one). + For document type choose "Directory". + In the "recipients list" step, select the Excel file you just created, "Directory Source.xls" as your data source. + Create a 2x1 table in the Word document (basically a single row split in half). + Insert the merge field "email" in the first (left) cell of the table. + Insert the merge field "file" in the second (right) cell of the table. + Complete the mail merge wizard by selecting to merge "To new document..." and confirming you want all records to be merged. 6. The result is a new Word document, which has a table with all of the information you entered in the Excel spreadsheet "Directory Source.xls". + Save this file as Directory.doc and close it. 7. Open your Word document that you have setup for mail merge. This should have all merge fields that you want, a proper connection to a data source (usually an Excel spreadsheet or a SQL database), the text that ties it all together, etc. This is a working mail merge document, to which we will append the attachments functionality. + Start the mail merge wizard, selecting Document Type: "Letters" + For recipients list, use whatever data source you had setup before worrying about attachments. This data source should have all information necessary to fill in the merge fields of your Word file, but no attachment information. + At the final step of the Wizard choose "Edit Individual Letters". This will create a NEW document (yes, another one!) with all of your merged messages one after the other. 8. With this document active (open & in the foreground), copy the Visual Basic code from Doug's page (http://word.mvps.org/faqs/mailmerge/...ttachments.htm) into a new macro in the Visual Basic Editor you had open from step 1. Make sure that Doug's code is the only thing in that window, no other comments, functions or anything are required. 9. Save the macro and then run it through the Word menu Tools - Macro - Macros 10. If you've done everything right, you should get a pop-up asking you for a filename. Point it to the Word document you created and called "Directory.doc" (the one with the big table of emails and file paths) 11. Activate ExpressClickYes of you want it to automatically approve all outgoing emails. 12. You get another popup for the subject. Just type the subject your emails should have. 13. Enjoy! I've used this with Office 2003 and it works very well. Only limitation I see is that emails get sent in plain text format, but I'm sure there is a way around this. If someone knows how, I'd love to hear. Hope this helps some people get less stuck... -A |
#24
|
|||
|
|||
Can you send a mail merge to a large group WITH an attachment?
In the With oItem....End With part of the code, insert a line
.Sender = [address of sender] -- 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, originally posted via msnews.microsoft.com "Elizabeth A. Bañuelos" wrote in message ... Thank you for your posting Alexandros. Your instructions made the original ones a bit clearer - enough so that now it works! Just a quick question - has anyone found a way to be able to send these emails out "on behalf of" someone (ie, the boss). Thanks a bunch, -- Elizabeth A. Bañuelos MS Office Specialist (MOS) Master Ontario, Canada "alexandros.papadopoulos" wrote: DLS, I can feel your pain as I just spent a couple of hours reading a two-paragraph HOWTO and feeling stupid. I believe it could be written in simpler words, along these lines: 1. Start with a fresh Word document. Go to Tools - Macro - Visual Basic Editor 2. In the Visual Basic Editor window, go to Tools - References and make sure that an item called "Microsoft Outlook 11.0 Object Library" is selected (ticked). Click OK and leave the VBE window open. 3. (optional) Install ExpressClickYes from http://www.contextmagic.com/express-clickyes/ if you have a lot of emails to send and can't afford to wait 5'' and click "Yes" once for every single that will be sent. 4. Create a new Excel spreadsheet. + On the first column use "email" as the column header and enter all email addresses you wish to send messages to. + On the second column use "file" as the column header and enter the full path to the file that should be sent to the particular address. The full path should be of the form "C:\Documents and Settings\myusername\My Documents\report.doc" or "http://full.path.org/filename.xls" + Save the file as "Directory Source.xls" and close it. 5. Start a new Word document. Start the mail merge wizard. (I assume you know how to do plain mail merge - if not, please look for help in simpler articles and once you've mastered plain mail merge - without attachments - come back to this one). + For document type choose "Directory". + In the "recipients list" step, select the Excel file you just created, "Directory Source.xls" as your data source. + Create a 2x1 table in the Word document (basically a single row split in half). + Insert the merge field "email" in the first (left) cell of the table. + Insert the merge field "file" in the second (right) cell of the table. + Complete the mail merge wizard by selecting to merge "To new document..." and confirming you want all records to be merged. 6. The result is a new Word document, which has a table with all of the information you entered in the Excel spreadsheet "Directory Source.xls". + Save this file as Directory.doc and close it. 7. Open your Word document that you have setup for mail merge. This should have all merge fields that you want, a proper connection to a data source (usually an Excel spreadsheet or a SQL database), the text that ties it all together, etc. This is a working mail merge document, to which we will append the attachments functionality. + Start the mail merge wizard, selecting Document Type: "Letters" + For recipients list, use whatever data source you had setup before worrying about attachments. This data source should have all information necessary to fill in the merge fields of your Word file, but no attachment information. + At the final step of the Wizard choose "Edit Individual Letters". This will create a NEW document (yes, another one!) with all of your merged messages one after the other. 8. With this document active (open & in the foreground), copy the Visual Basic code from Doug's page (http://word.mvps.org/faqs/mailmerge/...ttachments.htm) into a new macro in the Visual Basic Editor you had open from step 1. Make sure that Doug's code is the only thing in that window, no other comments, functions or anything are required. 9. Save the macro and then run it through the Word menu Tools - Macro - Macros 10. If you've done everything right, you should get a pop-up asking you for a filename. Point it to the Word document you created and called "Directory.doc" (the one with the big table of emails and file paths) 11. Activate ExpressClickYes of you want it to automatically approve all outgoing emails. 12. You get another popup for the subject. Just type the subject your emails should have. 13. Enjoy! I've used this with Office 2003 and it works very well. Only limitation I see is that emails get sent in plain text format, but I'm sure there is a way around this. If someone knows how, I'd love to hear. Hope this helps some people get less stuck... -A |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can not access Send To Mail Recipient (As Attachment) Function in | PaulV | Setup, Installing & Configuration | 0 | March 2nd, 2005 02:41 AM |
ambiguous outer joins | renwick | Running & Setting Up Queries | 3 | February 22nd, 2005 02:29 PM |
mail merge with attachments | AS | Mailmerge | 3 | December 21st, 2004 05:11 AM |
How do I send an attachment in a mail merge email? | Autumn | Mailmerge | 1 | November 9th, 2004 04:47 AM |
Merge to Fax with SBS/Exchange? | Tom | Mailmerge | 3 | May 18th, 2004 11:22 PM |