Have a look at John Walkenbach's "mail merge without Word"

http://www.j-walk.com/ss/excel/tips/tip92.htm

Might do what you want.


Gord Dibben MS Excel MVP

On Wed, 7 Nov 2007 19:47:40 -0000, "Adrian Harding"
wrote:

I want to know if something is possible. Presently have excel spreadsheet
table containing a number of referenced records (at present 700) as below

|Ref|Date|Name|etc.....


Want to know if there is a way to do a kind of merge to a standard letter of
the data but only on a case by case basis rather than merging the whole
datasource into word. My ideal solutions would be something where you
highlight the row and press a button and hey presto. Problem is dont know if
can be done or how to go about.

Another reason i dont want to mail merge is due to lack of computer skills
of others that will be using it and trying to navigate to the correct ref.


Thanks
Adrian Harding