• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Before you Mail Merge using Excel, make sure your worksheet is in good shape

by on
in Excel Training,Word Tips

Before you Mail Merge using Excel, make sure your worksheet is in good shape.

First, to make it easier to identify the right list, name your worksheet. Simply double-click on the worksheet tab and type a name like customers, recipients, vendors, etc.

Next, label each column of information—for example, first name, last name, address, city, state, ZIP. If your data are combined in a single column, such as First Name and Last Name, use Text to Columns or text functions like Left, Right and Mid to get each piece of information into its own column.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/35158/before-you-mail-merge-using-excel-make-sure-your-worksheet-is-in-good-shape "

Leave a Comment