Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
@mba @mba is offline
external usenet poster
 
Posts: 1
Default Print diferent tag's in the same page after a merge to word from e

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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Print diferent tag's in the same page after a merge to word from e

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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Print diferent tag's in the same page after a merge to word from e

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing Problem, 1st page ok, the second prints diferent [email protected] Mailmerge 1 November 30th 06 09:46 AM
When printing from MS word2003 get diferent font Lee Page Layout 0 November 29th 06 06:03 PM
When printing from MS word2003 get diferent font Hugo Page Layout 0 November 29th 06 04:54 PM
Diferent margins for each page!!!!! Bruno Leal Page Layout 2 September 23rd 05 06:13 PM
underline in a diferent color to my typing? terry New Users 6 August 24th 05 04:35 AM


All times are GMT +1. The time now is 06:30 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"