Breaking up emailaddressen

[Crookshanks]

Hello Guys,

I've got a small question about Outlook.

I am using a Access database to select a various number of email addresses. These addresses are put in a large string variable and put into the clipboard.

Then I open a new mail in outlook and paste the addressen in the desired box (to, cc or bcc).

The problem is dat with many, many addressen, the syteem breaks up the addressen as it is at the end of a row. It happens when the emailaddress has an "-" in it.

Example:

jan@school.nl, peter@school.nl, hans@school.nl, Pieter-
Bas@school.nl

instead of

jan@school.nl, peter@school.nl, hans@school.nl,
Pieter-Bas@school.nl

Q1: Is there a way to surpress this?
Q2: Can it do any harm? (Like not recognize the emailaddress)

Kind regards and thanks in advance!

 

[franklin97355]

as to Q2 you might try it and see. It look like it did not underline the Peter part in your example so that won't work. Enclosing the names in quotes might work.

The answer has always been 42