LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default send mail from excel 2000 and Outlook Express

Hello,

with the help de Ron code, i try tou send 1 ou more file ".pdf" to one or
more people but i have a problem if i try to send 2 files in the same mail:

my 2 files a tutu.pdf and toto.pdf and more ...

Before the change of my For/next, i send in 2 or more separate mails for the
same poeple, but it is better to make ONE send with the 2 or more files..

Thank you

this is a part of my code:
....
....
For I = 5 To Lastfile 'from line 5 to last line
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
ActiveSheet.Shapes("TexteClient").Select
Txt = Selection.Characters.Text
ActiveSheet.Shapes("averti256").Select
'Txt2 = Selection.Characters.Text
strbody = Txt & Chr(13) & [I8].Value ' I8 = adresse net de t&p
Debut = "C:\THOMAS_PIRON\" ' répertoire des PDF
Scan = Scan & Cells(I, 6).Value & ".pdf" ' how is is possible to send 2
files
On Error GoTo 0
Next ' i = 5 to lastfile


With iMsg
Set .Configuration = iConf
.To = Destinataire
.cc = ""
.BCC = Invisible ' pour une trace de l'envoi
.From = Range("I9").Value ' """Patrick"" "
.Subject = ObjetMail
.TextBody = strbody
.addAttachment Debut & Scan HERE IS THE PROBLEM
.Send
Scan = "scan_": Texte = "texte_": Tarif = "tarif_"
End With

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fw: send two or more files with Excel and Outlook Express Infosistem Excel Discussion (Misc queries) 1 August 17th 06 05:27 PM
How can I use Outlook express to send mail rather than Outlook by VBA code new.microsoft.com Excel Programming 5 August 3rd 05 03:45 PM
How can I use Outlook express to send mail rather than Outlook by VBA code new.microsoft.com Excel Programming 1 August 1st 05 12:45 PM
Cannot send out Excel workbook through Outlook Express Abel Chan Excel Programming 5 March 7th 05 03:34 AM
Send to Outlook 2000 not Outlook Express Jimbo Excel Discussion (Misc queries) 2 January 4th 05 08:19 PM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"