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 = "adresse@url.com"
.Item.Send
End With
// Try 2
Dim HLink As String
HLink = "mailto:" & Recipient & "adresse@url.com"
ActiveWorkbook.FollowHyperlink (HLink)
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Clément Marcotte
Oh ! un "crosspost" unilingue de paresseux.
Oh a lousy crosspost unilingual. (Je know, faut tell uninlingual crosspost, mais je am trop lousy pour correct ça)
"flo" a écrit dans le message de news:
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.
Oh ! un "crosspost" unilingue de paresseux.
Oh a lousy crosspost unilingual. (Je know, faut tell uninlingual
crosspost, mais je am trop lousy pour correct ça)
"flo" <fdoche@hotmail.com> a écrit dans le message de
news:c1dda0e6.0312110618.41cf8f54@posting.google.com...
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 = "adresse@url.com"
.Item.Send
End With
// Try 2
Dim HLink As String
HLink = "mailto:" & Recipient & "adresse@url.com"
ActiveWorkbook.FollowHyperlink (HLink)
Oh a lousy crosspost unilingual. (Je know, faut tell uninlingual crosspost, mais je am trop lousy pour correct ça)
"flo" a écrit dans le message de news:
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)
