I need to print out a big amount of address labels. I heard that there's a way to merge the data from Excel to print it out easily. Please help to solve this and specify it step to step.
Many thx.
How to merge Excel Data ??
2006-12-15 5:28 pm
回答 (2)
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.
2006-12-15 5:38 pm
首先相信你已經有個file裝哂d data
for example, 裝哂係個excel file內
係words按
檢視==>工具列==>合併列印
會出左一行bar
係果到開啟番excel file先
link番兩個file就ok架啦
for example, 裝哂係個excel file內
係words按
檢視==>工具列==>合併列印
會出左一行bar
係果到開啟番excel file先
link番兩個file就ok架啦
收錄日期: 2021-04-12 23:10:43
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061215000051KK00517