Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2006

Tip: Looking for answers? Try searching our database.

Import cells from excel into word and create multiple word docs

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
scdaddy7269 - 20 Mar 2006 18:43 GMT
Let me first start off by saying hello.  I am a long time browser o
this board and today I registered.
I have an excel spreadsheet with student ID numbers and scores fo
various tests.  I have looked at the microsoft templates as well a
done an extensive search here and I have not been able to figure thi
out.
I want to create a button (or some type of function) in the excel fil
that will export the student ID and several of the test scores whic
are in the same row into a word document I have created.  I would lik
to be able to select any student or students and then press the butto
to fill in the word template with their information and save it as
new document with the student ID as the name.
I do not know how to set this up.
I use excel almost every day but I have very little experience wit
macros.
Any help as to which direction to head with this would be muc
appreciated.

-Cha
Carim - 20 Mar 2006 18:51 GMT
Hi Chad,

It is more of a Word issue ...
Indeed, If you take a look at the MailMerge function in Word, you will
be able to have your excel spreadsheet acting as the reference database
...

HTH
Cheers
Carim
scdaddy7269 - 20 Mar 2006 20:03 GMT
Thanks, the solution was much easier than expected.

I appreciate it.

-Cha
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.