I would like to write code that would send a specific workbook to a specific person. However, there are 20 workbooks that go to 20 different people. How can I replace "activeworkbook" in the SendMail syntax with the specific name of a file (that isn't the open active workbook).

I sure appreciate any guidance you can give me.

-Beverly

You can't use SendMail Beverly for this
If you use Outlook then look at this example
http://www.rondebruin.nl/sendmail.htm#file


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Beverly" wrote in message ...
I would like to write code that would send a specific workbook to a specific person. However, there are 20 workbooks that go
to 20 different people. How can I replace "activeworkbook" in the SendMail syntax with the specific name of a file (that isn't
the open active workbook).

I sure appreciate any guidance you can give me.

-Beverly

Ron-

Unfortunately, I am using Lotus Notes. Any help with this?

Any help with this?
Not using it<g

Sorry I never use it and a lot of people tell me(don't do it)
I hope someone else can help you


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Beverly" wrote in message ...
Ron-

Unfortunately, I am using Lotus Notes. Any help with this?

Ron

Is there another way to do this without using SendMail? As I previously said, I am using Lotus Notes

Thanks for your help with this.

You can use CDO if you use Win 2000 or Win XP
http://www.rondebruin.nl/cdo.htm

If you need help post back

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Beverly" wrote in message ...
Ron-

Is there another way to do this without using SendMail? As I previously said, I am using Lotus Notes.

Thanks for your help with this.

Thanks Ron! I'll give it a try

Hi Ron-

I seem to hit a snag when I get to the .Send command. The error message I get is "The SendUsing configuration value is invalid." I am using Windows 2000. Any thoughts?

-Beverly

See the Problem section on the webpage
You must fill in the SMTP server

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Beverly" wrote in message ...
Hi Ron-

I seem to hit a snag when I get to the .Send command. The error message I get is "The SendUsing configuration value is
invalid." I am using Windows 2000. Any thoughts?

-Beverly