Tuesday, October 5, 2010

Word: Label mail merge from Excel data

Print Tom and Jerry label to Samsung printer laser:
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.

No comments:

Post a Comment