Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2006

Tip: Looking for answers? Try searching our database.

Mailmerge to flash cards, odd and even pages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SCrowley - 17 Nov 2006 22:08 GMT
I am merging to Labels (Avery 5164)

I have data in 3 columns of Excel: Prereq #; Question; Answer

I merge the Question and Prereq # into one label, update all labels, works
great! My issue is when I go to merge the Answer into the same Avery labels,
different document, they are flip flopped example: Question is in Column 1,
Row 1 of front page of document, Answer is in Column 2, Row 1 of second page
(other side of paper)

I'm sure there is a field code or formula that will tell mail merge to flip
flop/transpose the info.

If you've done this, I great appreciate your feedback.

Signature

Thank you,
scrowley(AT)littleonline.com

Doug Robbins - Word MVP - 18 Nov 2006 16:07 GMT
The following code was put together for someone who wanted to compile a
document by taking alternate pages from separate files.  If you were to
execute two separate mail merges to individual documents, you could use this
code to then combine them into one.

   Dim sourcea As Document, sourceb As Document, target As Document, Pages
As Integer, Counter As Integer, targetrange As Range 'targetrange added

   Dim evenpage As Range

   Set sourcea = Documents.Open(FileName:="...")

   sourcea.Repaginate

   Pages = ActiveDocument.BuiltInDocumentProperties(wdPropertyPages)

   MsgBox Pages

   Set sourceb = Documents.Open(FileName:="...")

   Set target = Documents.Add

   target.PageSetup.LeftMargin = sourcea.PageSetup.LeftMargin

   target.PageSetup.RightMargin = sourcea.PageSetup.RightMargin

   target.PageSetup.TopMargin = sourcea.PageSetup.TopMargin

   target.PageSetup.BottomMargin = sourcea.PageSetup.BottomMargin

   target.AcceptAllRevisions

   Counter = 0

   While Counter < Pages

       sourcea.Activate

       ActiveDocument.Bookmarks("\page").Range.Copy

       Set targetrange = target.Range

       targetrange.Start = targetrange.End

       targetrange.Paste

       ActiveDocument.Bookmarks("\page").Range.Cut

       sourceb.Activate 'Assumed to be the document containing the even
pages

       Selection.EndKey Unit:=wdStory 'Line of code added to start from the
end of the document

       ActiveDocument.Bookmarks("\page").Range.Copy

       Set targetrange = target.Range

       targetrange.Start = targetrange.End

       targetrange.Paste

       targetrange.Start = targetrange.End

       targetrange.InsertBreak Type:=wdPageBreak

       Set evenpage = ActiveDocument.Bookmarks("\page").Range

       evenpage.Start = evenpage.Start - 1

       evenpage.Delete

       Counter = Counter + 1

   Wend

   sourcea.Close wdDoNotSaveChanges

   sourceb.Close wdDoNotSaveChanges

Signature

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

>I am merging to Labels (Avery 5164)
>
[quoted text clipped - 14 lines]
>
> If you've done this, I great appreciate your feedback.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.