Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge - Word 2003 / Excel 2003
An employee of the company for which I work is doing a merge from an
excel file into a word doc. The merge works, but we're not able to achieve the effect we want. What we'd like to do is have 2 records on each page, rather than just one. Right now, she has a postcard form, that fits 2 cards to a page. If she prints as currently configured, the address field from the first row in the excel doc fills *both* postcards - so how do I make it so the first and 2nd, 3rd and 4th etc... are on the output. Help? Ben / ND |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge - Word 2003 / Excel 2003
Assuming she has all the layout set up correctly, make sure that there is a
Next record (or { NEXT }) field before the second card on the sheet. There are various ways to insert one, including: - press ctrl-F9 to insert a pair of the special "field code braces" {} - type NEXT in between, to give you { NEXT } Peter Jamieson "NickDangr" wrote in message oups.com... An employee of the company for which I work is doing a merge from an excel file into a word doc. The merge works, but we're not able to achieve the effect we want. What we'd like to do is have 2 records on each page, rather than just one. Right now, she has a postcard form, that fits 2 cards to a page. If she prints as currently configured, the address field from the first row in the excel doc fills *both* postcards - so how do I make it so the first and 2nd, 3rd and 4th etc... are on the output. Help? Ben / ND |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge - Word 2003 / Excel 2003
I did some experimenting, created a fresh form from scratch (never
did a merge before myself) and found that out about 10 minutes ago. Thanks very much though - your answer is dead on. Regards Ben On Feb 8, 2:08 pm, "Peter Jamieson" wrote: Assuming she has all the layout set up correctly, make sure that there is a Next record (or { NEXT }) field before the second card on the sheet. There are various ways to insert one, including: - press ctrl-F9 to insert a pair of the special "field code braces" {} - type NEXT in between, to give you { NEXT } Peter Jamieson "NickDangr" wrote in message oups.com... An employee of the company for which I work is doing a merge from an excel file into a word doc. The merge works, but we're not able to achieve the effect we want. What we'd like to do is have 2 records on each page, rather than just one. Right now, she has a postcard form, that fits 2 cards to a page. If she prints as currently configured, the address field from the first row in the excel doc fills *both* postcards - so how do I make it so the first and 2nd, 3rd and 4th etc... are on the output. Help? Ben / ND |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge labels with Word 2003 and Excel 2003 Data lost data | Mailmerge | |||
how smart can a word 2003 mail merge letter be? | Mailmerge | |||
Why can't I get Multiple instances of word? | Microsoft Word Help | |||
Format Fractions in Mail Merge. | Mailmerge | |||
Word 2003 Mail Merge from Excel spreadsheet database | Mailmerge |