Email addresses

[RBCC]

How do I put a "@" in the Email address such as john@golden-computers.net. But as in newsgroups@golden-computers.net, it takes the length of the john or newsgroups and adds the "@" automatically. How is this done? Thank you for your help, John

[CJ_London]

depends on what data you have but you would use & to concatenate strings together and also the left, right, mid and instr functions

So assuming you have

myname = John

and

fullemail = newsgroups@golden-computers.net

you would use

newemail=myname & mid(fullemail,instr(fullemail,"@"))