Email again

[Ron de Bruin]

Hi Beel

Close Excel and reopen and post back what happens
Did you download version 2.1?

 

[Beeel]

I have downloaded Ron de Bruin's Add-in for sending emails from Excel.
Everything seems OK until I press "GO" - nothing happens
no connections to OE
Can someone help
Also after loading the Sendmail Add-in I cant find the Google search 5.1
Add-in which is ticked on the list of Add-ins

Barry

 

[Beeel]

Yes I have version 2.1
After pressing "Go" I get the "Save as" menu I enter a filename and then I
am left back in Excel where I started

Barry

 

[Ron de Bruin]

Check out this Beeel

See if Outlook/OE is your mail program for Office
On the Control Panel>Internet options (Program Tab)

And this one

XL2002: "Send To Routing Recipient" Command Does Nothing
http://support.microsoft.com/default.aspx?scid=kb;en-us;296396

 

[Beeel]

Hi Ron
Yes OE is mail program
I'm running Excel 97
is this the problem?
Have you any idea why Google search doesn't appear on Tools menu. It is
ticked in the Add-ins sub menu?
Barry

 

[Ron de Bruin]

Hi Beel

Is this macro working for you?

Sub Mail_workbook()
ActiveWorkbook.SendMail "(e-mail address removed)", _
"This is the Subject line"
End Sub