View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aaron Aaron is offline
external usenet poster
 
Posts: 287
Default Emailing rows to each different address listed.

Hello all,

I and needing some major help. I have a file that I download to excel which
has these columns in it

PO Number
PO Line
Part Number
Description
Vendor Part Number
QTY
Due Date
Company
Company email address.

What I am needing to do is, send a email to each address with all the rows
that corresponds with that email address. There could be 1 to 100 rows per
email address. The email address does repeat on each line. I also need the
header row along with the rows that apply to each email address.

This takes me hours to do each week and would be a world of help if I could
get a macro to do this. Thanks in advance for any help you may give.

Regards,
Aaron