Hello all,

I am needing some major help. I run this report once a week and it takes me
hours. There must be a easier way. The report is a overdue po report. It
has the following columns.

PO Number
Line Number
Part Number
Part Description
QTY
Due Date
Vendor Number
Vendor ID
Vendor Contact email address

There will be multiple lines with the same email address. I need a macro
that can create a email for each group of email addresses and send them the
rows that unique to the email address along with the header row. Is this
possible?

Thanks in advance for any help you can provide!
Aaron

Sure, there is always an easier way. Take a look at this:
http://www.rondebruin.nl/mail/folder3/message.htm

Also, try this:
http://www.rondebruin.nl/mail/folder2/files.htm

FYI, you should test the results by sending emails to yourself, and when you
get it working pop in the actual email addresses that you will use.

HTH,
Ryan---



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Aaron" wrote:

Hello all,

I am needing some major help. I run this report once a week and it takes me
hours. There must be a easier way. The report is a overdue po report. It
has the following columns.

PO Number
Line Number
Part Number
Part Description
QTY
Due Date
Vendor Number
Vendor ID
Vendor Contact email address

There will be multiple lines with the same email address. I need a macro
that can create a email for each group of email addresses and send them the
rows that unique to the email address along with the header row. Is this
possible?

Thanks in advance for any help you can provide!
Aaron

Body or attachment ?

See this filter macro
http://www.rondebruin.nl/mail/folder2/row2.htm

Or this one for the body
http://www.rondebruin.nl/mail/folder3/row2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Aaron" wrote in message ...
Hello all,

I am needing some major help. I run this report once a week and it takes me
hours. There must be a easier way. The report is a overdue po report. It
has the following columns.

PO Number
Line Number
Part Number
Part Description
QTY
Due Date
Vendor Number
Vendor ID
Vendor Contact email address

There will be multiple lines with the same email address. I need a macro
that can create a email for each group of email addresses and send them the
rows that unique to the email address along with the header row. Is this
possible?

Thanks in advance for any help you can provide!
Aaron