98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 training - Databases
excel 2003 training - Databases
Resolved · Low Priority · Version Standard
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using the Quick Access Toolbar in Excel2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |