0
Can excel spreadsheet be used as the data source for a word mail merge?
Wiki User
∙ 6y ago
Yes it can be, as long as the data has been laid out properly, with the field headings in the first row and the data in the columns below that.
Orion Wisoky
Wiki User
∙ 7y agoYes it can be.
Add your answer:
Earn +20 pts
Can you use an Excel document to merge into labels?
Yes, Excel can be used as the source of data for a Mail Merge of any kind, so that includes labels.
Are there any disadvantages to having data linked in excel?
Yes. If your data source is deleted or moved, you spreadsheet will have no data to display.
What is a MS Excel and its uses?
Microsoft's Excel is a spreadsheet programme. A spreadsheet, basically, allows data (alphanumerical data) to be stored in cells, and for that data to be sorted, added to and deleted, with the spreadsheet automatically refreshing and updating the changes made by the user. A spreadsheet can also be used as a database, recording the names and addresses of customers and staff information in a business. This enables a business to perform a mail-merge to send personalised advertisements to potential customers, etc.
What can be a data source for a mail merge?
Databases and spreadsheets make good data sources for mail merge.
How do you built information maps taking excel as source in sas information map studio?
You can also Map Excel Data directly in your spreadsheet. Therefore I use Premium Excel Maps. You can find their maps on www.premiumexcelmaps.com.
What presents a data similar to an Excel spreadsheet?
print review
Why merge Excel sheets into notepad?
You can not merge excel documents into notepad, but you can copy data from Excel and paste it into notepad if you want to remove all of the formatting and have only plain text.
What are data series in a spreadsheet?
Data series usually refer to groups of data that are on Excel charts.
When the data source you select for a mail merge is an Excel workbook that has more than one worksheet?
All the data should be put in a single worksheet and that worksheet can be specified when the mail merge is being made, so it doesn't matter if there are more worksheets.
When the data source you select for a mail merge is an Excel workbook that has more than one worksheet what does Word do?
It gives you a choice of where to choose the data from. It is important to set up your data in the Excel document in a structured manner with clear headings so that you can find it, whichever worksheet it is on.
What is the role played by the MS-Excel?
The role played by Microsoft excel is handling data and spreadsheet work.
What allows data easy to summarize and charted in excel?
An Excel worksheet or spreadsheet allows data to be easily summed and charted.
