如何用word列印支票??同excel作合併列印??

依樣嘢叫Mail Merge (合併列印)

Excel可以直接做Database, 用Word, 工具 -> 信件 -> 合併列印

不過Mail Merge 唔熟的話有少少難。不過識咗真係勁方便&快

你可以上網&睇書學吓

2007-04-20 14:03:27 補充：
點做？自已上網search吓啦。依條問題難度分係20分。仲要俾埋Sample呀？

以　下　係　我　之　前　嘅　答　案


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
&n bsp;




　

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.