Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
ulaluma ulaluma is offline
external usenet poster
 
Posts: 3
Default Merge into a single record?

I'm trying to use Word to mailmerge data from Excel columns. I'd like
each column to form a list in Word in a single page. So far I've only
gotten it to create multiple pages, one for each Record or Excel row.
Any suggestions?
Thanks,
Arianna

  #2   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 Merge into a single record?

Use a catalog, or in Word XP and later it is called "directory" type
mailmerge main document in which you have a one row table into the cells of
which you insert the merge fields. When you execute that merge to a new
document, which is the only possible destination, the new document will
contain a table with a row of data for each record in the data source.

--
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

"ulaluma" wrote in message
oups.com...
I'm trying to use Word to mailmerge data from Excel columns. I'd like
each column to form a list in Word in a single page. So far I've only
gotten it to create multiple pages, one for each Record or Excel row.
Any suggestions?
Thanks,
Arianna



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
ulaluma ulaluma is offline
external usenet poster
 
Posts: 3
Default Merge into a single record?

I thought that would work, it's what I have tried and just tried again
in a new document, but I get multiple pages: one page per row of data.
I don't understand what I'm doing wrong.
Thanks for your help,
Arianna

  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
ulaluma ulaluma is offline
external usenet poster
 
Posts: 3
Default Merge into a single record?

Never mind! Key words I missed: "Merge to a new document"!
Thanks!
Arianna

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
How do i use next record in a mail merge Sue D. Mailmerge 1 May 2nd 06 04:52 AM
sort mail merge by merge record number nathan Mailmerge 1 August 10th 05 07:09 AM
Merge If and Next Record Question Delnang Mailmerge 1 May 26th 05 07:22 PM
label merge only 1st record is merging-rest of source won't merge harriet Mailmerge 2 March 29th 05 04:26 PM
merge is only merging every 3rd record - how do i fix it? johnette Mailmerge 1 February 24th 05 11:28 PM


All times are GMT +1. The time now is 11:36 AM.

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

About Us

"It's about Microsoft Word"