Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to copy multiple Excel files from Outlook into Excel??? | Excel Discussion (Misc queries) | |||
Lost ability to open (activate) Excel files from Explorer, Outlook | Excel Discussion (Misc queries) | |||
how to make OUTLOOK EXPRESS mail recipient in excel | Excel Discussion (Misc queries) | |||
Excel attachments open in outlook 2002 as TMP files | Excel Discussion (Misc queries) | |||
Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) |