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 |
#11
|
|||
|
|||
Graham Mayor -- individual merge letters
I'm so excited!!!!! I got the mail merge into individual documents to work
AND it retained my different first page and second page header and footer. The only problem I have now is that it also created two extra blank pages (by a section break (next page) and a page break) at the end of every individual document. I took the page break separating the first and second page out of the original letter and the template I used, so I don't think that's the problem. I did noticed that in the single merged document (from which I run the macro to separate into individual documents) that there's a section break (next page) in-between each letter and then a section break (continuous) and a return after the very last letter. I thought that might be part of the problem but when I delete this last break, it screws up the pagination on the last letter. If I could fix this one last glitch, I should be good to go. Whew, you have no idea how long I've been struggling with this. |
#12
|
|||
|
|||
Graham Mayor -- individual merge letters
Insert the following line of code before ActiveDocument.SaveAs
FileName:=Docname, FileFormat:=wdFormatDocument AcitveDocument.Sections(ActiveDocuemnt.Sections.Co unt).PageSetup.SectionStart = wdSectionContinuous -- 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 "zoolaw444" wrote in message ... I'm so excited!!!!! I got the mail merge into individual documents to work AND it retained my different first page and second page header and footer. The only problem I have now is that it also created two extra blank pages (by a section break (next page) and a page break) at the end of every individual document. I took the page break separating the first and second page out of the original letter and the template I used, so I don't think that's the problem. I did noticed that in the single merged document (from which I run the macro to separate into individual documents) that there's a section break (next page) in-between each letter and then a section break (continuous) and a return after the very last letter. I thought that might be part of the problem but when I delete this last break, it screws up the pagination on the last letter. If I could fix this one last glitch, I should be good to go. Whew, you have no idea how long I've been struggling with this. |
#13
|
|||
|
|||
Graham Mayor -- individual merge letters
Doug's suggestion didn't work. Any ideas?
|
#14
|
|||
|
|||
Graham Mayor -- individual merge letters
Not really. It is almost certainly related to the template you are now using
with the macro. It really only needs to contain the margins and the styles used in the letter document. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org zoolaw444 wrote: Doug's suggestion didn't work. Any ideas? |
#15
|
|||
|
|||
Graham Mayor -- individual merge letters
I've modified the template as many different ways as I can think of but it
doesn't make any difference. I will just manually delete the extra page break and section break at the end of each document. Thank you very much for your assistance. |
#16
|
|||
|
|||
Graham Mayor -- individual merge letters
I assume that you corrected the spelling mistakes in the command that I
suggested. -- 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 "zoolaw444" wrote in message ... Doug's suggestion didn't work. Any ideas? |
#17
|
|||
|
|||
Graham Mayor -- individual merge letters
Yes, I corrected your typing errors. When I run the macro with the additional
code, there's no change. It looks like what it's doing is creating a new document for each individual letter that contains the section breaks and page breaks for two complete letters within each individual document. When I open each document, there's the letter itself with the large header on the first page to accommodate our letterhead logo and a smaller header on the second page, then a section break. In the new section after the section break, it repeats itself - again the large header on the first page, then a page break, and a second page with the smaller header only both these extra pages ges are blank. "Doug Robbins - Word MVP" wrote: I assume that you corrected the spelling mistakes in the command that I suggested. -- 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 "zoolaw444" wrote in message ... Doug's suggestion didn't work. Any ideas? |
#18
|
|||
|
|||
Graham Mayor -- individual merge letters
The problem is your section break in the original letter template. Section
breaks are rarely (if ever) needed in a letter template - see http://sbarnhill.mvps.org/WordFAQs/Letterhead.htm. It might be worth correcting the template and the original merge letter to avoid the section breaks and then the problem shouldn't arise in the first place. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org zoolaw444 wrote: Yes, I corrected your typing errors. When I run the macro with the additional code, there's no change. It looks like what it's doing is creating a new document for each individual letter that contains the section breaks and page breaks for two complete letters within each individual document. When I open each document, there's the letter itself with the large header on the first page to accommodate our letterhead logo and a smaller header on the second page, then a section break. In the new section after the section break, it repeats itself - again the large header on the first page, then a page break, and a second page with the smaller header only both these extra pages ges are blank. "Doug Robbins - Word MVP" wrote: I assume that you corrected the spelling mistakes in the command that I suggested. -- 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 "zoolaw444" wrote in message ... Doug's suggestion didn't work. Any ideas? |
#19
|
|||
|
|||
Graham Mayor -- individual merge letters
What do you mean by "original letter template"? The template I created (mail
merge.dot) which I then used in the SplitMerge macro does not have any page breaks or sections breaks, nor does the letter I start with. This is what I'm doing: Open the letter I'm using in Word Tools - Letters and Mailings - Mail Merge Use the current document Select your contacts In the "write your letter" part I added the address fields Complete the merge Edit individual letters (Here, Word creates the single document that contains all of my letters, each letter separated by a section break. This is the first time section breaks appear and they are automatically generated by the process Word goes through in doing the mail merge. It's in this document that I run the macro.) Does this make sense? |
#20
|
|||
|
|||
Graham Mayor -- individual merge letters
Something that you should check - with your mail merge main document open,
if you go into File|Page Setup, is the document set up for double-sided paper, mirror margins, or anything else "unusual" ? In particular is Pages|Multiple pages on the "Margins" tab set to anything other than "Normal" ? Peter Jamieson "zoolaw444" wrote in message ... Yes, I corrected your typing errors. When I run the macro with the additional code, there's no change. It looks like what it's doing is creating a new document for each individual letter that contains the section breaks and page breaks for two complete letters within each individual document. When I open each document, there's the letter itself with the large header on the first page to accommodate our letterhead logo and a smaller header on the second page, then a section break. In the new section after the section break, it repeats itself - again the large header on the first page, then a page break, and a second page with the smaller header only both these extra pages ges are blank. "Doug Robbins - Word MVP" wrote: I assume that you corrected the spelling mistakes in the command that I suggested. -- 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 "zoolaw444" wrote in message ... Doug's suggestion didn't work. Any ideas? |
Thread Tools | |
Display Modes | |
|
|