Gratutitous quotes not wanted

[Robin Chapple]

I have a database with separate fields for "FirstName", "LastName" and
"Emailddress"

I use this SQL to produce a complete email address:

FullEmail: Chr$(34) & [FirstName] & " " & [LastName] & Chr$(34) & " <"
& & ">"

The query gives this type of output:

"Omar Chaidez" <[email protected]>

which is just as I planned.

When copied and pasted I get This:

"""Omar Chaidez"" <[email protected]>"

Where, and why, do the additional quotes come from?

Thanks,

Robin Chapple

 

[Ken Snell [MVP]]

Copied and pasted to where, Robin? Whichever application is the one to which
you're pasting the email address, it believes that this is one big text
string that needs to be delimited with the " marks; ergo, the extra ones
around the name itself.

 

[Robin Chapple]

It is part of an broadcast email to club members. The whole output is
pasted into nickname list in my Eudora address book.

I've been doing that for about ten years and this is the first time it
has happened.

I'll investigate Eudora next.

Thanks.