I will try that tonight. Thank you!
toggle quoted message
Show quoted text
On Nov 15, 2019, at 9:35 AM, Bruce Bowman <bruce.bowman@...> wrote:
?On Fri, Nov 15, 2019 at 08:40 AM, CVActor wrote:
Everything was in a text document in a one-column table.
Cindi -- This is the clue. There is no such thing as a "table" in a plain text file.
To convert Excel to plain text, do the following:
- Select the column containing the email addresses
- Type Ctrl-C to copy that column to your clipboard
- Open a new Word document and paste it into that
- Highlight the resulting table again
- Type "convert table to text" into the help box. In the dialog, select "separate text with paragraph marks"
- From the File menu, select "Save As"
- Save as type Plain Text (*.txt)
- In the resulting dialog, select MS-DOS text encoding and CR/LF line breaks
The resulting file should be acceptable to the groups.io invitation "Upload Addresses" dialog. If there's any extraneous stuff present and you don't want those lines to throw an error, you can open the file one last time and trim it using Notepad.
Bruce
