Gratutitous quotes not wanted

R

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) & " <"
& (e-mail address removed)
 
K

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.
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top