+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Infosistem
    Guest

    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




  2. #2
    Ron de Bruin
    Guest

    Re: 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" <infosistem@netribe.it> wrote in message news:OpgsgMgwGHA.456@TK2MSFTNGP05.phx.gbl...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1