Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sendmail | New Users to Excel | |||
Sendmail | Excel Discussion (Misc queries) | |||
Problems with SendMail or automation of Send To | Excel Programming | |||
Problems with SendMail | Excel Programming | |||
SendMail and BCC | Excel Programming |