How to merge Excel Data ??

2006-12-16 8:35 am

✔ 最佳答案

Follow the steps below to accomplish your job:
A. In Excel
Store the data to be printed in a database format. Well-organized and properly filled with appropriate data.
Let us say you have an Excel file with the following header in the 1st row

　

A

B

C

D

E

F

1
Salutation
First Name
Last Name
Address 1
Address 2
Address 3

2
　
　
　
　
　
　

Then properly fill this worksheet with data starting Row #2
After finishing with your data, save your file, exit.

B. In Word2003

B01. Click [Tools] [Envelope & Label] [Merge]

圖片參考：http://i133.photobucket.com/albums/q50/clubsny05/MergeLabel-0.jpg

B02. Then the Merge Dialogue Box will then appear at the right side of the screen. Chosse [Label], [Next], [Next]

圖片參考：http://i133.photobucket.com/albums/q50/clubsny05/MergeLabel-1.jpg

圖片參考：http://i133.photobucket.com/albums/q50/clubsny05/MergeLabel-2.jpg

B03. Choose your label type, [OK]. Click [Next]

圖片參考：http://i133.photobucket.com/albums/q50/clubsny05/MergeLabel-2a.jpg

B04. Click [Browse] to select your data source

圖片參考：http://i133.photobucket.com/albums/q50/clubsny05/MergeLabel-3.jpg

B05. In the [Data Source] Dialogue Box, Choose your Excel File previously created. Click [OK]

圖片參考：http://i133.photobucket.com/albums/q50/clubsny05/MergeLabel-3a.jpg

B06. Choose [Other Items]

圖片參考：http://i133.photobucket.com/albums/q50/clubsny05/MergeLabel-4.jpg

B07. Click [Insert] to add the data you want to shown on the label. After the selected, click [OK] to continue. Then arrange the data in its proper places on the label.

圖片參考：http://i133.photobucket.com/albums/q50/clubsny05/MergeLabel-4a.jpg

B08. Choose [Next] to preview the final look of your label

圖片參考：http://i133.photobucket.com/albums/q50/clubsny05/MergeLabel-5.jpg

B09. Choose [Next] To complete the step

圖片參考：http://i133.photobucket.com/albums/q50/clubsny05/MergeLabel-6.jpg

B10. Choose [Print] to print the label out.

👍 0 👎 0

Sing Hoi

2006-12-15 5:38 pm

首先相信你已經有個file裝哂d data
for example, 裝哂係個excel file內

係words按
檢視==>工具列==>合併列印
會出左一行bar
係果到開啟番excel file先
link番兩個file就ok架啦

👍 0 👎 0

回答 (2)