Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
I need to send a mailmerge email, with a word and excel attachment. I have
created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
I am not sure what you mean by "in the regular way" as Word does not have
that capability "out of the box" See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- 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 "paula" wrote in message ... I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
See the article prepared by fellow MVP Doug Robbins at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
Could someone run me through the details of the setup of this article?
-- GVP "Graham Mayor" wrote: See the article prepared by fellow MVP Doug Robbins at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
What part of it don't you understand?
-- 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 "Gail" wrote in message ... Could someone run me through the details of the setup of this article? -- GVP "Graham Mayor" wrote: See the article prepared by fellow MVP Doug Robbins at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
Hi
I do not know how to create a separate Directory type mail merge main doc. I currently have my data source in an excel doc and have created two separate columns for my attachments. I them merged this into my word doc, executed it to a new doc and ran the macro. An error message appear as follows: Compile error: User-defined type not defined. -- GVP "Doug Robbins - Word MVP" wrote: What part of it don't you understand? -- 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 "Gail" wrote in message ... Could someone run me through the details of the setup of this article? -- GVP "Graham Mayor" wrote: See the article prepared by fellow MVP Doug Robbins at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
The article goes into quite a bit of detail about how the catalog (or in XP
and later, it is called directory) type mailmerge document is set up. -- 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 "Gail" wrote in message ... Hi I do not know how to create a separate Directory type mail merge main doc. I currently have my data source in an excel doc and have created two separate columns for my attachments. I them merged this into my word doc, executed it to a new doc and ran the macro. An error message appear as follows: Compile error: User-defined type not defined. -- GVP "Doug Robbins - Word MVP" wrote: What part of it don't you understand? -- 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 "Gail" wrote in message ... Could someone run me through the details of the setup of this article? -- GVP "Graham Mayor" wrote: See the article prepared by fellow MVP Doug Robbins at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
Hi Doug
Not sure you got my reply yesterday so here goes. I have still had no luck. This is exactly what I do, step by step. I have my letter in word (Let 1) and my data source in excel (data 1) In Word I have opened a new doc, I then mail merge chose directory used the current doc selected recipients included attachments executed the mail merge to a new doc saved it (gail1) and closed it. I then. opened the letter (Let 1) I want to send out by email with the attachments, mailmerge email message current doc selected my data source (data 1) included my address block and greeting line preview email messaging executed the mail merge to a new doc made sure that Microsoft Office Outlook 11.0 Object Library is selected ran the macro (which I copied and pasted). The following error message: Compile error: user-defined type not defined appears and the line Dim oOutlookApp As Outlook.Application in the macro is highlighted. Hope you can help. GVP "Doug Robbins - Word MVP" wrote: The article goes into quite a bit of detail about how the catalog (or in XP and later, it is called directory) type mailmerge document is set up. -- 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 "Gail" wrote in message ... Hi I do not know how to create a separate Directory type mail merge main doc. I currently have my data source in an excel doc and have created two separate columns for my attachments. I them merged this into my word doc, executed it to a new doc and ran the macro. An error message appear as follows: Compile error: User-defined type not defined. -- GVP "Doug Robbins - Word MVP" wrote: What part of it don't you understand? -- 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 "Gail" wrote in message ... Could someone run me through the details of the setup of this article? -- GVP "Graham Mayor" wrote: See the article prepared by fellow MVP Doug Robbins at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
I posted the following response to your message in another thread yesterday.
You should keep to the one thread so that it is easier to find the responses. I don't really know what is causing the reference to be ignored. It is the first time that I have heard of it happening. In the References dialog in the Visual Basic Editor, when the Microsoft Office Outlook 11.0 Object Library is selected, what appears in the lower section of the dialog where the location of the file is shown? -- 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 "Gail" wrote in message ... Hi Doug Not sure you got my reply yesterday so here goes. I have still had no luck. This is exactly what I do, step by step. I have my letter in word (Let 1) and my data source in excel (data 1) In Word I have opened a new doc, I then mail merge - chose directory - used the current doc - selected recipients - included attachments - executed the mail merge to a new doc - saved it (gail1) and closed it. I then. opened the letter (Let 1) I want to send out by email with the attachments, mailmerge - email message - current doc - selected my data source (data 1) - included my address block and greeting line - preview messaging - executed the mail merge to a new doc - made sure that Microsoft Office Outlook 11.0 Object Library is selected - ran the macro (which I copied and pasted). The following error message: "Compile error: user-defined type not defined" appears and the line "Dim oOutlookApp As Outlook.Application" in the macro is highlighted. Hope you can help. GVP "Doug Robbins - Word MVP" wrote: The article goes into quite a bit of detail about how the catalog (or in XP and later, it is called directory) type mailmerge document is set up. -- 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 "Gail" wrote in message ... Hi I do not know how to create a separate Directory type mail merge main doc. I currently have my data source in an excel doc and have created two separate columns for my attachments. I them merged this into my word doc, executed it to a new doc and ran the macro. An error message appear as follows: Compile error: User-defined type not defined. -- GVP "Doug Robbins - Word MVP" wrote: What part of it don't you understand? -- 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 "Gail" wrote in message ... Could someone run me through the details of the setup of this article? -- GVP "Graham Mayor" wrote: See the article prepared by fellow MVP Doug Robbins at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M
Language: Standard -- GVP "Doug Robbins - Word MVP" wrote: I posted the following response to your message in another thread yesterday. You should keep to the one thread so that it is easier to find the responses. I don't really know what is causing the reference to be ignored. It is the first time that I have heard of it happening. In the References dialog in the Visual Basic Editor, when the Microsoft Office Outlook 11.0 Object Library is selected, what appears in the lower section of the dialog where the location of the file is shown? -- 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 "Gail" wrote in message ... Hi Doug Not sure you got my reply yesterday so here goes. I have still had no luck. This is exactly what I do, step by step. I have my letter in word (Let 1) and my data source in excel (data 1) In Word I have opened a new doc, I then mail merge - chose directory - used the current doc - selected recipients - included attachments - executed the mail merge to a new doc - saved it (gail1) and closed it. I then. opened the letter (Let 1) I want to send out by email with the attachments, mailmerge - email message - current doc - selected my data source (data 1) - included my address block and greeting line - preview messaging - executed the mail merge to a new doc - made sure that Microsoft Office Outlook 11.0 Object Library is selected - ran the macro (which I copied and pasted). The following error message: "Compile error: user-defined type not defined" appears and the line "Dim oOutlookApp As Outlook.Application" in the macro is highlighted. Hope you can help. GVP "Doug Robbins - Word MVP" wrote: The article goes into quite a bit of detail about how the catalog (or in XP and later, it is called directory) type mailmerge document is set up. -- 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 "Gail" wrote in message ... Hi I do not know how to create a separate Directory type mail merge main doc. I currently have my data source in an excel doc and have created two separate columns for my attachments. I them merged this into my word doc, executed it to a new doc and ran the macro. An error message appear as follows: Compile error: User-defined type not defined. -- GVP "Doug Robbins - Word MVP" wrote: What part of it don't you understand? -- 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 "Gail" wrote in message ... Could someone run me through the details of the setup of this article? -- GVP "Graham Mayor" wrote: See the article prepared by fellow MVP Doug Robbins at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#11
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
Is this
Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M all there is? It should be Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\msoutl.olb -- 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 "Gail" wrote in message ... Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M Language: Standard -- GVP "Doug Robbins - Word MVP" wrote: I posted the following response to your message in another thread yesterday. You should keep to the one thread so that it is easier to find the responses. I don't really know what is causing the reference to be ignored. It is the first time that I have heard of it happening. In the References dialog in the Visual Basic Editor, when the Microsoft Office Outlook 11.0 Object Library is selected, what appears in the lower section of the dialog where the location of the file is shown? -- 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 "Gail" wrote in message ... Hi Doug Not sure you got my reply yesterday so here goes. I have still had no luck. This is exactly what I do, step by step. I have my letter in word (Let 1) and my data source in excel (data 1) In Word I have opened a new doc, I then mail merge - chose directory - used the current doc - selected recipients - included attachments - executed the mail merge to a new doc - saved it (gail1) and closed it. I then. opened the letter (Let 1) I want to send out by email with the attachments, mailmerge - email message - current doc - selected my data source (data 1) - included my address block and greeting line - preview messaging - executed the mail merge to a new doc - made sure that Microsoft Office Outlook 11.0 Object Library is selected - ran the macro (which I copied and pasted). The following error message: "Compile error: user-defined type not defined" appears and the line "Dim oOutlookApp As Outlook.Application" in the macro is highlighted. Hope you can help. GVP "Doug Robbins - Word MVP" wrote: The article goes into quite a bit of detail about how the catalog (or in XP and later, it is called directory) type mailmerge document is set up. -- 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 "Gail" wrote in message ... Hi I do not know how to create a separate Directory type mail merge main doc. I currently have my data source in an excel doc and have created two separate columns for my attachments. I them merged this into my word doc, executed it to a new doc and ran the macro. An error message appear as follows: Compile error: User-defined type not defined. -- GVP "Doug Robbins - Word MVP" wrote: What part of it don't you understand? -- 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 "Gail" wrote in message ... Could someone run me through the details of the setup of this article? -- GVP "Graham Mayor" wrote: See the article prepared by fellow MVP Doug Robbins at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#12
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
Yes
-- GVP "Doug Robbins - Word MVP" wrote: Is this Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M all there is? It should be Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\msoutl.olb -- 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 "Gail" wrote in message ... Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M Language: Standard -- GVP "Doug Robbins - Word MVP" wrote: I posted the following response to your message in another thread yesterday. You should keep to the one thread so that it is easier to find the responses. I don't really know what is causing the reference to be ignored. It is the first time that I have heard of it happening. In the References dialog in the Visual Basic Editor, when the Microsoft Office Outlook 11.0 Object Library is selected, what appears in the lower section of the dialog where the location of the file is shown? -- 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 "Gail" wrote in message ... Hi Doug Not sure you got my reply yesterday so here goes. I have still had no luck. This is exactly what I do, step by step. I have my letter in word (Let 1) and my data source in excel (data 1) In Word I have opened a new doc, I then mail merge - chose directory - used the current doc - selected recipients - included attachments - executed the mail merge to a new doc - saved it (gail1) and closed it. I then. opened the letter (Let 1) I want to send out by email with the attachments, mailmerge - email message - current doc - selected my data source (data 1) - included my address block and greeting line - preview messaging - executed the mail merge to a new doc - made sure that Microsoft Office Outlook 11.0 Object Library is selected - ran the macro (which I copied and pasted). The following error message: "Compile error: user-defined type not defined" appears and the line "Dim oOutlookApp As Outlook.Application" in the macro is highlighted. Hope you can help. GVP "Doug Robbins - Word MVP" wrote: The article goes into quite a bit of detail about how the catalog (or in XP and later, it is called directory) type mailmerge document is set up. -- 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 "Gail" wrote in message ... Hi I do not know how to create a separate Directory type mail merge main doc. I currently have my data source in an excel doc and have created two separate columns for my attachments. I them merged this into my word doc, executed it to a new doc and ran the macro. An error message appear as follows: Compile error: User-defined type not defined. -- GVP "Doug Robbins - Word MVP" wrote: What part of it don't you understand? -- 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 "Gail" wrote in message ... Could someone run me through the details of the setup of this article? -- GVP "Graham Mayor" wrote: See the article prepared by fellow MVP Doug Robbins at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
#13
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge with excel attachment
I gather from your response that you are saying that
Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M is all there is. If that is the case, I think that you will need to repair the installation of Office using the Add/Remove Programs application in the Control Panel. -- 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 "Gail" wrote in message ... Yes -- GVP "Doug Robbins - Word MVP" wrote: Is this Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M all there is? It should be Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\msoutl.olb -- 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 "Gail" wrote in message ... Location: C:\Program Files\Common Files\Microsoft Shared\Office 11\M Language: Standard -- GVP "Doug Robbins - Word MVP" wrote: I posted the following response to your message in another thread yesterday. You should keep to the one thread so that it is easier to find the responses. I don't really know what is causing the reference to be ignored. It is the first time that I have heard of it happening. In the References dialog in the Visual Basic Editor, when the Microsoft Office Outlook 11.0 Object Library is selected, what appears in the lower section of the dialog where the location of the file is shown? -- 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 "Gail" wrote in message ... Hi Doug Not sure you got my reply yesterday so here goes. I have still had no luck. This is exactly what I do, step by step. I have my letter in word (Let 1) and my data source in excel (data 1) In Word I have opened a new doc, I then mail merge - chose directory - used the current doc - selected recipients - included attachments - executed the mail merge to a new doc - saved it (gail1) and closed it. I then. opened the letter (Let 1) I want to send out by email with the attachments, mailmerge - email message - current doc - selected my data source (data 1) - included my address block and greeting line - preview messaging - executed the mail merge to a new doc - made sure that Microsoft Office Outlook 11.0 Object Library is selected - ran the macro (which I copied and pasted). The following error message: "Compile error: user-defined type not defined" appears and the line "Dim oOutlookApp As Outlook.Application" in the macro is highlighted. Hope you can help. GVP "Doug Robbins - Word MVP" wrote: The article goes into quite a bit of detail about how the catalog (or in XP and later, it is called directory) type mailmerge document is set up. -- 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 "Gail" wrote in message ... Hi I do not know how to create a separate Directory type mail merge main doc. I currently have my data source in an excel doc and have created two separate columns for my attachments. I them merged this into my word doc, executed it to a new doc and ran the macro. An error message appear as follows: Compile error: User-defined type not defined. -- GVP "Doug Robbins - Word MVP" wrote: What part of it don't you understand? -- 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 "Gail" wrote in message ... Could someone run me through the details of the setup of this article? -- GVP "Graham Mayor" wrote: See the article prepared by fellow MVP Doug Robbins at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org paula wrote: I need to send a mailmerge email, with a word and excel attachment. I have created the mail merge email, attach the files in the regular way, and execute the mail merge, however it does not send the attachements. Can anyone help? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numeric rounding problems in mail merge with excel data source. | Mailmerge | |||
word to excel mail merge help please.... | Mailmerge | |||
Mail Merge does not accept formatted cell of Excel | Mailmerge | |||
Is there a way to export from mail merge to excel? | Mailmerge | |||
Include linked graphs from Excel during mail merge? | Mailmerge |