Digital asset management Manage and distribute assets, and see how they perform.Resource management Find the best project team and forecast resourcing needs.Intelligent workflows Automate business processes across systems.Governance & administration Configure and manage global controls and settings.Streamlined business apps Build easy-to-navigate business apps in minutes.Integrations Work smarter and more efficiently by sharing information across platforms.Secure request management Streamline requests, process ticketing, and more.Process management at scale Deliver consistent projects and processes at scale.Content management Organize, manage, and review content production.Workflow automation Quickly automate repetitive tasks and processes.Team collaboration Connect everyone on one collaborative platform.Smartsheet platform Learn how the Smartsheet platform for dynamic work offers a robust set of capabilities to empower everyone to manage projects, automate workflows, and rapidly build solutions at scale.Open the mail merge document and choose Yes when Word prompts you to keep the connection.You can reuse the mail merge document for your next bulk mailing.

When you save the mail merge document, it stays connected to your data source.

Repeat these steps as needed, and choose Close when done.

In the Insert Merge Field dialog box, under Fields, choose a field name (column name in your spreadsheet), and then choose Insert.On the Mailings tab, in the Write & Insert Fields group, choose Insert Merge Field.To insert data from your spreadsheet in an email message or a letter You can insert one or more mail merge fields that pull the information from your spreadsheet into your document.Note: You also can sort or filter the list to make it easier to find names and addresses In the Mail Merge Recipients dialog box, clear the check box next to the name of any person who you don't want to receive your mailing.Note: Now the Excel spreadsheet is connected to the mail merge document you?re creating in Word. If Word prompts you, choose Sheet1$ > OK.Browse to your Excel spreadsheet, and then choose Open.Choose Select Recipients > Use an Existing List.On the Mailings tab, in the Start Mail merge group, choose Start Mail Merge, and then choose the kind of merge you want to run.In Word, choose File > New > Blank document.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 build a new spreadsheet.Changes or additions to your spreadsheet are completed before it's connected to your mail merge document in Word.The Excel spreadsheet to be used in the mail merge is stored on your local machine.Data entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values.All data to be merged is present in the first sheet of your spreadsheet.For example, to address readers by their first name in your document, you'll need separate columns for first and last names. Column names in your spreadsheet match the field names you want to insert in your mail merge.Here are some tips to prepare your data for a mail merge. You'll use your Excel spreadsheet as the data source for the recipient list. The most important step in the mail merge process is to set up and prepare your data. Step 1: Prepare data in Excel for mail merge

Mail merge from excel spreadsheet