Email workbook question
 

I had successfully set up a program that emails a page of a workbook. I
stopped working on it and decided to polish it a bit.


In the code directly before the email subroutine starts, i have a note
that says "Remember to reference the Microsoft outlook library". Funny
thing is, i cant remember where this is, or why I did it (or even if I
have to). Since I am getting a new computer soon I need to know where
this is and why I did it in the first place.

Any help would be appreciated.


--
pete3589
------------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402
View this thread: http://www.excelforum.com/showthread...hreadid=495167

Email workbook question
 

Hi Pete

See one of the Outlook object model examples on my site
http://www.rondebruin.nl/sendmail.htm
You can find it there

Below the macro there is also a example for Late binding
Check this out

--
Regards Ron de Bruin
http://www.rondebruin.nl


"pete3589" wrote in message
...

I had successfully set up a program that emails a page of a workbook. I
stopped working on it and decided to polish it a bit.


In the code directly before the email subroutine starts, i have a note
that says "Remember to reference the Microsoft outlook library". Funny
thing is, i cant remember where this is, or why I did it (or even if I
have to). Since I am getting a new computer soon I need to know where
this is and why I did it in the first place.

Any help would be appreciated.


--
pete3589
------------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402
View this thread: http://www.excelforum.com/showthread...hreadid=495167

Email workbook question
 

Ah that was it.


So Im guessing it is safe to say that this is inherent to th
spreadsheet, therefore If i save it to a disk and start it on the ne
computer this box will already be checked

--
pete358
-----------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...fo&userid=2840
View this thread: http://www.excelforum.com/showthread.php?threadid=49516

Email workbook question
 

hi Pete

If you set the reference in Excel 2002 for example and send it to someone with Excel 2000
it is not working. But from 2000 to 2002 it is working.

Use Late binding to avoid this problem


--
Regards Ron de Bruin
http://www.rondebruin.nl


"pete3589" wrote in message
...

Ah that was it.


So Im guessing it is safe to say that this is inherent to the
spreadsheet, therefore If i save it to a disk and start it on the new
computer this box will already be checked?


--
pete3589
------------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402
View this thread: http://www.excelforum.com/showthread...hreadid=495167

Email workbook question
 

Right, Im pretty sure I will be the only one using this and I know
wont be changing versions, however I may throw the late binding int
there to be efficient in case the version changes later on.

Thanks for everything Ron :

--
pete358
-----------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...fo&userid=2840
View this thread: http://www.excelforum.com/showthread.php?threadid=49516