[ ramzesIV @ 16.11.2010. 14:48 ] @
imam makro koji salje excel kao attach na odredjeni mail.

sad treba da saljem ne samo na jedan nego na vise. kako da napisem vise adresa, ja kako god da pokusam, ne funkcionise.

Code:
Sub Send1Sheet_ActiveWorkbook()
'Create a new Workbook Containing 1 Sheet (left most) _
 and sends as attachment.
 
    'ThisWorkbook.Sheets(1).Copy
    
    Range("A4:F58").Select
    Selection.Copy
    Workbooks.Add Template:="Arbeitsmappe"
    Range("A2").Select
    ActiveSheet.Paste
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
    Cells.Select
    Cells.EntireColumn.AutoFit
    Cells.EntireRow.AutoFit
    Range("B10").Select
    
    Range("A1:F1").Select
    With Selection.Interior
        .Pattern = xlLightDown
        .PatternColorIndex = xlAutomatic
        .Color = 255
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    
    
    
    Range("D1:D58").Select
    Selection.ClearContents
    Range("C1").Select

    
    With ActiveWorkbook
         .SendMail Recipients:="[email protected]", _
          Subject:="Guten Morgen" & " - " & Format(Date, "dd/mmm/yy")
         .Close SaveChanges:=False
    End With
    
    Windows("Euribor_neu.xlsm").Activate
    ActiveWorkbook.Close True
    
End Sub

[ Jpeca @ 16.11.2010. 15:27 ] @
Kao parametar Recipients u metodi SendMail stavi
Code:
Recipients:=  Array("[email protected]", "[email protected]", "[email protected]") , _ 
[ ramzesIV @ 16.11.2010. 15:59 ] @
hvala!!

array mi je nedostajao!!!