How can I make Excel ready to send emails within the workbook?

[rkjudy]

I have a workbook that will email a particular sheet. I am a novice so I just looked for examples to make this work. The problem I'm having is setting the reference to activate the correct Microsoft Outlook Object Library at WorkBook Open. I have users running 2010 and 2013. The code for actually sending the sheet is okay i think, but the MS Outlook Object Library reference shows missing so they can't use the function. I, personally, am running 2013, and MS Outlook Object Library 15.0 is checked in my references. I'm really not sure why it works on my machine and not others. I use a WorkBook Open module to load the reference. I've been told I should use Late Binding, but I simply don't know how to do that. I just hope I'm explaining my problem properly. The WorkBook Open code is below. Any suggestions?

Please Login or Register  to view this content.

[dominicb]

Good evening rkjudy

I personally am not a big fan of using Excel to send out e-mails, but I seem to remember doing so in the dim and distant past and running into similar problems.
The crux of the matter is an issue of early vs late binding, and there are different methods of sending mail from within Excel, and some require a reference be checked (which can cause compatability issues - as you are finding) and some don't.

I would suggest checking Ron de Bruin's site which lists many different ways of e-mailing from within Excel and discusses the early vs late argument with suggestions on how to get around it.

HTH

DominicB