excel/word mail merge question

[vexingv]

i;m selling sweatshirts for a fundraiser and ive got an xls with each row being an order (each row has name, color, size ,quantity, email). however we have multiple colors and sizes so each different size/color has its own line so one person may have several lines in the spreadsheet. i was trying to mail merge so that i can send a confirmation to these individuals, but i dont want to send one email per line from the xls, but would instead want to send one email per email address with the details of their entire purchase.

can anyone give me any suggestions/ideas or link a site which would be a good excel/word primer?

thanks

 

[z0mb13]

I assume u are doing the mail merge from word, right?

just do mail merge as usual, then when you are selecting the data, you can find the specific line of data that u want, then just select that one.

another way is to do the mail merge, and go until the end, then you can view samples of the mail merge result, just keep clicking until u find the correct one. then hit print, it will only print 1.

another (kind of dumb) way is to make a new excel file containing only 1 line of data that u want. then link the word file to this new excel file. then do mail merge as usual

 

[minendo]

I once heard that they had a Software related forum at AnandTech.