Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send mail with attachment
Hi,
I found a way with outlook to send emails with attachments. However, I'm not sure that my customer has outlook installed, so I looked for an independent code to sent a mail and I found a good solution here's my code Sub SendIt() vRecipient = " vSubject = "Fine" vBody = "The mail is send" vAttachment = "C:\Test.xls" vMail = "mailto:" & vRecipient _ & "?subject=" & vSubject _ & "&body=" & vBody _ & "&attachment=" & vAttachment ThisWorkbook.FollowHyperlink vMail End Sub Everything works fine and is mail-client indepent (it takes the default email program) but my attachment is not added to the mail. Who can tell me why? Thanks Jos Vens |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
send to mail recipient as attachment not sending | Excel Discussion (Misc queries) | |||
Excel Send to Mail Recipient (as Attachment) | Excel Discussion (Misc queries) | |||
send to mail recipient as attachment - no worky... | Excel Discussion (Misc queries) | |||
Send to Mail Recipient (as attachment) Lags | Excel Discussion (Misc queries) | |||
Cannot "Send to -> mail recipient (as attachment)" | Excel Discussion (Misc queries) |