Hi Experts, need your help!!!

I have a workbook, with information of individual reps on each worksheet. i
need these worksheets to be emailed to respective reps.

we can use any of the following
1. email address stored in the cell A1 of each worksheet.
2. email addresses stored in one worksheet in the same workbook. OR
3. email addresses stored in seperate workbook, with both workshhets saved
in the same folder where name and email address of the reps are stored in
seperate workbook in the sequence of the worksheets.

please please help!!!
if my question is not clear please let me know and i will give further
explanation.

but i need this to be accomplished ASAP.

Please HELP.

I have examples here for you
http://www.rondebruin.nl/sendmail.htm

Mail every worksheet with address in A1

Try
http://www.rondebruin.nl/mail/folder1/mail5.htm

Or for Outlook
http://www.rondebruin.nl/mail/folder2/mail5.htm

Body example
http://www.rondebruin.nl/mail/folder3/mail5.htm


--

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


"Mir Khan" wrote in message ...
Hi Experts, need your help!!!

I have a workbook, with information of individual reps on each worksheet. i
need these worksheets to be emailed to respective reps.

we can use any of the following
1. email address stored in the cell A1 of each worksheet.
2. email addresses stored in one worksheet in the same workbook. OR
3. email addresses stored in seperate workbook, with both workshhets saved
in the same folder where name and email address of the reps are stored in
seperate workbook in the sequence of the worksheets.

please please help!!!
if my question is not clear please let me know and i will give further
explanation.

but i need this to be accomplished ASAP.

Please HELP.

Mr. Ron de Bruin has written extensively on emailing and Excel. Perhaps
check out his site:

http://www.rondebruin.nl/sendmail.htm

Although this page is not about emailing, it shows how to get the unique
items from a list and process them using an autofilter. It may be related to
what you want to do.

http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy


"Mir Khan" wrote:

Hi Experts, need your help!!!

I have a workbook, with information of individual reps on each worksheet. i
need these worksheets to be emailed to respective reps.

we can use any of the following
1. email address stored in the cell A1 of each worksheet.
2. email addresses stored in one worksheet in the same workbook. OR
3. email addresses stored in seperate workbook, with both workshhets saved
in the same folder where name and email address of the reps are stored in
seperate workbook in the sequence of the worksheets.

please please help!!!
if my question is not clear please let me know and i will give further
explanation.

but i need this to be accomplished ASAP.

Please HELP.