Excel VBA using Sendmail to Send to Distribution List

B

belkingold

I am trying to use the SendMail function in Excel VBA to send the
workbook as an attachment to a distribution list. The distribution
list contains spaces, and it keeps coming back as an unknown
recipient. Here's the code, it's pretty simple:

ActiveWorkbook.SendMail _
Recipients:=EmlAddr & ";" & CCAddr, _
Subject:=FleNme


The variables:

EmlAddr = "(e-mail address removed)"
CCAddr = " CCI HRD - LNP Support"

I realize, of course that this is all going in to the To: line and
that you can't use an actual CC with sendmail, but that's not really a
big deal to me. CCAddr is the distribution list.

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Email to a distribution list in Excel - Simple Version Please 4
Using VBA to send email to distribution list ... how to CC? 5
Using SendMail through Access - Excel Automation 2
SendMail to multiple recipients, one variable, and one constant 2
Sendmail: Problem when used after a Userform 12
Excel macro Cc distribution list control 2
"Sendmail" macro to multilpe addresses 8
Automatic email to recipient 1

Top