Adding a list of auto text entries to word from an excel document

[rickautry]

I want to add a list of entries from an excel document, that are each in
indivudal cells, to the auto text area of word. In other words I do not want
to cut and past each one indivually in auto text as this is time consuming.

 

[Jay Freedman]

I want to add a list of entries from an excel document, that are each
in indivudal cells, to the auto text area of word. In other words I
do not want to cut and past each one indivually in auto text as this
is time consuming.

First, arrange the Excel sheet into two columns, so that each row contains a
unique name for the AutoText entry in column A and the entry itself in
column B.

Copy the two columns to the clipboard.

In a blank Word document, select Edit > Paste Special and choose "Formatted
text (RTF)". That will paste the data into the Word document as a Word
table. Save that document.

Go to http://jay-freedman.info and download the AutoTextLoader file. Unzip
the file into your Templates folder.

Use File > New to make a new document based on the AutoTextLoader 2.dot
template. Click the button on the floating toolbar, fill in the names of the
Word document containing the AutoText entries and the template to add them
to (Normal.dot by default), and click OK.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.