View Single Post
Old 11-10-2011, 01:31 PM
Abacus1234 Abacus1234 is offline Windows Vista Office 2010 32bit
Join Date: Nov 2011
Posts: 24
Abacus1234 is on a distinguished road
Default 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"
Reply With Quote