A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Office » General Discussions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel Data - Word



 
 
Thread Tools Display Modes
  #1  
Old February 24th, 2010, 08:59 AM posted to microsoft.public.office.misc
chaser
external usenet poster
 
Posts: 3
Default Excel Data - Word

So I need help with Office.

I have a data sheet in Excel. (NumberID, Name, Addres, Postal Code) and a
lot of data for these groups.

Now I would like Office to import my data into the right slots in my layout
in Word.
Example (page1, ID: (data)
Name: (data)
Addres: (data)
PosteC: (data)
page2, the same thing again but the data for person with
the ID 2 in my excel data, and so on.

Please help, I need this for my school project.
  #2  
Old February 24th, 2010, 04:59 PM posted to microsoft.public.office.misc
db
external usenet poster
 
Posts: 258
Default Excel Data - Word

what you are seeking to
do is a mail merge in
word.

the mail merge feature
will want you to assign
a database file.

the excel spreadsheet
will serve as a database.

then in word you will need
to create a form with the
fields to populate with the
data in excel.

however, name will need
to be in a column, address
will have to be in a second
column and so fourth as
the fields in the form will
require the separation of
data via columns.

so for mail merge you will
need to components, i.e.
the excel database and
the form, which can be a
label form.

there is additional help
via words help menu option

or you can go to microsoft.com
office webpage for help with
mail merge.

--

db·´¯`·...¸)))º
DatabaseBen, Retired Professional
- Systems Analyst
- Database Developer
- Accountancy
- Veteran of the Armed Forces
- Microsoft Partner
- @hotmail.com
~~~~~~~~~~"share the nirvana" - dbZen




"chaser" wrote in message ...
So I need help with Office.

I have a data sheet in Excel. (NumberID, Name, Addres, Postal Code) and a
lot of data for these groups.

Now I would like Office to import my data into the right slots in my layout
in Word.
Example (page1, ID: (data)
Name: (data)
Addres: (data)
PosteC: (data)
page2, the same thing again but the data for person with
the ID 2 in my excel data, and so on.

Please help, I need this for my school project.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.