|
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 |
send mail from excel 2000 with multiple attachments
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 |
send mail from excel 2000 with multiple attachments
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 |
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 |
send mail from excel 2000 with multiple attachments
Sorry: it is not possible to have attachments in O E with vba ? Correct ?
Thank you "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 |
send mail from excel 2000 with multiple attachments
Yes, you need Outlook or use CDO
http://www.rondebruin.nl/cdo.htm -- Regards Ron de Bruin http://www.rondebruin.nl "...Patrick" wrote in message ... Sorry: it is not possible to have attachments in O E with vba ? Correct ? Thank you "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 |
send mail from excel 2000 with multiple attachments
Check out if Outlook or Outlook Express is your mail program for Office
StartSettingsControl Panel....Internet options (Program Tab) Close Excel first before you make a change. -- Regards Ron de Bruin http://www.rondebruin.nl "...Patrick" wrote in message ... 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 |
| All times are GMT +1. The time now is 04:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com