Software

You just need to fill in the blanks for subject, recipient, and attachments.

Sub CallCreateMail()
' This procedure shows how to pass an array of recipients,
' a subject line, a message body, and an array of attachments
' to the CreateMail procedure.
Dim strSubject As String
Dim strBody As String
Dim avarRecip(2) As Variant
Dim avarAttach(2) As Variant

' Create recipients array.
avarRecip(0) =
avarRecip(1) =
avarRecip(2) =

' Create attachments array.
avarAttach(0) =
avarAttach(1) =
avarAttach(2) =

' Create Subject line and message body.
strSubject =
strBody = "

If CreateMail(avarRecip, strSubject, strBody, avarAttach) = True Then
MsgBox "Congratulations! Your mail has been sent."
End If
End Sub

You just need to fill in the blanks for subject, recipient, and attachments.

Sub CallCreateMail()
' This procedure shows how to pass an array of recipients,
' a subject line, a message body, and an array of attachments
' to the CreateMail procedure.
Dim strSubject As String
Dim strBody As String
Dim avarRecip(2) As Variant
Dim avarAttach(2) As Variant

' Create recipients array.
avarRecip(0) =
avarRecip(1) =
avarRecip(2) =

' Create attachments array.
avarAttach(0) =
avarAttach(1) =
avarAttach(2) =

' Create Subject line and message body.
strSubject =
strBody = "

If CreateMail(avarRecip, strSubject, strBody, avarAttach) = True Then
MsgBox "Congratulations! Your mail has been sent."
End If
End Sub

Your answer made sense. However, what if the document I'm placing this macro in is the actual attachment? How do I set up my attachment array to grab that actual document. My apologies - I know very little Visual Basic!