View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
...Patrick[_7_] ...Patrick[_7_] is offline
external usenet poster
 
Posts: 14
Default send mail from excel 2000 with multiple attachments

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" a écrit dans le message de news:
...
Thanks Ron !


"Ron de Bruin" a écrit dans le message de news:
...
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" wrote in message
...
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