Shal,
Your instruction " I recommend against writing to a CSV. Instead select the (desired rows
of) the column in Excel and copy / paste directly into the Direct Add address box."
This worked fine. Thanks for the suggestion.
I've now run into another problem or undocumented feature. I had about 70 members in total to add. As a trial using the above method I added 2 batches of 10, and then as it was working I added the last 50 as one batch. The system came back and said that I'd reached the maximum number of direct add and this need approval, but I have not found anywhere any indication there is a maximum that I can load and in what period. Or who has to give the approval or how long that might take.
Very surprised at such a low number.
Bill
toggle quoted message
Show quoted text
-----Original Message-----
From:
[email protected] [mailto:
[email protected]] On Behalf Of Shal Farley
Sent: 14 October 2018 19:18
To:
[email protected]Subject: Re: [GMF] Direct Add commas appearing in Display Name.
Bill,
> the extra comma does not appear. They only appear if copied from the > Excel generated csv file,
In Excel you have to make sure the Display Name and the address are in the same column, otherwise an intervening comma in the CSV is inevitable.
I recommend against writing to a CSV. Instead select the (desired rows
of) the column in Excel and copy / paste directly into the Direct Add address box.
I use the CONCATENATE() function to build the desired string in an auxiliary column. For example, if Column A has the email addresses, and Column B has the Display Names, I create another column containing the
formula:
=CONCATENATE("""",$B3,""" <",$A3,">")
Note that I put " marks around the Display Name - I did that because some of my members have commas in their Display name. Without that complication it would be simply:
=CONCATENATE($B3," <",$A3,">")
Copy that formula into all the rows of the auxiliary column and now you have a copy/paste -able column for Direct Add (or Invite).
Shal
--
Help:
/static/helpMore Help:
/g/GroupManagersForum/wikiEven More Help: Search button at the top of Messages list
