A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is there an option for a Previous record



 
 
Thread Tools Display Modes
  #1  
Old August 24th, 2009, 01:24 AM posted to microsoft.public.word.mailmerge.fields
Jose Manuel[_2_]
external usenet poster
 
Posts: 6
Default Is there an option for a Previous record

Hi! I need to merge some cards. The cards have information in both sides, so
I need the information like name and address in page 1, and other info like
mail and phone in page 2 (back).

The problem is that I cannot find an option for the "Previous record" (like
the one of "Next record"). I need to go back 8 records at the top of page 2
in order to merge the other information of the same records of page 1.

Do you know if there is such a thing? What would you recomend?

Thanks!

Manuel
  #2  
Old August 24th, 2009, 08:44 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Is there an option for a Previous record


The following article by two of the regular contributors here may help:

http://www.gmayor.com/duplex_merge_data.htm

(There isn't a "Previous record" feature)

The other approach requires you to
(a) have a label layout that is two sides long
(b) use SET fields to make temporary copies of the data in each record
on the front for re-use via REF fields on the back. e.g. if you just
have one field, "frontfield" on the front and one field, "backfield", on
the back, then you would do something like

(card1)
{ SET myback1 { MERGEFIELD backfield }
}{ MERGEFIELD frontfield }

(card2)
{ NEXT }
{ SET myback2 { MERGEFIELD backfield }
}{ MERGEFIELD frontfield }

(card3)
{ NEXT }
{ SET myback3 { MERGEFIELD backfield }
}{ MERGEFIELD frontfield }

etc., then on the back you would use e.g. with a 2x2 card layout

(card2 back)
{ REF myback2 }

(card1 back)
{ REF myback1 }

etc.

Peter Jamieson

http://tips.pjmsn.me.uk

Jose Manuel wrote:
Hi! I need to merge some cards. The cards have information in both sides, so
I need the information like name and address in page 1, and other info like
mail and phone in page 2 (back).

The problem is that I cannot find an option for the "Previous record" (like
the one of "Next record"). I need to go back 8 records at the top of page 2
in order to merge the other information of the same records of page 1.

Do you know if there is such a thing? What would you recomend?

Thanks!

Manuel

  #3  
Old August 24th, 2009, 08:47 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Is there an option for a Previous record

See the article “Duplex Merge Data for Postcards” on fellow MVP Graham Mayor’s
website at:
http://www.gmayor.com/duplex_merge_data.htm
If that information is of use to you, please do consider contributing to the
maintenance of that website to ensure its continued availability.


--
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, originally posted via msnews.microsoft.com
"Jose Manuel" wrote in message
news
Hi! I need to merge some cards. The cards have information in both sides,
so
I need the information like name and address in page 1, and other info
like
mail and phone in page 2 (back).

The problem is that I cannot find an option for the "Previous record"
(like
the one of "Next record"). I need to go back 8 records at the top of page
2
in order to merge the other information of the same records of page 1.

Do you know if there is such a thing? What would you recomend?

Thanks!

Manuel


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.