Jill has attended:
Excel Introduction course
Databases
Is there any way other than cut and paste that I can get info from Excel into Wrd?
RE: databases
That is often the best way of doing it. Are you having particular challenges with that method, or was it a general question?
RE: databases
The method is incredibly laborious and time-consuming when there are hundreds of names, as, say, in the case of a mail merge. Considering the continuing sophistication and development of both programmes it's curious that they haven't been made more compatible in this respect. I wonder what the advantage is in using Excel for these kind of databases.
Jill
RE: databases
HI Jill
There is a function in Word called mail merge. It allows you to specify excel as the source database, and then specify field locations to merge into a Word document.
For instance, if you we creating a letter to 1000 people. you would write the template letter, and then place FIELDS in the Address and Name Areas. Word will then generate 1000 copies, replacing each record as it goes.
Depending on your version of word, you will find the tool in different places. In 2003 version, look under TOOLS> LETTERS AND MAILINGS > MAIL MERGE.
Does that address your question more specifically?
Regards
Richard
RE: databases
Thanks for this Richard - I have been using the Word mail merge tool with Access databases and have never had problems but Excel is increasingly the favoured method other people use to create databases and these are being sent to me to do a mail merge from. I have an old version of Word which doesn't give me the choice of using Excel - it's good to know the option exists and I will upgrade before I do my next merge! Thanks again.
Best wishes.
Jill
RE: databases
Great, glad you got clarify on this .
Richard