Adding email address to Dcmd sendobject

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • YPMA
    New Member
    • Mar 2013
    • 5

    Adding email address to Dcmd sendobject

    Currently I use the send object to send an email from an open form to a client which is store as a record set. I then added the department head as a copy info ,works fine.

    Now I wish to add another cc deputy head of department ,How do I add another email address to my existing code,

    [code]DoCmd.SendObjec t , , acFormatRTF, clientEmail, "head of shed@work.biz" _
    , , strSubject, strEMailMsg, False, False [code]

    I have tried to put a ";" between headofsheds email address and new address without success , Please advise

    Ypma
  • YPMA
    New Member
    • Mar 2013
    • 5

    #2
    After a bit of trial and error I have solve my problem by creating a string for the cc addresses

    code Dim ccto as string
    ccto ="headofshed@wo rld.com" &;&"notheadofsh ed@world.com" code

    and inserting the string ccto after Clientemail.

    Thanks for looking

    Comment

    Working...