Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
I would like to know how can I print diferent tag's in the same page after a
merge to 2003 word from 2003 excel? For example I have this table: Tag number Equipment 450P002 Pump 321M005 Motor 433T011 Tank 433V019 Valve 450M023 Motor 321P045 Pump 321T053 Tank 433P062 Pump Then I merge this table from 2003 excel to 2003 word and I want to print the first 4 diferent tag's in the first page and the other diferent 4 tag's in the second page. |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Hi mba,
You could use a label merge, with provision for four labels/page. Alternatively, you could use a Directory/Catalogue merge, coupled with a field coded like: {IF{=MOD({MERGEREC},4)}= 0 {QUOTE 12}} after a single pair of Tag_Number and Equipment mergefields. Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. -- Cheers macropod [Microsoft MVP - Word] "@mba" wrote in message ... I would like to know how can I print diferent tag's in the same page after a merge to 2003 word from 2003 excel? For example I have this table: Tag number Equipment 450P002 Pump 321M005 Motor 433T011 Tank 433V019 Valve 450M023 Motor 321P045 Pump 321T053 Tank 433P062 Pump Then I merge this table from 2003 excel to 2003 word and I want to print the first 4 diferent tag's in the first page and the other diferent 4 tag's in the second page. |
#3
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Insert four sets of merge fields on the mailmerge main document in the
configuration that you want them and insert a Next Record field before the first merge field for the second through the fourth sets of merge fields. -- 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 "@mba" wrote in message ... I would like to know how can I print diferent tag's in the same page after a merge to 2003 word from 2003 excel? For example I have this table: Tag number Equipment 450P002 Pump 321M005 Motor 433T011 Tank 433V019 Valve 450M023 Motor 321P045 Pump 321T053 Tank 433P062 Pump Then I merge this table from 2003 excel to 2003 word and I want to print the first 4 diferent tag's in the first page and the other diferent 4 tag's in the second page. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing Problem, 1st page ok, the second prints diferent | Mailmerge | |||
When printing from MS word2003 get diferent font | Page Layout | |||
When printing from MS word2003 get diferent font | Page Layout | |||
Diferent margins for each page!!!!! | Page Layout | |||
underline in a diferent color to my typing? | New Users |