View Single Post
  #3   Report Post  
Peter Jamieson
 
Posts: n/a
Default

Are you saying that your mail merge main document (e.g. your form letter)
has multiple pages, but you are only seeing copies of the first page, or
that your Excel spreadsheet has multiple pages and that only the first page
of data is generating merge output? Assuming the latter (as it is the only
thing that makes sense to me right now) do you mean that you have multiple
worksheets in your Excel workbook and that only the first sheet is merged?
If so,
a. yes, Word can only use one worksheet at a time as its data source
(unless you code some Word VBA)
b. your best bet short term is to create a new spreadsheet and copy all the
data from all the sheets you want to merge, and use that as the data source.
(Or copy the data somewhere else, such as an Access database or Word table)

If that isn't the problem, can you spell out exactly what is happening?

Peter Jamieson

"Kathy" wrote in message
...
I have used "Create a wod mail merge with excel data" however I can only
get
1 page of the document to convert into the mailing. What am I doing wrong?