Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel 2003 training - databases

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 training - Databases

excel 2003 training - Databases

ResolvedVersion 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.