Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 training - Databases
|
|
|
The UK's most regular 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 2003 training - Databases
Resolved · Low Priority · Version Standard
Reply Mon 22 Oct 2007, 16:01Delegate Jill said...
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?
For upcoming training course dates see: Pricing & availability
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?
Reply Tue 23 Oct 2007, 08:15Delegate Jill said...
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
Reply Wed 24 Oct 2007, 00:05Delegate Jill said...
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
|