Sending an Excel Spreadsheet to Eudora

[Linda McMillen]

I'm at a loss on how send an Excel Spreadsheet to Eudora. I am using
Eudora version 5.1 and Excel for Windows version 2002 SP3. I can do
Application.Dialogs(xlDialogSendMail).Show but I want the TO field,
SUBJECT field and Body with precanned data. (ie TO: "(e-mail address removed)",
"Spreadsheet Info", "Information you requested").

I will need to then run this on a Mac using Eudora version 6.1, and
Excel X for Mac SR1

Any help would be appreciated

 

[keepITcool]

See
http://www.rondebruin.nl/mail/oebody.htm

try the method that uses an url with mailto:

probably untested on the Mac/Eudora but it should work
if Eudora is set to be the default handler for mailto urls...

Sub Mailing()
ActiveWorkbook.FollowHyperlink _
"mailto:[email protected]" & _
"?subject=I have a dream.." & _
"&body=That one day soon..%0D%0ABush is gone!"

End Sub



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Linda McMillen]

That works great but I forgot to add that I wanted to have the e-mail
sent in Eudora. I set a reference for Eudora in VBA and that's about
all I've got so far. I've tried different items from your website
(great site) but have not been successful in sending the e-mail.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!