USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Document Main
|
|
|
Data Source
|
|
|
Merged Document
|
|
|
Main Document
|
Detailed explanation-1: -A Data Source is a file that contains the information to be merged with the Main Document, such as names and addresses. The Data Source file can be a Word table, an Excel spreadsheet, an Access table, or a text-delimited file.
Detailed explanation-2: -The recipient list is a database that contains the data that is to be merged into the output documents. For example, the recipient list is a Microsoft Access database file or an Excel worksheet.
Detailed explanation-3: -Go to Mailings > Select Recipients > Use an Existing List, then choose New Source to open the Data Connection Wizard. Choose the type of data source you want to use for the mail merge, and then select Next. Follow the prompts in the Data Connection Wizard to complete the data connection to the merge document.
Detailed explanation-4: -All you need for data merge is a data source file and a target document. The data source file contains the information that varies in each iteration of the target document, such as the names and addresses of the recipients of a form letter.
Detailed explanation-5: -(Main Document) A document that contains the information that is the same for each merged document. The starting document contains the field names for the variable information, like the names and addresses that will be inserted.