EmailDatabaseObject

[rwm75]

Hi Peeps, does anyone know how to add multiple email addresses with the EmailDatabaseObject Expression Builder? I am taking email addresses from text boxes on a form and managing to get one address in the TO, CC and BCC fields but I cant workout who to get additional addresses added.
Hope someone can help,
Cheers

 

[sneuberg]

Separate the recipients' names you specify in this argument (and in the Cc and Bcc arguments) with a semicolon or with the list separator set on the Number tab of the Regional Settings Properties dialog box in Microsoft Windows Control Panel.

so says

https://msdn.microsoft.com/en-us/library/office/ff196469.aspx

 

[rwm75]

hi m8, yeah I tried that before and various was of putting the separator ; in with "" or () or the whole line in () and & with "" 's lol - nae joy so far - thanks though, wish it would've worked

 

[Minty]

The final string should be

"jon@comp1.com; jo2@comp2.com; fred@comp3.com"

Assuming you have semi-colon as your local separator .

You would create this using

strSeparator = ";"
strEmailTo = "jon@comp1.com" & strSeparator & "next email address in here" etc etc

You will probably need a loop to construct it if you have a variable number of email addresses

 

[rwm75]

hi minty, thanks for the bit of code, I've searched for a while trying to solve this and going to have to bite the bullet and re-learn what I've forgotten - I'm sure I will get back to your bit of code soon lol, cheers again m8.