Xem Nhiều 7/2022 # Mail Merge: Automatically Generate And Send Personalized Emails # Top Trend

Xem 6,732

Cập nhật thông tin chi tiết về Mail Merge: Automatically Generate And Send Personalized Emails mới nhất ngày 07/07/2022 trên website Theindochinaproject.com. Hy vọng nội dung bài viết sẽ đáp ứng được nhu cầu của bạn, chúng tôi sẽ thường xuyên cập nhật mới nội dung để bạn nhận được thông tin nhanh chóng và chính xác nhất. Cho đến thời điểm hiện tại, bài viết này đã đạt được 6,732 lượt xem.

--- Bài mới hơn ---

  • Sử Dụng Mail Merge Tạo Mail Hàng Loạt Trong Word 2007
  • Tạo Rule Trong Outlook, Phân Loại Và Lọc Email Trong Microsoft Outlook
  • Chuyển Email Tự Động Vào Một Thư Mục Trong Outlook
  • Hướng Dẫn Cách Đổi Tên Thư Mục Archive Trong Outlook 2022
  • Mở Và Tìm Các Mục Trong Tệp Dữ Liệu Outlook (.pst)
  • A mail merge allows you to send personalized messages to a large group of people at once without them knowing who else you have sent it to. This is a great way to have bulk messages look more personal, send everybody their own information (like a logon name and password) or send out Christmas cards.

    There are various ways to do a mail merge and there are various tools available to further simply the process or add even more options. This guide gives an overview of these methods and walks you through a couple of examples to do your own mail merge.

    Although you can also do a mail merge to a document or directly to a printer, in our examples we will use an email as the output. The process for the other output options is very similar and this guide can also be used for that.

    Mail Merge from Outlook

    Starting a Mail Merge from within Outlook is the easiest method if all the people who you want to include are already in a Contacts folder in Outlook.

    In this mail merge example we will send a select amount of contacts an email and ask them whether their contact information is correct.


    Before continuing, please verify with your ISP or mail admin first if there are any restrictions in how many emails you may send within an hour or in total on a day. Some have put a restriction on that but as long as you stay under a 100 it’s very likely you won’t run into any issues and there is probably no need to contact your ISP.

    If there is a limit set, then you can use a Mail Merge tool with scheduling functionality to work around these limits and send out the mail merge is smaller batches.

    1. Select the Contacts folder containing the contacts that you want to send an email to (pss CTRL+3 to quickly switch to your Contacts folders).
    2. Select the contacts that you want to email to or apply a filter to your view so that only the contacts that you want to address are visible. Quick methods to apply a filter are;
      • Sort or group your Contacts folder by Category or another field in 2 easy steps.
        1. Change your Arrangement.
    3. Open the Mail Merge dialog in Outlook:
    4. Verify if the correct options are set for contacts;
      • “All contacts in current view” if you filtered your view so that only the contacts that you want to address are visible.
      • “Only selected contacts” if you manually selected the contacts from the Contacts folder that you want to address.
    5. At the bottom of the dialog set the “Merge options” to;
    6. Press OK and wait for Word to start.
    7. A new document will open. Select the Mailings tab on the Ribbon.

      The Mail Merge tab in the Ribbon of Word as part of a Microsoft 365 subscription.

    8. Now it is time to start writing your message with variables. This sounds more difficult than it is;
      1. Insert a greeting line by pssing the “Greeting Line” button
      2. Select the greeting line that you want and which greeting line to use when no proper information is found from the contact information.
        • Note that you can type freely in the format fields. So instead of selecting “Dear ” you can also type “Hello “.
        • Please be aware that you need to type a space at the end of the word in order not to have it “stick” to the name of the addressee.
      3. Press OK to close the dialog and then pss ENTER to start a new line in the document.
      4. Here type the following;

        “Please verify your contact details that we have on file and either confirm it to us or provide us updated information.”

      5. Press ENTER again to start a new line and insert the address by pssing the “Address Block” button.
      6. As we’ve already addressed the person, we remove their name from the address block by disabling the option “Insert recipient’s name in this format:”

        As we only address inpiduals in our example we also disable the option “Insert company name”.

      7. Press OK to close the dialog and pss ENTER to start a new line.
      8. Now we’re going to include the home telephone number by pssing the “Insert Merge Field” button.
      9. From the dialog that pops up select Home_Phone and then pss Insert.
      10. Press Close to close the dialog and pss ENTER to start another new line.
      11. Your document should now look something like this.

    9. Before sending, it is best to pview your results first by pssing the “Preview Results” button.
    10. You can use the arrow buttons in the toolbar to browse through all the personalized emails.
    11. Now it is time to send the messages; Press the Finish & Merge button and select “Send E-mail Messages…”.
    12. Pressing OK will directly start sending the emails.

    Tool Tip!

    If you need to send along an attachment with your mail merge or also want to address people via the CC or BCC address line, then you can use the Mail Merge Toolkit add-in from MAPILab.

    If you decide to order use 4PM76A8 to get a discount.

    Mail Merge from Word with Outlook as source

    Starting your mail merge from Word is also possible. The end-result is the same as starting it in Outlook. The main difference is the dialog box that you use to select the correct contacts but more about that later.

    In this example we again send a selected amount of contacts an email but we’ll skip the letter writing as it is similar to the example above.

    1. The Task Pane panel will open on the right side of the document to choose the document type.

      Here select “E-mail messages”.

      Using the Mail Merge Wizard in Word to create a mail merge.

    2. As you can have multiple Contacts folders in Outlook we need to select the actual folder which we will be using by pssing “Choose Contacts Folder”.

      Bringing up this dialog could take a while and could also cause a mail profile prompt from Outlook.

    3. After selecting the Contact folder of your choice you could be psented with the “Choose Profile” dialog from Outlook. If you don’t know this dialog, there is probably one selection in the drop down list anyway or set to the correct default so simply pss OK.
    4. Word now opens the “Mail Merge Recipients” dialog where you can specify which contacts to send to.

      This dialog offers various selecting and filtering options. This dialog can be a bit slow when you have a lot of contacts as it refreshes the screen after ptty much every action. However, the “Find duplicates…” feature is quite handy especially, when you want to use the entire Contacts folder for your mail merge.

      The Mail Merge Recipients allows you to refine your selection of Contacts.

    5. After selecting the recipients, the next step is to write your message. The Mail Merge Wizard already shows you some variables you can use. Writing of the message can be done in the same way as in the example indicated above.
    6. The next step allows you to pview all the emails you’ll eventually be sending.
    7. In Step 6 you can pss “Electronic Mail…” to set the final options before mailing your message
        Note that it is the same dialog as we had in our pvious example but now you still need to fill in some details;

        • To: Email_Address
        • Subject line: Your personal information
    8. After setting the options, pssing OK will direct start sending the emails.

    Mail Merge from Word with another source

    When you want to send out personal emails via Outlook but the information itself isn’t in Outlook, but for instance in Excel, Access, a SQL query, a csv-file, etc., then you can start your mail merge from within Word as well.

    The process is similar as doing a mail merge from within Word with Outlook as the source, with an additional step to match the merge fields.

    1. Start the mail merge from Word again as indicated above until you reach the screen with Step 3 in the Mail Merge Wizard.
    2. In Step 3 select “Use an existing list”.
    3. Select the location of the document containing the information. This can be Excel sheets, Access Databases, Database Queries, Text Documents and many other sources as long as it is in a structured format Word can work with.
        Depending on the file type you selected you might need to put in the delimiters; the characters that are used to separate the columns and rules.
    4. After you have selected the file and optionally filtered your contacts to address, continue to Step 4.
    5. When you reach Step 4, it is a good time to match the fields from your source to Mail Merge fields to be able to use the pdefined blocks such as “Greeting Line”.

      For instance, when you have an Excel sheet that contains the columns Name, Email Address, Usernames and Passwords, you’d want to match the Name field to the “Last Name” merge field.

      1. Press the Match Fields button.
      2. You’ll now get a dialog with standard Merge Fields in Word which can be used in standardized templates.
      3. Expand the drop down list next to “Last Name” and set it to the column in your source document (in our case an Excel sheet) containing that information (in our case the column “Name”).
      4. Match up other fields if you need and pss OK to close the dialog.
    6. You can now continue with the mail merge as indicated in the process above.
    7. When you get to the dialog to send the messages, you must set the “To:” field to the column that contains the list of email addresses to send to.

    Mail Merge with 3rd party tools

    Below is a list of 3rd party mail merge tools which you can use in addition to the Word Mail Merge or as a replacement of it. I won’t discuss their start to finish processes but will highlight their unique features.

    Mail Merge Toolkit by MAPILab

    • Fully integrates with the Mail Merge Wizard providing you with more sending options.
    • Mail merge with attachments or even a different attachment for each recipient.
    • Optionally set CC and BCC recipients.
    • Allows customization of the Subject too.

    Send Inpidually by Sperry Software

    • Easy to use.
    • Automatically creates inpidual emails from addresses you have put in the To field.
    • Has its own merge fields already mapped to contact details which can be used in a message.
    • Supports a simple txt-file as the source for the mail merge with an email address on each inpidual line.

    Send Personally by MAPILab

    • Easy to use.
    • Automatically creates inpidual emails from addresses you have put in the To field.
    • Has its own merge fields already mapped to contact details which can be used in a message.
    • Allows for an exclusion list.

    Merge Tools by Doug Robbins (Word MVP)

    • Installation via a Word Startup template (dotm-file).
    • Merge to e-mail messages either with or without attachments, with the documents created by the merge being sent as either Word or PDF attachments or as the body of the e-mail message.
    • Many to One type merges, which can be used for creating documents such as invoices where there are multiple records in the data source that have common data in one of the fields.
    • Merging to a document that will include a chart that is unique to each record in the data source.
    • Video tutorial by Kevin Stratvert (ex-Microsoft employee).

    --- Bài cũ hơn ---

  • Trộn Thư Và Gửi Email Tự Động Đến Nhiều Người Với Mail Merge Trong Gmail
  • Dùng Mail Merge Để Soạn Thư Hàng Loạt Trong Ms Word
  • Hướng Dẫn Tạo Lịch, Đặt Phòng Họp Qua Phần Mềm Microsoft Outlook
  • Tìm Kiếm Email Outlook Theo Người Gửi, Ngày, Từ Khóa, Kích Thước Và Hơn Thế Nữa
  • Sử Dụng Thư Mục Tìm Kiếm Để Tìm Các Thư Hoặc Mục Outlook Khác
  • Bạn đang xem bài viết Mail Merge: Automatically Generate And Send Personalized Emails trên website Theindochinaproject.com. Hy vọng những thông tin mà chúng tôi đã chia sẻ là hữu ích với bạn. Nếu nội dung hay, ý nghĩa bạn hãy chia sẻ với bạn bè của mình và luôn theo dõi, ủng hộ chúng tôi để cập nhật những thông tin mới nhất. Chúc bạn một ngày tốt lành!

  • Web hay
  • Links hay
  • Push
  • Chủ đề top 10
  • Chủ đề top 20
  • Chủ đề top 30
  • Chủ đề top 40
  • Chủ đề top 50
  • Chủ đề top 60
  • Chủ đề top 70
  • Chủ đề top 80
  • Chủ đề top 90
  • Chủ đề top 100
  • Bài viết top 10
  • Bài viết top 20
  • Bài viết top 30
  • Bài viết top 40
  • Bài viết top 50
  • Bài viết top 60
  • Bài viết top 70
  • Bài viết top 80
  • Bài viết top 90
  • Bài viết top 100
  • CẦM ĐỒ TẠI F88