Microsoft Office允许您单独打印信封或作为批量邮件合并打印。这对于需要将品牌和其他自定义元素添加到广泛的邮件列表的企业来说非常有价值。
下面介绍了如何在Microsoft Excel中的信封上打印。请记住(Remember),您需要Microsoft Word和Excel才能完成这项工作。无论您是在 Windows PC 还是Mac上使用(Mac)Microsoft套件,此方法都应该有效。
第 1 步:创建您的邮件列表
第一步是创建您将向其发送邮件的收件人列表。如果您只需要打印一两个信封,则可以跳过此步骤。然而,这一步对于那些使用大型邮件列表的人来说是必不可少的。
要创建您的邮件列表:
- 打开 Microsoft Excel。
- 创建一个包含以下列的新电子表格:First Name、Surname、Address、State、Country、Postal Code。将您的联系人导入(Import)电子表格,在相应的列中添加此信息。该文件将成为您的主邮件列表。
- 在此步骤验证您的地址对于避免浪费时间和金钱打印旧的或不正确的数据非常重要。
第 2 步:设计您的信封
接下来,您需要在Microsoft Word(Microsoft Word)中准备您的信封模板。这是您将设置为在自动打印时填充收件人地址的文档。
为此:
- 在Microsoft Word(Microsoft Word)中打开一个空白文档。
- 选择邮件选项卡。
- 单击信封。
- 现在指定您的信封的纸张尺寸。为此,请选择预览(Preview)图标。
- 在信封(Envelope) 选项选项卡中,选择(Options)信封(Envelope)大小
下的下拉菜单。
- 选择您需要的信封尺寸。Word包含最常见的信封尺寸,但您可以通过单击自定义尺寸来指定自己的尺寸(Custom Size)。
- 接下来,选择“收货(Delivery)地址”框或“退货(Return)地址”旁边的“字体...(Font…) ”,为这两个选项设置所需的字体。
- 选择确定。
- 如果您愿意,最后一步是添加品牌和自定义元素。为此,请单击添加(Add)到文档。这会将信封作为常规Word文档打开,因此请像往常一样对其进行编辑。
注意:您可以使用收货地址文本框中的示例地址来查看打印时信封的外观。要预览您的信封,请单击功能区中的预览结果(Preview Results)。
步骤 3:设置打印机进纸
下一步是告诉Microsoft Word 您的打印机馈送是如何工作的(how your printer feed works)。这样可以确保正确打印您的信封,并且所有元素都在适当的组织中。
要设置打印机进纸:
- 单击邮件 > 信封。
- 选择选项。
- 单击打印选项选项卡。
- 在“进(Feed)纸方式”窗口中,选择信封送入打印机的方向。我们建议选择使信封与进纸盘边缘接壤的方法,因为这样可以更轻松地将信封放入打印机中。请注意,如果您的信封未正确放置,收货地址和退货地址将会错位。
- 选择面朝(Face)上或面朝(Face)下以定义装入信封的向上方式。
- 单击顺时针(Click Clockwise)旋转以根据您的喜好旋转信封设计。
- 如果您的打印机有多个进纸盘,请单击“进纸自”下的下拉菜单以选择正确的纸盘。
第 4 步:开始邮件合并(Mail Merge)并链接您的邮件(Link Your Mailing)列表
是时候开始邮件合并了。这将允许Microsoft Word从您的地址列表数据源中自动添加姓名和地址。
为此:
- 在Word中,单击Mailings > Start Mail Merge > Envelopes。
- 单击(Click)信封(Envelope) 选项选项(Options)卡。仔细检查“信封(Envelope) 选项(Options)”对话框中的设置并添加您的退货(Return)地址。设置好后,单击“确定”。
- Click File > Save以保存您的信封模板。
- Click Mailings > Select Recipients > Use现有列表(Existing)。如果您只打印到单个信封,请选择键入(Type)新列表(New List)。同样(Likewise),如果您的联系人已作为通讯组列表保存在(distribution list)Microsoft Outlook中,您可以选择(Choose)从Outlook 联系人(Outlook Contacts)中选择。
- 选择您的Microsoft Excel电子表格并确认选择。
- 如果需要编辑任何地址,您可以选择编辑收件人列表(Edit Recipient List)进行更改。
- 单击(Click Address Block)功能区中的地址块。此窗口将向您展示地址块在插入数据后的外观。左侧包含有关如何打印姓名和地址的选项列表。
- 选择一个选项,然后选择确定。
第 5 步:打印信封
如果一切看起来都正确,是时候完成邮件合并并将地址打印到您的信封上。为此:
- 选择 Finish(Select Finish) & Merge,然后选择Print Documents...
- 最后,确保选中“全部”并选择“确定”。
- 确保(Make)打印机设置正确,并且信封正确对齐,然后再次选择确定。您的打印机现在应该开始打印您的信封。
注意:如果您希望使用邮寄标签而不是直接在信封上打印,Word 还允许您创建和打印标签。(create and print labels)您可以通过单击邮件(Mailing)>标签(Labels)在地址标签对话框中添加详细信息。您还可以使用邮件合并(use mail merge)来创建多个标签。
不要忘记邮票
不幸的是,您不能单独使用Excel打印信封。(Excel)但是,结合MS Word和Excel,信封打印过程非常简单。通过本教程,您应该可以立即准备好下一批邮件。不要(Don)忘记支付邮费!
How to Print on an Envelope in Microsoft Excel
Microsoft Office lets you print enνelopes individually or as a mаss mail merge. This is іncredibly valuable for businesses that need to add branding and other custom elements to an extensive mailing list.
Here’s how you can print on an envelope in Microsoft Excel. Remember that you need both Microsoft Word and Excel to make this work. This method should work regardless of whether you’re using the Microsoft suite on a Windows PC or a Mac.
Step 1: Create Your Mailing List
The first step is to create the list of recipients to whom you will send mail. You can skip this step if you only need to print one or two envelopes. However, this step is essential for those working with large mailing lists.
To create your mailing list:
- Open Microsoft Excel.
- Create a new spreadsheet with the following columns: First Name, Surname, Address, State, Country, Postal Code. Import your contacts to the spreadsheet, adding this information in the corresponding columns. This document will become your master mailing list.
- Verifying your addresses at this step is important to avoid wasting time and money printing old or incorrect data.
Step 2: Design Your Envelope
Next, you need to prepare your envelope template in Microsoft Word. This is the document you will set up to populate with your recipient’s addresses when printing automatically.
To do so:
- Open a blank document in Microsoft Word.
- Select the Mailings tab.
- Click Envelopes.
- Now specify what paper size your envelopes are to be. To do so, select the Preview icon.
- In the Envelope Options tab, select the drop-down menu under Envelope size.
- Choose the size your envelopes need to be. Word contains most common envelope sizes, but you can designate your own by clicking Custom Size.
- Next, select Font… next to the Delivery address box or Return address to set the font you want for both options.
- Select OK.
- The last step is to add branding and custom elements if you desire. To do so, click Add to document. This will open the envelope as a regular Word document, so edit it as you would normally.
Note: You can use a sample address in the delivery address text box to see how your envelope will look when printed. To preview your envelope, click Preview Results in the ribbon.
Step 3: Set the Printer Feed
The next step is to tell Microsoft Word how your printer feed works. This ensures that your envelopes will be printed correctly, with all elements in the proper organization.
To set the printer feed:
- Click Mailings > Envelopes.
- Select Options.
- Click the Printing Options tab.
- In the Feed method window, select the orientation for how your envelope will feed into the printer. We recommend selecting a method where the envelope borders the edge of the feed tray, as it will make it easier to place the envelope in your printer. Note that the delivery and return addresses will be misaligned if your envelope isn’t correctly positioned.
- Select Face up or Face down to define which way up you will load the envelope.
- Click Clockwise rotation to rotate the envelope design to your preference.
- If your printer has more than one feed tray, click the drop-down menu under Feed from to choose the correct tray.
Step 4: Start the Mail Merge and Link Your Mailing List
It’s time to begin the mail merge. This will allow Microsoft Word to automatically add the names and addresses from your address list data source.
To do so:
- In Word, click Mailings > Start Mail Merge > Envelopes.
- Click the Envelope Options tab. Double-check your settings in the Envelope Options dialog box and add your Return address. When you’re set, click OK.
- Click File > Save to save your envelope template.
- Click Mailings > Select Recipients > Use an Existing List. If you’re only printing to a single envelope, select Type a New List. Likewise, if your contacts are already saved in Microsoft Outlook as a distribution list, you can select Choose from Outlook Contacts.
- Select your Microsoft Excel spreadsheet and confirm the choice.
- If any addresses need to be edited, you can select Edit Recipient List to change them.
- Click Address Block in the ribbon. This window will show you how your address block will look with your data inserted. The left-hand side contains a list of options for how the name and address will be printed.
- Choose an option, then select OK.
Step 5: Print the Envelopes
If everything looks correct, it’s time to complete the mail merge and print addresses onto your envelopes. To do so:
- Select Finish & Merge, then Print Documents…
- Finally, make sure “All” is checked and select OK.
- Make sure the printer settings are correct, and your envelopes are correctly aligned then select OK again. Your printer should now begin printing your envelopes.
Note: Word also allows you to create and print labels if you’d rather use mailing labels instead of printing directly on the envelopes. You can add details in the address labels dialog box by clicking Mailing > Labels. You can also use mail merge to create several labels.
Don’t Forget Stamps
Unfortunately, you can’t print envelopes using Excel alone. However, with the combination of MS Word and Excel, the envelope printing process is incredibly easy. With this tutorial, you should have your next batch of mail ready to go in no time. Don’t forget to pay for postage!