意見反饋
義工

興趣嗜好 今日: 270|主題: 123003

查看: 1923 | 回覆: 7
[電腦] 求教 ~ Window xp 怎樣用word 與 excel 做 label


別墅

國民生產總值:858


發表於 06-12-11 18:58 |顯示全部帖子

求教 ~ Window xp 怎樣用word 與 excel 做 label

請指教 ~ Window xp 怎樣用word 與excel 做 label (合併例印)? 我已在excel 做左個file 已有好多不同既公司地址, 但我跟唔到word 的指示做合併例印, 我想做1張A4 size既 label 紙內有不同既地址,


大宅

國民生產總值:1874


發表於 06-12-11 22:58 |顯示全部帖子

Re: 求教 ~ Window xp 怎樣用word 與 excel 做 label

I tried to help.

- go to word
- open the mail merge tool bar (view:mail merge)
- go to mail merge (a box should open and shown on the right hand side of the page)
- then select label option
- choose the righe size of the label that you want
- follow "next - arrange your labels"
- follow "next - select data from file" (select your excel file)
- go to the mail merge tool bar, then press insert merge field icon (click to the icon that shows insert merge field)
- insert the field as how you wish it shows e.g. co name, add1, add2...etc
- press the propagate label icon (click to the icon that shows propagate label)
- follow "next - arrange your label"
- follow "next - preview your label"
- save the file then you can print

I hope it helps


別墅

國民生產總值:858


發表於 06-12-13 19:34 |顯示全部帖子

Re: 求教 ~ Window xp 怎樣用word 與 excel 做 label

hillgrove ,
請問可唔可以解中文? 我電腦是中文的, 拜託


大宅

國民生產總值:1874


發表於 06-12-13 23:37 |顯示全部帖子

Re: 求教 ~ Window xp 怎樣用word 與 excel 做 label

Hi,

Please check your email.

Good luck.


別墅

國民生產總值:858


發表於 06-12-14 13:28 |顯示全部帖子

Re: 求教 ~ Window xp 怎樣用word 與 excel 做 label

hillgrove 寫道:
Hi,

Please check your email.

Good luck.


剛 CHECK 完, 收唔到, 可否SEND多次?


大宅

國民生產總值:1874


發表於 06-12-14 16:10 |顯示全部帖子

Re: 求教 ~ Window xp 怎樣用word 與 excel 做 label

I have sent it twice but bounced back. Can you send me an email then I return back to you. My email is [email protected]


別墅

國民生產總值:858


發表於 06-12-19 17:19 |顯示全部帖子

Re: 求教 ~ Window xp 怎樣用word 與 excel 做 label

hillgrove ,
Thank you very much, I received .


別墅

國民生產總值:858


發表於 06-12-19 17:31 |顯示全部帖子

Re: 求教 ~ Window xp 怎樣用word 與 excel 做 label

君瑤媽 寫道:
hillgrove ,
Thank you very much, I received .


請問有沒有人知道點解我在word內的合併例印既 tool bar 係灰色, 所以用唔到,點先可以顯現番有顏色及用得到呢? 多多幫忙我這個電腦白痴.


© Baby-Kingdom.com Limited. All rights reserved.