View Single Post
  #1   Report Post  
Posted to microsoft.public.fr.excel,microsoft.public.excel.programming
flo[_2_] flo[_2_] is offline
external usenet poster
 
Posts: 1
Default VBA send mail with groupwise

Hi.

I'd like to send an email with VBA from Excel 2002, using Groupwise 6.5.

I've tried these several code samples but nothing worked..

// Try 1
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "This is a sample worksheet."
.Item.To = "
.Item.Send
End With

// Try 2
Dim HLink As String
HLink = "mailto:" & Recipient & "
ActiveWorkbook.FollowHyperlink (HLink)

Any idea to solve this problem ?

Thanxs.