| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to Send to Mail Recipient (as attachment) from Excel 2000 | Excel Discussion (Misc queries) | |||
| E-mail macro - how do I attach multiple attachments? | Excel Discussion (Misc queries) | |||
| E-mail Multiple Attachments | Excel Programming | |||
| send tomail recipient (as attachments) is grey'd out | Excel Discussion (Misc queries) | |||
| Multiple attachments in Excel e-mail? | Excel Programming | |||
![...Patrick[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
