mail merge multiple documents Grayson 3/22/2007 3:44:02 AM I need to send a personalised email to 150 odd recipients with two personalised Word attachments. How do I do it all with one email?

Re: mail merge multiple documents "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 3/22/2007 4:44:18 AM See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm To create the attachments, you may want to use one of the methods in 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. -- 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 "Grayson" <Grayson[ at ]discussions.microsoft.com> wrote in message news:95E2937F-63FD-4D1B-8E77-35BF8DD1D418[ at ]microsoft.com... [Quoted Text] >I need to send a personalised email to 150 odd recipients with two > personalised Word attachments. How do I do it all with one email?

Re: mail merge multiple documents - formatting problems Sonny 5/9/2007 6:56:00 AM I am using Word 2007. I tried using the procedure described in http://www.gmayor.com/individual_merge_letters.htm A really handy procedure - thanks! I got the different letters in different files, BUT the formatting was wrong. It used "Calibri" as font instead of "Times New Roman" and also some other changes I belive. I have set "Times New Roman" as default font. It made the letters 11 pages long instead of 7. I do not have this formatting problem when using the standard mail merge. Why is this happening and how can I prevent it for happening? Thanks in advance! "Doug Robbins - Word MVP" wrote: [Quoted Text] > See the article "Mail Merge to E-mail with Attachments" at > > http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm > > To create the attachments, you may want to use one of the methods in > 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. > > > > > -- > 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 > > "Grayson" <Grayson[ at ]discussions.microsoft.com> wrote in message > news:95E2937F-63FD-4D1B-8E77-35BF8DD1D418[ at ]microsoft.com... > >I need to send a personalised email to 150 odd recipients with two > > personalised Word attachments. How do I do it all with one email? > > >

Re: mail merge multiple documents - formatting problems "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/9/2007 1:35:21 PM If you create a new blank document, what is the font in that document? I think if you change the default font in the normal template to Times New Roman, that font should be used in the letters -- 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 "Sonny" <Sonny[ at ]discussions.microsoft.com> wrote in message news:9684444D-87D1-45A9-926E-9084F57155AC[ at ]microsoft.com... [Quoted Text] >I am using Word 2007. I tried using the procedure described in > http://www.gmayor.com/individual_merge_letters.htm > > A really handy procedure - thanks! > > I got the different letters in different files, BUT the formatting was > wrong. It used "Calibri" as font instead of "Times New Roman" and also > some > other changes I belive. I have set "Times New Roman" as default font. It > made > the letters 11 pages long instead of 7. I do not have this formatting > problem > when using the standard mail merge. > > Why is this happening and how can I prevent it for happening? > > Thanks in advance! > > "Doug Robbins - Word MVP" wrote: > >> See the article "Mail Merge to E-mail with Attachments" at >> >> http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm >> >> To create the attachments, you may want to use one of the methods in >> 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. >> >> >> >> >> -- >> 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 >> >> "Grayson" <Grayson[ at ]discussions.microsoft.com> wrote in message >> news:95E2937F-63FD-4D1B-8E77-35BF8DD1D418[ at ]microsoft.com... >> >I need to send a personalised email to 150 odd recipients with two >> > personalised Word attachments. How do I do it all with one email? >> >> >>

