Fw: send two or more files with Excel and Outlook Express
 

Hello,
I must send some files ( es. file1 - file2.eur - file3.doc ) with Excel and
Outlook Express .

My macro use :
-------------------------------------------------------------

wcHlink = "mailto:" & wcMailAddr & wcMailObjetc & wcmailMess

ActiveWorkbook.FollowHyperlink (wcHlink)

-----------------------------------------------------------
for to execute the program of mail ; and after :
------------------------------------------------------------
Application.SendKeys Keys:="%I", Wait:=True
Application.SendKeys Keys:="A", Wait:=True
Application.SendKeys Keys:=wcNameFile, Wait:=True
Application.SendKeys Keys:="{RETURN}", Wait:=True

----------------------------------------------------------
to put in the buffer's keyboard, the right keys


have you a good idea ?


Thanks

send two or more files with Excel and Outlook Express
 

Hi

Not possible with OE
See if you can use CDO
http://www.rondebruin.nl/cdo.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Infosistem" wrote in message ...
Hello,
I must send some files ( es. file1 - file2.eur - file3.doc ) with Excel and Outlook Express .

My macro use :
-------------------------------------------------------------

wcHlink = "mailto:" & wcMailAddr & wcMailObjetc & wcmailMess

ActiveWorkbook.FollowHyperlink (wcHlink)

-----------------------------------------------------------
for to execute the program of mail ; and after :
------------------------------------------------------------
Application.SendKeys Keys:="%I", Wait:=True
Application.SendKeys Keys:="A", Wait:=True
Application.SendKeys Keys:=wcNameFile, Wait:=True
Application.SendKeys Keys:="{RETURN}", Wait:=True

----------------------------------------------------------
to put in the buffer's keyboard, the right keys


have you a good idea ?


Thanks