Email again

Ron de Bruin · Feb 13, 2004

Hi Beel

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

Beeel · Feb 13, 2004

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 · Feb 14, 2004

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 · Feb 14, 2004

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 · Feb 15, 2004

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 · Feb 15, 2004

Hi Beel

Is this macro working for you?

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