Showing posts with label Computer. Show all posts
Showing posts with label Computer. Show all posts
Tuesday, May 27, 2014
Tuesday, May 13, 2014
TableHtml
<div>
<table border="1" bordercolor="#288822" cellpadding="0" cellspacing="0" style="width: 100%;"><tbody>
<tr valign="top"><td><div>
11</div>
</td><td><div>
12</div>
</td></tr>
</tbody></table>
</div>
<table border="1" bordercolor="#288822" cellpadding="0" cellspacing="0" style="width: 100%;"><tbody>
<tr valign="top"><td><div>
11</div>
</td><td><div>
12</div>
</td></tr>
</tbody></table>
</div>
11
|
12
|
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, December 31, 2013
How to Remove Auto Hyperlinks on Excel on Office
Office Button / Excel Option / Proofing / Auto correct Options / AutoFormat As you Type / Unchecked / "Internet and newtwork paths with hyperlinks "
Subscribe to:
Posts (Atom)