If you want to send a mass mailing to an address list that you maintain in a Microsoft Excel spreadsheet, you can use a Microsoft Word mail merge. The mail merge process creates a sheet of mailing labels that you can print, and each label on the sheet cont...
addr ="Katie Jordan"& vbCr &"123 Skye St."_ & vbCr &"OurTown, WA 98107"Application.MailingLabel.PrintOut Name:="5162", Address:=addr 使用CustomLabels屬性來格式化或列印自訂郵件標籤。 下列範例會針對名為 "MyLabel" 的自訂標籤設定標籤的橫向數目和縱向數目。
SelectNext:Arrange your labels>Address blockto add recipient information. SelectOK. To replicate the first label, selectUpdate all labels. SelectPreview your labelsto edit details such as paragraph spacing. SelectComplete the progress. ChoosePrint>OK>OKto print your labels. ...
程序集: Microsoft.Office.Interop.Word.dll 打印一个标签或具有相同地址的一页标签。 C# 复制 public void PrintOut (ref object Name, ref object Address, ref object ExtractAddress, ref object LaserTray, ref object SingleLabel, ref object Row, ref object Column, ref object PrintEPostageLabel, ref...
Microsoft.Office.Interop.Outlook 程序集: Microsoft.Office.Interop.Outlook.dll 指示要用作通讯地址的地址。 C# publicenumOlMailingAddress 继承 Enum OlMailingAddress 字段 名称值说明 olNone0 未定义通讯地址 olHome1 住宅通讯地址 olBusiness2 商务通讯地址 ...
Back at the “Insert Address Block” window, check out the preview to make sure everything looks good and then click “OK.” <<AddressBlock>> will now appear in your first label. Head back over to the “Mailings” tab and then click “Update Labels.” ...
_ & vbCr & "OurTown, WA 98107" Application.MailingLabel.PrintOut Name:="5162", Address:=addr Use the CustomLabels property to format or print a custom mailing label. The following example sets the number of labels across and down for the custom label named "MyLabel."VB...
_ & vbCr & "OurTown, WA 98107" Application.MailingLabel.PrintOut Name:="5162", Address:=addr Use the CustomLabels property to format or print a custom mailing label. The following example sets the number of labels across and down for the custom label named "MyLabel."VB...
From Word, you can connect to address lists stored in a variety of programs, such as Excel, Outlook, and Access. Or, if you don't have an address list, you can create one in Word and then print labels. For more information, see Word Help. Top of Page ...
Part 1. How to Create Mailing Labels from an Excel Spreadsheet To create mailing labels from an Excel spreadsheet: Step 1:Prepare your Excel spreadsheet by organizing your data into columns, with each column representing a different field, such as First Name, Last Name, Address, City, State,...