N
nick thompson
ni 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
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