[nick thompson]

i have a spreadsheet with colums of info.The firstcolumn has always someones
name and a row may repeat someones name.What i want to do is send by email
this information to the correct person.I was hoping to do a merge in word and
then send the document.However, it is proving impossible to use merge and get
the info for each person on one page.
Example

Excel sheet
Joe bloggs, column 2, column 3 ,column4
Sarah Green,colum 2,colum 3,colum,4
Joe Bloggs, colum2 ,column 3 ,column 4

i want to be able to email to each person

Word document 1 sent to joe bloggs

Joe Bloggs,column,2,column3,column4
Joe Bloggs,colum2, column3,column4

total column2,total column3,total column 4


second document

Sarah Green,column2,column3,colum4
total column2,total colum3,total colum3
--

--
nick