Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Millieac Millieac is offline
external usenet poster
 
Posts: 7
Default How do I create a catalog in word 2007 from data in excel?

I am trying to create a catalog of information on different systems that will
include page numbering for the whole document and a Table of Contents. I have
the data in an excel spreadsheet and thought it would be straightforward
using mail merge in word. However, the final merged document still behaves as
a series of individual documents. I cannot get the document to number from
1-128. It keeps numbering 1-3 ( the number of pages that it took to document
each separate system).
  #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 How do I create a catalog in word 2007 from data in excel?

Use a Directory type mail merge main document.

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

"Millieac" wrote in message
...
I am trying to create a catalog of information on different systems that
will
include page numbering for the whole document and a Table of Contents. I
have
the data in an excel spreadsheet and thought it would be straightforward
using mail merge in word. However, the final merged document still behaves
as
a series of individual documents. I cannot get the document to number from
1-128. It keeps numbering 1-3 ( the number of pages that it took to
document
each separate system).


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Millieac Millieac is offline
external usenet poster
 
Posts: 7
Default How do I create a catalog in word 2007 from data in excel?

How do I do that? It would be easier.
I did figure out a work-around. After merging the documents into one long
document, I did a find and replace and replaced the section breaks with a
manual page break. This broke the numbering by section.

"Doug Robbins - Word MVP" wrote:

Use a Directory type mail merge main document.

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

"Millieac" wrote in message
...
I am trying to create a catalog of information on different systems that
will
include page numbering for the whole document and a Table of Contents. I
have
the data in an excel spreadsheet and thought it would be straightforward
using mail merge in word. However, the final merged document still behaves
as
a series of individual documents. I cannot get the document to number from
1-128. It keeps numbering 1-3 ( the number of pages that it took to
document
each separate system).


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Millieac Millieac is offline
external usenet poster
 
Posts: 7
Default How do I create a catalog in word 2007 from data in excel?

I found the directory, but it causes problems with the outline numbering in
my document. What I need to happen is to format ALL the footers in the
document to link to the previous so that the page numbering will sequence.

"Millieac" wrote:

How do I do that? It would be easier.
I did figure out a work-around. After merging the documents into one long
document, I did a find and replace and replaced the section breaks with a
manual page break. This broke the numbering by section.

"Doug Robbins - Word MVP" wrote:

Use a Directory type mail merge main document.

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

"Millieac" wrote in message
...
I am trying to create a catalog of information on different systems that
will
include page numbering for the whole document and a Table of Contents. I
have
the data in an excel spreadsheet and thought it would be straightforward
using mail merge in word. However, the final merged document still behaves
as
a series of individual documents. I cannot get the document to number from
1-128. It keeps numbering 1-3 ( the number of pages that it took to
document
each separate system).


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 create a Word mailmerge form using data provided in Excel adupre518 Mailmerge 4 January 6th 10 09:59 PM
create labels in word using data from excel (automatically) Spiros Mailmerge 1 June 4th 09 03:18 PM
create macro using data in excel ss to word Ann Microsoft Word Help 1 May 29th 08 09:55 PM
How do I create a report in Word from data in Excel, I need to au. Oileanach New Users 1 March 15th 05 03:19 PM
Create a form in excel and word that locks in the user's data so . Dianne Microsoft Word Help 0 February 15th 05 08:01 PM


All times are GMT +1. The time now is 09:31 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"