- Email: Gmail outlook Yahoo
- Web: picturetrail |Download youtube
- phtotshop: Change Sky
- Music:criss Angel BeliEve | 凤凰传奇 |
- Travel: 紐約最棒屋頂餐廳
- My Video: 我的孙女
- Computer:
- How to Remove Auto Hs on yperlink offce
- Word Mail Merge
- page Layot /orienation /Landscape
- Transpose in Excel
- Friends Web: MeiYu |Classwu| Shirley Snoopy |Lee | LiLo |Travel: 紐約最棒屋頂餐廳
Wednesday, January 1, 2020
Homepage
Tuesday, March 18, 2014
Tuesday, February 11, 2014
Word Mail Merge
Word Mail Merge
一、
Excel:Company information
二、
Word:
1.
Open
Word 2007→office Button→New→輸入“Notice”→“Letter notifying customer of past due bill”→Download。
3.
Mailings→Select Recipients→Use Existing List→Open製作好的“Company information”
4.
Highlight
[Recipient Name]→Insert Merge Field→選擇Name→Preview Results。
5.
Highlight
[Title]→Rules→If…Then…Else→
1)
Field
name = Gender; Equal to M; Insert this text = Mr. ; Otherwise insert this text
= Ms.
6.
Highlight
[Company Name]→Insert Merge Field→Company。
7.
Highlight
[Street Address]→Insert Merge Field→Street Address。
8.
Highlight
[City, ST ZIP Code]→Insert Merge Field→City Zip Code。
9.
下面一行→Insert Merge Field→Tel.
10. Highlight [Recipient Name]→Insert Merge Field→選擇Name。
11. Finish & Merge→Edit individual Documents→All→OK
Tuesday, January 14, 2014
Tuesday, January 7, 2014
Tuesday, December 31, 2013
Tuesday, December 17, 2013
salary
<iframe width="700" height="900" frameborder="0" scrolling="no" src="https://skydrive.live.com/embed?cid=FD3CA3CF886610D3&resid=FD3CA3CF886610D3%21205&authkey=AOQrYBcsZeeo9Xs&em=2&wdAllowInteractivity=False&Item='DEC'!A1%3AJ35&wdHideGridlines=True&wdDownloadButton=True"></iframe
<iframe width="700" height="900" frameborder="0" scrolling="no" src="https://skydrive.live.com/embed?cid=FD3CA3CF886610D3&resid=FD3CA3CF886610D3%21205&authkey=AOQrYBcsZeeo9Xs&em=2&wdAllowInteractivity=False&Item='DEC'!A1%3AJ35&wdHideGridlines=True&wdDownloadButton=True"></iframe>
Tuesday, December 10, 2013
Tuesday, December 3, 2013
Tuesday, November 5, 2013
Subscribe to:
Posts (Atom)





