Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Adding a list of auto text entries to word from an excel document
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. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Adding a list of auto text entries to word from an excel document
rickautry wrote:
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 FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy & transfer list of auto correct entries | New Users | |||
Print a list of personal Auto Correct entries | Microsoft Word Help | |||
cant get rid of shading on auto text entries in microsoft word | Microsoft Word Help | |||
Many of my Auto Correct and Auto Text entries are gone. I did not. | Microsoft Word Help | |||
In Word where are auto text entries stored | Microsoft Word Help |