 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2006send 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  SignatureRegards Ron de Bruin http://www.rondebruin.nl > Hello, > [quoted text clipped - 13 lines] > > Patrick Thanks Ron ! > Hi Patrick > [quoted text clipped - 20 lines] >> >> 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 > Thanks Ron ! > [quoted text clipped - 22 lines] >>> >>> 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. SignatureRegards Ron de Bruin http://www.rondebruin.nl > Ok, Ron > I try with your code * but it is opening Outlook in défaut, not OE ??? [quoted text clipped - 29 lines] >>>> >>>> Patrick Sorry: it is not possible to have attachments in O E with vba ? Correct ? Thank you > Hi Patrick > [quoted text clipped - 20 lines] >> >> Patrick Yes, you need Outlook or use CDO http://www.rondebruin.nl/cdo.htm SignatureRegards Ron de Bruin http://www.rondebruin.nl > Sorry: it is not possible to have attachments in O E with vba ? Correct ? > [quoted text clipped - 23 lines] >>> >>> Patrick |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.