J
Jacob
When I have multiple recipients I cannot get SendMail to
work. I have a feeling this might be an issue with
exchange server, but that's just a guess. Here is the
code, I'm getting run time error 1004 when the first
condition of the IF statement is executed, the second
condition works fine. (sorry if this wordwraps)
<vb code>
If shtMain.Range(RG_PROJ).Value >= 500 Then
' This is a Savannah project, send to Kevin & Paula
ThisWorkbook.SendMail Array("Kevin Coll", "Paula
Kessinger"), "Requisition " & FILE_PREFIX & Format
(shtMain.Range(RG_REL), "00000"), True
Else
' This is a Lathrop project, Kevin only
ThisWorkbook.SendMail Array("Kevin
Coll"), "Requisition " & FILE_PREFIX & Format(shtMain.Range
(RG_REL), "00000"), True
End If
</vb code>
I have tried also creating a string array variable and
using that, and also tried adding ";" after the first name
(such as with Outlook with multiple recipients).
Any help is appreciated!
work. I have a feeling this might be an issue with
exchange server, but that's just a guess. Here is the
code, I'm getting run time error 1004 when the first
condition of the IF statement is executed, the second
condition works fine. (sorry if this wordwraps)
<vb code>
If shtMain.Range(RG_PROJ).Value >= 500 Then
' This is a Savannah project, send to Kevin & Paula
ThisWorkbook.SendMail Array("Kevin Coll", "Paula
Kessinger"), "Requisition " & FILE_PREFIX & Format
(shtMain.Range(RG_REL), "00000"), True
Else
' This is a Lathrop project, Kevin only
ThisWorkbook.SendMail Array("Kevin
Coll"), "Requisition " & FILE_PREFIX & Format(shtMain.Range
(RG_REL), "00000"), True
End If
</vb code>
I have tried also creating a string array variable and
using that, and also tried adding ";" after the first name
(such as with Outlook with multiple recipients).
Any help is appreciated!