¿ªÔÆÌåÓý

Re: Direct adding names as well as emails #addmembers


 

Barry,

With Bruce's steps above, I'm not sure I understand what the Column A
is? "Container"--so what specifically should be in that column?
It is to contain the combined elements of each member's name & address, in the form:

"display name" <user @ example.com>

(Ignore the spaces around the @ sign, that's for the benefit of people reading this message on GMF's web pages. Here and below.)

My current xls ... has just three columns: A: Last name, B: First
name and C: email address
For your purpose you could create a column D (or any unused column) containing this expression in each row:

=CONCATENATE("""",$B1," ",$A1,""" <",$C1,">")

If you enter that in row 1, then copy/paste it to the rest of the rows Excel will automatically update the row number appropriately.

If the last name and first name name columns contain no special punctuation characters you could dispense with the "quotes" around the display name field. Comma is a common punctuation mark that would require the use of quotes. For example your list might have an entry like:

A: Lastname, MD
B: Dr. Firstname
C: user @ example.com

My expression would build:

D: "Dr. Firstname Lastname, MD" <user @ example.com>

Column B: Display name is two columns (last name, first name) so not
sure what goes here.
Yahoo exported the display name as a single column, unlike your format. You can ignore this.

Column D: the delivery option would be fine but not essential for us.
Wasn't sure the "Column G" reference or what, specifically, was meant
by "keyword"
Again, information from Yahoo (the member's Email Delivery setting) which you can ignore.

... I'm just hoping that I may have missed a clear checklist or guide
on how to upload a list of members for direct add when already in
excel in a three column format as described.
In my example you would copy column D and paste that into the box on the Direct Add page.

Direct Add does not accept Excel or csv formats, only plain text. So you'd need to export only column D into a plain text file if you'd prefer to upload from a file rather than use cut and paste.

Shal


--
Help: /static/help
More Help: /g/GroupManagersForum/wiki
Even More Help: Search button at the top of Messages list

Join [email protected] to automatically receive all group messages.