6 bước để mail merge trong word cực dễ, cực hiệu quả

Word for hillarypac.org 365Word for hillarypac.org 365 for MacWord 2019Word 2019 for MacWord 2016Word 2013Word 2010Word 2016 for MacMore...Less

Here are some tips lớn prepare your Excel spreadsheet for a mail merge. Make sure:

Column names in your spreadsheet match the field names you want lớn insert in your mail merge. For example, to lớn address readers by their first name in your document, you"ll need separate columns for first & last names.

You watching: 6 bước để mail merge trong word cực dễ, cực hiệu quả

All data to lớn be merged is present in the first sheet of your spreadsheet.

Data entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values.

The Excel spreadsheet lớn be used in the mail merge is stored on your local machine.

Changes or additions to your spreadsheet are completed before it"s connected lớn your mail merge document in Word.


Notes: 

You can import information from your Excel spreadsheet by importing information from a comma-separated value (.csv) or a text (.txt) file and use the Text Import Wizard to lớn build a new spreadsheet.


Connect và edit the mailing list

Connect to lớn your data source. For more info, see Data sources you can use for a mail merge.

Edit your mailing list

Choose Edit Recipient List.

*


Insert a merge field

You can insert one or more mail merge fields that pull the information from your spreadsheet inkhổng lồ your document.

To insert merge fields on an envelope, label, gmail message, or letter

Choose OK.

Choose File > Save.

if you"re interested in learning more about options for setting up tin nhắn message, see Thư điện tử merge in Word.


PReview & finish the mail merge

After you insert the merge fields you want, previews the results khổng lồ confirm that the nội dung is okay. and then you"re ready khổng lồ complete the merge process.

Go lớn Mailings> Pđánh giá Results.

*

Choose Next

*
or Previous
*
lớn move through records in your data source và view how they appear in the document.

Go lớn Finish và Merge > Print Documents or Sover E-mail Messages.

*


Save your mail merge

When you save the mail merge document, it stays connected to your data source. You can reuse the mail merge document for your next bulk mailing.

Open the mail merge document & choose Yes when Word prompts you to keep the connection.


See also

Here are some tips khổng lồ prepare your Excel spreadsheet for a mail merge. Make sure:

Column names in your spreadsheet match the field names you want to insert in your mail merge. For example, lớn address readers by their first name in your document, you"ll need separate columns for first & last names.

All data to lớn be merged is present in the first sheet of your spreadsheet.

See more: Top 10 Phần Mềm Vẽ Trên Ipad Miễn Phí, 6 Ứng Dụng Vẽ Tranh Hay Và Miễn Phí Trên Ipad

Data entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values.

The Excel spreadsheet to lớn be used in the mail merge is stored on your local machine.

Changes or additions khổng lồ your spreadsheet are completed before it"s connected khổng lồ your mail merge document in Word.

For more information, see Prepare your Excel data source for mail merge in Word.

Connect & edit the mailing list

Connect khổng lồ your data source. For more info, see Data sources you can use for a mail merge.

Select OK.


Insert a merge field

You can insert one or more mail merge fields that pull the information from your spreadsheet inkhổng lồ your document.

Go khổng lồ Mailings > Insert Merge Field.

Add the field you want.

Repeat steps 1 và 2 as needed.

Choose File > Save.

if you"re interested in learning more about options for setting up gmail message, see E-Mail merge in Word.


PĐánh Giá & finish the mail merge

After you insert the merge fields you want, preview the results khổng lồ confirm that the nội dung is okay. & then you"re ready to complete the merge process.

Go lớn Mailings> PĐánh Giá Results.

Choose Next or Previous lớn move through records in your data source & view how they appear in the document.

Go to lớn Finish và Merge > Print Documents or Merge to lớn E-mail.


Save sầu your mail merge

When you save the mail merge document, it stays connected lớn your data source. You can reuse the mail merge document for your next bulk mailing.

mở cửa the mail merge document & choose Yes when Word prompts you khổng lồ keep the connection.

See more: Stream Neo Đậu Bến Quê Quang Lê, Nhạc Bolero


See also
*
*
*

Need more help?


Get hillarypac.org
Liên hệ us
Exp& your Office skills
Explore training

Was this information helpful?


YesNo
Great! Any other feedback? The more you tell us, the more we can help.How can we improve? The more you tell us, the more we can help.
SendNo thanks
×
What's new
hillarypac.org Store
Education
Enterprise
Developer
Company
English (United States) © hillarypac.org 2021

Chuyên mục: Chia sẻ