Afgelopen zomer zijn we hier fantastisch geholpen door jullie om een Excel sheet op te slaan en door te mailen in Outlook.:thumb:
Nu is mijn vraag, kunnen we diezelfde sheet opslaan in Word en doormailen in Word?
De sub die we hiervoor gebruiken is de volgende:
Sub Spaarie()
If Sheets("Bon").Range("C1").Value = "" Then
MsgBox "Geef kenteken in.", vbInformation + vbOKOnly, "Oeps..."
Exit Sub
End If
Sheets("Bon").Copy
With ActiveWorkbook
p = ThisWorkbook.Path & "\" & Year(Date)
If Len(Dir(p, vbDirectory)) = 0 Then MkDir p
.SaveAs p & "\Bon " & .ActiveSheet.Range("C1").Value & ".xls"
With CreateObject("Outlook.Application").CreateItem(0)
.To = ActiveSheet.Range("G31").Value
.Subject = ActiveSheet.Range("G3").Value
.Body = ""
.Attachments.Add ActiveWorkbook.FullName
.Display
End With
.Close True
End With
End Sub
Alvast bedankt
Nico
Nu is mijn vraag, kunnen we diezelfde sheet opslaan in Word en doormailen in Word?
De sub die we hiervoor gebruiken is de volgende:
Sub Spaarie()
If Sheets("Bon").Range("C1").Value = "" Then
MsgBox "Geef kenteken in.", vbInformation + vbOKOnly, "Oeps..."
Exit Sub
End If
Sheets("Bon").Copy
With ActiveWorkbook
p = ThisWorkbook.Path & "\" & Year(Date)
If Len(Dir(p, vbDirectory)) = 0 Then MkDir p
.SaveAs p & "\Bon " & .ActiveSheet.Range("C1").Value & ".xls"
With CreateObject("Outlook.Application").CreateItem(0)
.To = ActiveSheet.Range("G31").Value
.Subject = ActiveSheet.Range("G3").Value
.Body = ""
.Attachments.Add ActiveWorkbook.FullName
.Display
End With
.Close True
End With
End Sub
Alvast bedankt
Nico