View Single Post
  #6   Report Post  
Chris
 
Posts: n/a
Default

It sounds like mail merge may not be your best option. If you add the
Database toolbar to your workspace and insert a database you can get a
lot of rows of data from all the same sources the mail merge uses. You
can select the option to make the data dynamic so that it refreshes when
its source refreshes.

Does that help?

Chris Weber

Mark wrote:
In Office 97 I could create a standard letter and then merge it with multiple
records to a separate document, thus maintaining the integrity of the
standard letter.

In Office 2003
(a)it refuses to merge with multiple records. The only way I can do this is
to copy the letter and paste to new pages with the 2nd and subsequent copies
prefixed by "next record". I have to do this for as many times as there are
records in the data source which is just about bearable for 10-20 records but
unacceptable for 100.

(b) not only that but it then does not offer the option of merging to a
separate document so I end up corrupting my original standard letter.

Please can you help me at all?

Many thanks for your time.

Mark