Late Binding

Is there any need to leave the code in place when you email it? Could you not just remove the code and the reference before sending it on?

Out of curiorisity how could I send it if I were to remove the reference?

Well, you could remove the need for the reference from the get go...

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> SendMailViaOutlook()
    <SPAN style="color:#00007F">Dim</SPAN> appOutlook <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Object</SPAN>
    <SPAN style="color:#00007F">Dim</SPAN> MailItem <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Object</SPAN>
    
    <SPAN style="color:#00007F">Set</SPAN> appOutlook = GetObject(, "Outlook.Application")
    <SPAN style="color:#00007F">Set</SPAN> MailItem = appOutlook.CreateItem(0)
    
    <SPAN style="color:#00007F">With</SPAN> MailItem
        .<SPAN style="color:#00007F">To</SPAN> = "joesmith@domain.com"
        .Send
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN>
    
    <SPAN style="color:#00007F">Set</SPAN> MailItem = <SPAN style="color:#00007F">Nothing</SPAN>
    <SPAN style="color:#00007F">Set</SPAN> appOutlook = <SPAN style="color:#00007F">Nothing</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

This fairly simple example needs no references to be set.

Hi,

To remove code / modules see:
http://www.cpearson.com/excel/vbe.htm

Kind regards,
Dennis

Thanks Denis, I am showing myself up again - thanks Tommy.

what do the major & minor settings do for the GUID - without them you can't add the reference... intrigued.

Hi,

See for instance the following thread here at MrExcel and especially Ivan's good contribution:

http://www.mrexcel.com/board2/viewtopic.php?t=8251

Kind regards,
Dennis