Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
here is my sub ,
why .FoundFiles(i) are not objects, ------------------------ Sub Macro06() Set fs = Application.FileSearch With fs .LookIn = "D:\temp\1Box-H22m-L4165m" .Filename = "*.lzh" If .Execute(SortBy:=msoSortByFileName, _ SortOrder:=msoSortOrderAscending) 0 Then For i = 1 To .FoundFiles.Count MsgBox .FoundFiles(i) .FoundFiles(i).sendmail Recipients:="jyou" Next i Else MsgBox "there is no files found" End If End With Path End Sub ---------------------------- thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
Is their any way to set Excel to send an e-mail on date | Excel Discussion (Misc queries) | |||
Send mail from Excel | Excel Programming | |||
Not using send button on excel e-mail | Excel Programming | |||
how to send e-mail from excel | Excel Programming |