Split, sort and mail

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

splat - 26 Apr 2007 07:15 GMT

I have a list A1 - J1500. Column J is dealer name. B is inventory
item, C is description, D is quantity). I need to copy all dealer A
entries (in sheet 1 only column B,C and D) to sheet 2. Dealer B to
sheet 3 etc.
I need to keep Sheet 1 intact at all times.

I will then need to email sheet 2 to dealer A, sheet 3 to dealer B
once a week. (if possible)

Could I ask for as much detail as possible please.

Any help will be really appreciated.

I am using 2007.

Reply to this Message

Mike Fogleman - 26 Apr 2007 11:49 GMT

Here is about as much detail on sending mail from Excel as you need:
http://www.rondebruin.nl/sendmail.htm
Sending it on a set schedule would be best managed by you, not Excel.

To get a unique list of dealers use Advanced Filter on column J and copy
unique list to perhaps column M. This is your Sendto list. Use a loop within
a loop to match each name in column M to each name in column J. When a match
is found, copy the Offset values from J to the next row of the appropriate
sheet.

Mike F

>I have a list A1 - J1500. Column J is dealer name. B is inventory
> item, C is description, D is quantity). I need to copy all dealer A
[quoted text clipped - 10 lines]
>
> I am using 2007.

Reply to this Message