Pulling email address from access table into outlook
Below is part of a macro in a document, which I am sending by outlook to an email address in a field in the database called b1email. I would like to put more than one address in this field. If I enter 2 address separated by a comma, outlook comes back and tells me to use a semi-colon, if I use a semi-colon, outlook does not recognise either address and gives me error message 5630.
With ActiveDocument.MailMerge
.Destination = wdSendToEmail
.MailAsAttachment = False
.MailAddressFieldName = "b1email"
|