Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saving mail merged letter seperately then emailing
I have succesfully merged my document, now I want to save them as seperate
documents but it will only allow me to save it as one huge one. Once saved seperately, I then need to email them using the email address on each letter as an email merge. Can this be done or am I asking for too much?? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saving mail merged letter seperately then emailing
On Jun 4, 8:57*am, chayanne
wrote: I have succesfully merged my document, now I want to save them as seperate documents but it will only allow me to save it as one huge one. *Once saved seperately, I then need to email them using the email address on each letter as an email merge. *Can this be done or am I asking for too much?? Why don't you just merge straight to email, instead of to a Word document? If you are using Outlook, and have the Journal turned on, each individual email will be logged against the customer card automatically, so you won't have to save individually |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saving mail merged letter seperately then emailing
I need each letter to be personalized and sent as an attachment. I also need
to be able to include additional attachments. I am sending confidential contracts so I can't embed them in the body of the actual email. " wrote: On Jun 4, 8:57 am, chayanne wrote: I have succesfully merged my document, now I want to save them as seperate documents but it will only allow me to save it as one huge one. Once saved seperately, I then need to email them using the email address on each letter as an email merge. Can this be done or am I asking for too much?? Why don't you just merge straight to email, instead of to a Word document? If you are using Outlook, and have the Journal turned on, each individual email will be logged against the customer card automatically, so you won't have to save individually |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saving mail merged letter seperately then emailing
Then you need the methods that I have suggested in response to your original
post. -- 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 "chayanne" wrote in message ... I need each letter to be personalized and sent as an attachment. I also need to be able to include additional attachments. I am sending confidential contracts so I can't embed them in the body of the actual email. " wrote: On Jun 4, 8:57 am, chayanne wrote: I have succesfully merged my document, now I want to save them as seperate documents but it will only allow me to save it as one huge one. Once saved seperately, I then need to email them using the email address on each letter as an email merge. Can this be done or am I asking for too much?? Why don't you just merge straight to email, instead of to a Word document? If you are using Outlook, and have the Journal turned on, each individual email will be logged against the customer card automatically, so you won't have to save individually |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saving mail merged letter seperately then emailing
If you want to send the letters as attachments to an email message, see the
"Individual Merge Letters" item on fellow MVP Graham Mayor's website at: http://www.gmayor.com/individual_merge_letters.htm If you are using Word XP or later, the "Add-in to Merge Letters to Separate Files" that I have written and that can be downloaded from that site will allow you to create each letter as a separate file with a filename taken from a field in the data source with a minimum of fuss. and then for the emailing of them, see the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm Otherwise, as mentioned by Cathyall, you can execute the merge to email, in which case, your letter will be inserted into the body of each email message. -- 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 "chayanne" wrote in message ... I have succesfully merged my document, now I want to save them as seperate documents but it will only allow me to save it as one huge one. Once saved seperately, I then need to email them using the email address on each letter as an email merge. Can this be done or am I asking for too much?? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saving mail merged letter seperately then emailing
Hi doug!
Your site states that I need to extract the MMtoDocRevnn.DOT template but when i clicked on the word add-in template it gave me MMtoDocRev28.DOT. So I used it and put it in start up but when I did the merge the macro code did not take over to offer the choice of merging to separate documents or continuing with a merge to a single document. even though it did actually seperate them to different pages within one document. I assume that I need most recent MMtoDocRevnn.DOT template so I can get that prompt. Where do i need to go to get it?? The latest version of this code is available for download as a Word add-in template. Extract the MMtoDocsRevnn.DOT template (where nn is the latest revision number) to the Word startup folder - its location defined in Word at Tools Options File Locations Startup "Doug Robbins - Word MVP" wrote: If you want to send the letters as attachments to an email message, see the "Individual Merge Letters" item on fellow MVP Graham Mayor's website at: http://www.gmayor.com/individual_merge_letters.htm If you are using Word XP or later, the "Add-in to Merge Letters to Separate Files" that I have written and that can be downloaded from that site will allow you to create each letter as a separate file with a filename taken from a field in the data source with a minimum of fuss. and then for the emailing of them, see the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm Otherwise, as mentioned by Cathyall, you can execute the merge to email, in which case, your letter will be inserted into the body of each email message. -- 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 "chayanne" wrote in message ... I have succesfully merged my document, now I want to save them as seperate documents but it will only allow me to save it as one huge one. Once saved seperately, I then need to email them using the email address on each letter as an email merge. Can this be done or am I asking for too much?? |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saving mail merged letter seperately then emailing
The one you have down loaded is the latest (we keep tweaking it). After you
install it in the Start up folder, you must restart Word and whenever you start Word, it must be started before Outlook (if you use Word as the editor in Outlook) and it must be started from the Windows Start menu and not by double clicking, or right clicking on a Word document on the desktop or in Windows Explorer. -- 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 "chayanne" wrote in message ... Hi doug! Your site states that I need to extract the MMtoDocRevnn.DOT template but when i clicked on the word add-in template it gave me MMtoDocRev28.DOT. So I used it and put it in start up but when I did the merge the macro code did not take over to offer the choice of merging to separate documents or continuing with a merge to a single document. even though it did actually seperate them to different pages within one document. I assume that I need most recent MMtoDocRevnn.DOT template so I can get that prompt. Where do i need to go to get it?? The latest version of this code is available for download as a Word add-in template. Extract the MMtoDocsRevnn.DOT template (where nn is the latest revision number) to the Word startup folder - its location defined in Word at Tools Options File Locations Startup "Doug Robbins - Word MVP" wrote: If you want to send the letters as attachments to an email message, see the "Individual Merge Letters" item on fellow MVP Graham Mayor's website at: http://www.gmayor.com/individual_merge_letters.htm If you are using Word XP or later, the "Add-in to Merge Letters to Separate Files" that I have written and that can be downloaded from that site will allow you to create each letter as a separate file with a filename taken from a field in the data source with a minimum of fuss. and then for the emailing of them, see the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm Otherwise, as mentioned by Cathyall, you can execute the merge to email, in which case, your letter will be inserted into the body of each email message. -- 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 "chayanne" wrote in message ... I have succesfully merged my document, now I want to save them as seperate documents but it will only allow me to save it as one huge one. Once saved seperately, I then need to email them using the email address on each letter as an email merge. Can this be done or am I asking for too much?? |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saving mail merged letter seperately then emailing
do I need to create the macro? since it does not give me the prompt?
"Doug Robbins - Word MVP" wrote: The one you have down loaded is the latest (we keep tweaking it). After you install it in the Start up folder, you must restart Word and whenever you start Word, it must be started before Outlook (if you use Word as the editor in Outlook) and it must be started from the Windows Start menu and not by double clicking, or right clicking on a Word document on the desktop or in Windows Explorer. -- 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 "chayanne" wrote in message ... Hi doug! Your site states that I need to extract the MMtoDocRevnn.DOT template but when i clicked on the word add-in template it gave me MMtoDocRev28.DOT. So I used it and put it in start up but when I did the merge the macro code did not take over to offer the choice of merging to separate documents or continuing with a merge to a single document. even though it did actually seperate them to different pages within one document. I assume that I need most recent MMtoDocRevnn.DOT template so I can get that prompt. Where do i need to go to get it?? The latest version of this code is available for download as a Word add-in template. Extract the MMtoDocsRevnn.DOT template (where nn is the latest revision number) to the Word startup folder - its location defined in Word at Tools Options File Locations Startup "Doug Robbins - Word MVP" wrote: If you want to send the letters as attachments to an email message, see the "Individual Merge Letters" item on fellow MVP Graham Mayor's website at: http://www.gmayor.com/individual_merge_letters.htm If you are using Word XP or later, the "Add-in to Merge Letters to Separate Files" that I have written and that can be downloaded from that site will allow you to create each letter as a separate file with a filename taken from a field in the data source with a minimum of fuss. and then for the emailing of them, see the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm Otherwise, as mentioned by Cathyall, you can execute the merge to email, in which case, your letter will be inserted into the body of each email message. -- 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 "chayanne" wrote in message ... I have succesfully merged my document, now I want to save them as seperate documents but it will only allow me to save it as one huge one. Once saved seperately, I then need to email them using the email address on each letter as an email merge. Can this be done or am I asking for too much?? |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Saving mail merged letter seperately then emailing
Sub SubSplitter()
' ' SubSplitter Macro ' Macro created 6/4/2008 by CLawrence Dim mask As String Selection.EndKey Unit:=wdStory Letters = Selection.Information(wdActiveEndSectionNumber) mask = "ddMMyy" Selection.HomeKey Unit:=wdStory Counter = 1 While Counter Letters DocName = "Z:\My Documents\" & Format(Date, mask) _ & " " & LTrim$(Str$(Counter)) & ".doc" ActiveDocument.Sections.First.Range.Cut Documents.Add With Selection .Paste .EndKey Unit:=wdStory .MoveLeft Unit:=wdCharacter, Count:=1 .Delete Unit:=wdCharacter, Count:=1 End With (THE LINE BELOW IS HIGHLIGHTED YELLOW AS AN ERROR IN VBA, WHAT SHOULD I DO?) ActiveDocument.SaveAs FileName:=DocName, FileFormat:=wdFormatDocument ActiveWindow.Close Counter = Counter + 1 Wend End Sub "chayanne" wrote: do I need to create the macro? since it does not give me the prompt? "Doug Robbins - Word MVP" wrote: The one you have down loaded is the latest (we keep tweaking it). After you install it in the Start up folder, you must restart Word and whenever you start Word, it must be started before Outlook (if you use Word as the editor in Outlook) and it must be started from the Windows Start menu and not by double clicking, or right clicking on a Word document on the desktop or in Windows Explorer. -- 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 "chayanne" wrote in message ... Hi doug! Your site states that I need to extract the MMtoDocRevnn.DOT template but when i clicked on the word add-in template it gave me MMtoDocRev28.DOT. So I used it and put it in start up but when I did the merge the macro code did not take over to offer the choice of merging to separate documents or continuing with a merge to a single document. even though it did actually seperate them to different pages within one document. I assume that I need most recent MMtoDocRevnn.DOT template so I can get that prompt. Where do i need to go to get it?? The latest version of this code is available for download as a Word add-in template. Extract the MMtoDocsRevnn.DOT template (where nn is the latest revision number) to the Word startup folder - its location defined in Word at Tools Options File Locations Startup "Doug Robbins - Word MVP" wrote: If you want to send the letters as attachments to an email message, see the "Individual Merge Letters" item on fellow MVP Graham Mayor's website at: http://www.gmayor.com/individual_merge_letters.htm If you are using Word XP or later, the "Add-in to Merge Letters to Separate Files" that I have written and that can be downloaded from that site will allow you to create each letter as a separate file with a filename taken from a field in the data source with a minimum of fuss. and then for the emailing of them, see the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm Otherwise, as mentioned by Cathyall, you can execute the merge to email, in which case, your letter will be inserted into the body of each email message. -- 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 "chayanne" wrote in message ... I have succesfully merged my document, now I want to save them as seperate documents but it will only allow me to save it as one huge one. Once saved seperately, I then need to email them using the email address on each letter as an email merge. Can this be done or am I asking for too much?? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save a mail merged letter to USB to print offsite | Mailmerge | |||
Saving a mail merged document using the value from a datafield | Mailmerge | |||
Saving a mail merged document using the value from a datafield | Microsoft Word Help | |||
Saving mail merged letters as seperate documents | Microsoft Word Help | |||
How to change details in specific records on a mail merged Letter | Microsoft Word Help |