View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Send mail with attachment

Jos,

afaik Microsost has disabled the functionality
of the attachment part of url handling for security reasons.

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Jos Vens" wrote:


Jos Vens wrote
Hi,

I found a way with outlook to send emails with attachments.
However,



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