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

Top