send mail from excel 2000 with multiple attachments

Hello,

i try to send a mail from excel but my problem is the attachements:

..Attachments.Add "C:\THOMAS_PIRON\Scan_Charleroi.pdf"
..Attachments.Add "C:\THOMAS_PIRON\texte_Charleroi.pdf"
etc...

I tried :

.Attachments.Add "C:\THOMAS_PIRON\*.pdf" but it doesn' t work !!

(i would like to send with Outlook Express and if not possible , with
Outlook)

Thank you

Patrick

Hi Patrick

You must repeat the lines and you can't do it with Outlook Express
See my site for Outlook examples
http://www.rondebruin.nl/sendmail.htm


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


"...Patrick" <[email protected]> wrote in message news:[email protected]...
> Hello,
>
> i try to send a mail from excel but my problem is the attachements:
>
> .Attachments.Add "C:\THOMAS_PIRON\Scan_Charleroi.pdf"
> .Attachments.Add "C:\THOMAS_PIRON\texte_Charleroi.pdf"
> etc...
>
> I tried :
>
> .Attachments.Add "C:\THOMAS_PIRON\*.pdf" but it doesn' t work !!
>
> (i would like to send with Outlook Express and if not possible , with Outlook)
>
> Thank you
>
> Patrick

Thanks Ron !


"Ron de Bruin" <[email protected]> a écrit dans le message de news:
[email protected]...
> Hi Patrick
>
> You must repeat the lines and you can't do it with Outlook Express
> See my site for Outlook examples
> http://www.rondebruin.nl/sendmail.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "...Patrick" <[email protected]> wrote in message
> news:[email protected]...
>> Hello,
>>
>> i try to send a mail from excel but my problem is the attachements:
>>
>> .Attachments.Add "C:\THOMAS_PIRON\Scan_Charleroi.pdf"
>> .Attachments.Add "C:\THOMAS_PIRON\texte_Charleroi.pdf"
>> etc...
>>
>> I tried :
>>
>> .Attachments.Add "C:\THOMAS_PIRON\*.pdf" but it doesn' t work !!
>>
>> (i would like to send with Outlook Express and if not possible , with
>> Outlook)
>>
>> Thank you
>>
>> Patrick
>
>

Ok, Ron
I try with your code * but it is opening Outlook in défaut, not OE ???
Why please ?

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

Thank you

"...Patrick" <[email protected]> a écrit dans le message de news:
[email protected]...
> Thanks Ron !
>
>
> "Ron de Bruin" <[email protected]> a écrit dans le message de news:
> [email protected]...
>> Hi Patrick
>>
>> You must repeat the lines and you can't do it with Outlook Express
>> See my site for Outlook examples
>> http://www.rondebruin.nl/sendmail.htm
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "...Patrick" <[email protected]> wrote in message
>> news:[email protected]...
>>> Hello,
>>>
>>> i try to send a mail from excel but my problem is the attachements:
>>>
>>> .Attachments.Add "C:\THOMAS_PIRON\Scan_Charleroi.pdf"
>>> .Attachments.Add "C:\THOMAS_PIRON\texte_Charleroi.pdf"
>>> etc...
>>>
>>> I tried :
>>>
>>> .Attachments.Add "C:\THOMAS_PIRON\*.pdf" but it doesn' t work !!
>>>
>>> (i would like to send with Outlook Express and if not possible , with
>>> Outlook)
>>>
>>> Thank you
>>>
>>> Patrick
>>
>>
>

Sorry: it is not possible to have attachments in O E with vba ? Correct ?

Thank you


"Ron de Bruin" <[email protected]> a écrit dans le message de news:
[email protected]...
> Hi Patrick
>
> You must repeat the lines and you can't do it with Outlook Express
> See my site for Outlook examples
> http://www.rondebruin.nl/sendmail.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "...Patrick" <[email protected]> wrote in message
> news:[email protected]...
>> Hello,
>>
>> i try to send a mail from excel but my problem is the attachements:
>>
>> .Attachments.Add "C:\THOMAS_PIRON\Scan_Charleroi.pdf"
>> .Attachments.Add "C:\THOMAS_PIRON\texte_Charleroi.pdf"
>> etc...
>>
>> I tried :
>>
>> .Attachments.Add "C:\THOMAS_PIRON\*.pdf" but it doesn' t work !!
>>
>> (i would like to send with Outlook Express and if not possible , with
>> Outlook)
>>
>> Thank you
>>
>> Patrick
>
>

Yes, you need Outlook or use CDO
http://www.rondebruin.nl/cdo.htm

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


"...Patrick" <[email protected]> wrote in message news:[email protected]...
> Sorry: it is not possible to have attachments in O E with vba ? Correct ?
>
> Thank you
>
>
> "Ron de Bruin" <[email protected]> a écrit dans le message de news: [email protected]...
>> Hi Patrick
>>
>> You must repeat the lines and you can't do it with Outlook Express
>> See my site for Outlook examples
>> http://www.rondebruin.nl/sendmail.htm
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "...Patrick" <[email protected]> wrote in message news:[email protected]...
>>> Hello,
>>>
>>> i try to send a mail from excel but my problem is the attachements:
>>>
>>> .Attachments.Add "C:\THOMAS_PIRON\Scan_Charleroi.pdf"
>>> .Attachments.Add "C:\THOMAS_PIRON\texte_Charleroi.pdf"
>>> etc...
>>>
>>> I tried :
>>>
>>> .Attachments.Add "C:\THOMAS_PIRON\*.pdf" but it doesn' t work !!
>>>
>>> (i would like to send with Outlook Express and if not possible , with Outlook)
>>>
>>> Thank you
>>>
>>> Patrick
>>
>>
>

Check out if Outlook or Outlook Express is your mail program for Office
Start>Settings>Control Panel....Internet options (Program Tab)
Close Excel first before you make a change.



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


"...Patrick" <[email protected]> wrote in message news:[email protected]...
> Ok, Ron
> I try with your code * but it is opening Outlook in défaut, not OE ???
> Why please ?
>
> * http://www.rondebruin.nl/mail/oebody.htm
>
> Thank you
>
> "...Patrick" <[email protected]> a écrit dans le message de news: [email protected]...
>> Thanks Ron !
>>
>>
>> "Ron de Bruin" <[email protected]> a écrit dans le message de news: [email protected]...
>>> Hi Patrick
>>>
>>> You must repeat the lines and you can't do it with Outlook Express
>>> See my site for Outlook examples
>>> http://www.rondebruin.nl/sendmail.htm
>>>
>>>
>>> --
>>> Regards Ron de Bruin
>>> http://www.rondebruin.nl
>>>
>>>
>>> "...Patrick" <[email protected]> wrote in message news:[email protected]...
>>>> Hello,
>>>>
>>>> i try to send a mail from excel but my problem is the attachements:
>>>>
>>>> .Attachments.Add "C:\THOMAS_PIRON\Scan_Charleroi.pdf"
>>>> .Attachments.Add "C:\THOMAS_PIRON\texte_Charleroi.pdf"
>>>> etc...
>>>>
>>>> I tried :
>>>>
>>>> .Attachments.Add "C:\THOMAS_PIRON\*.pdf" but it doesn' t work !!
>>>>
>>>> (i would like to send with Outlook Express and if not possible , with Outlook)
>>>>
>>>> Thank you
>>>>
>>>> Patrick
>>>
>>>
>>
>