Re: mail merge multiple documents - formatting problems Sonny 5/9/2007 4:53:01 PM The font in a new blank document is Times New Roman. I did change to that when I got the formatting problems. I did a re-test run now and now the font is correct, maybe Word needed a restart or someting. Thanks! The problem is now reduced to that the spacing between lines are much larger in the merge files than in the orginal file. The orginal document have in a paragraph the following paragraph properties: Spacing After: 0, Linespacing: Single The same paragraph in a "merged document" has the following paragraph properties: Spacing After: 10, Linespacing: at 1,5. These explain some changes I have seen, if not all. The question is how I can get the merged document line spacing to be equal to the orginal document? Thanks in advance again! "Doug Robbins - Word MVP" wrote: [Quoted Text] > If you create a new blank document, what is the font in that document? I > think if you change the default font in the normal template to Times New > Roman, that font should be used in the letters > > -- > 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 > > "Sonny" <Sonny[ at ]discussions.microsoft.com> wrote in message > news:9684444D-87D1-45A9-926E-9084F57155AC[ at ]microsoft.com... > >I am using Word 2007. I tried using the procedure described in > > http://www.gmayor.com/individual_merge_letters.htm > > > > A really handy procedure - thanks! > > > > I got the different letters in different files, BUT the formatting was > > wrong. It used "Calibri" as font instead of "Times New Roman" and also > > some > > other changes I belive. I have set "Times New Roman" as default font. It > > made > > the letters 11 pages long instead of 7. I do not have this formatting > > problem > > when using the standard mail merge. > > > > Why is this happening and how can I prevent it for happening? > > > > Thanks in advance! > > > > "Doug Robbins - Word MVP" wrote: > > > >> See the article "Mail Merge to E-mail with Attachments" at > >> > >> http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm > >> > >> To create the attachments, you may want to use one of the methods in > >> 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. > >> > >> > >> > >> > >> -- > >> 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 > >> > >> "Grayson" <Grayson[ at ]discussions.microsoft.com> wrote in message > >> news:95E2937F-63FD-4D1B-8E77-35BF8DD1D418[ at ]microsoft.com... > >> >I need to send a personalised email to 150 odd recipients with two > >> > personalised Word attachments. How do I do it all with one email? > >> > >> > >> > > >

Re: mail merge multiple documents - formatting problems "Graham Mayor" <gmayor[ at ]DELETECAPSmvps.org> 5/10/2007 4:08:57 AM The issue remains similar to that with the font - ie the normal style in the 2007 default template does not match that in the template the merge document was created from.. Edit the style to match. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Sonny wrote: [Quoted Text] > The font in a new blank document is Times New Roman. I did change to > that when I got the formatting problems. I did a re-test run now and > now the font is correct, maybe Word needed a restart or something. > Thanks! > > The problem is now reduced to that the spacing between lines are much > larger in the merge files than in the original file. > > The original document have in a paragraph the following paragraph > properties: Spacing After: 0, Linespacing: Single > > The same paragraph in a "merged document" has the following paragraph > properties: Spacing After: 10, Linespacing: at 1,5. > > These explain some changes I have seen, if not all. The question is > how I can get the merged document line spacing to be equal to the > orginal document? > > Thanks in advance again! > > "Doug Robbins - Word MVP" wrote: > >> If you create a new blank document, what is the font in that >> document? I think if you change the default font in the normal >> template to Times New Roman, that font should be used in the letters >> >> -- >> 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 >> >> "Sonny" <Sonny[ at ]discussions.microsoft.com> wrote in message >> news:9684444D-87D1-45A9-926E-9084F57155AC[ at ]microsoft.com... >>> I am using Word 2007. I tried using the procedure described in >>> http://www.gmayor.com/individual_merge_letters.htm >>> >>> A really handy procedure - thanks! >>> >>> I got the different letters in different files, BUT the formatting >>> was wrong. It used "Calibri" as font instead of "Times New Roman" >>> and also some >>> other changes I belive. I have set "Times New Roman" as default >>> font. It made >>> the letters 11 pages long instead of 7. I do not have this >>> formatting problem >>> when using the standard mail merge. >>> >>> Why is this happening and how can I prevent it for happening? >>> >>> Thanks in advance! >>> >>> "Doug Robbins - Word MVP" wrote: >>> >>>> See the article "Mail Merge to E-mail with Attachments" at >>>> >>>> http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm >>>> >>>> To create the attachments, you may want to use one of the methods >>>> in >>>> 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. >>>> >>>> >>>> >>>> >>>> -- >>>> 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 >>>> >>>> "Grayson" <Grayson[ at ]discussions.microsoft.com> wrote in message >>>> news:95E2937F-63FD-4D1B-8E77-35BF8DD1D418[ at ]microsoft.com... >>>>> I need to send a personalised email to 150 odd recipients with two >>>>> personalised Word attachments. How do I do it all with one email?