On Word, use Landscape orientation
Put paper on tray, short side first
Determine current data source used:
Word mail merge - Know thy source?
Sub find_datasource_for_mailmerge()
MsgBox ActiveDocument.MailMerge.DataSource.Name
End Sub
Filtering has issues (up to Word 2013):
1) "is blank" filter line suddenly added
2) filter and displayed-records not in sync
Word won't remember data source location change
Change data source - mail merge
OR re-select data source by clicking "Select Recipients" \ "Use an existing list..."
Answer Box: Print mailing labels in Word
http://office.microsoft.com/en-us/word-help/answer-box-print-mailing-labels-in-word-HA001126973.aspx
If only first label contain field(s)/data(s), see section "Most of the labels are blank"
(Indonesian) Membuat Label Undangan Sendiri (dengan Tom & Jerry Label)
http://riyandi.webege.com/2010/06/membuat-label-undangan-sendiri-dengan-tom-jerry-label/
Insert merge field conditionally:
{ IF { MERGEFIELD "Country" } < > "Your Country" { MERGFIELD "Country" }
"" }
You must use Ctrl+F9 to insert each pair of { } and Alt+F9 (or use "Toggle field codes") to hide the field
construction
Note to Self:
Main document generated by Mail Merge Wizard is basically a table, so we can perform Table-related tasks such as adding border, insert row(s) etc.
"" }
You must use Ctrl+F9 to insert each pair of { } and Alt+F9 (or use "Toggle field codes") to hide the field
construction
Note to Self:
Main document generated by Mail Merge Wizard is basically a table, so we can perform Table-related tasks such as adding border, insert row(s) etc.
No comments:
Post a Comment