Posts

Mail Merge

Image
Introduction: Mail merge consists of combining mail and letters and pre-addressed envelopes or mailing labels for mass mailings from a form letter. This feature is usually employed in a word processing document which contains fixed text (which is the same in each output document) and variables (which act as placeholders that are replaced by text from the data source word to word). Some word processors can insert content from a database, spreadsheet, or table into text documents. It is a powerful tool for writing a personalized letter or e-mail to many people at the same time . It imports data from another source such as a spreadsheet and then uses that to replace placeholders throughout the message with the relevant information for each individual that is being messaged. Steps: The mail merging process generally requires the following steps: Creating a main document and the template. Creating a data source. Defining the merge fields in the main document. Merging the data with the m...

VLOOKUP

Image
Introduction Use VLOOKUP when you need to find things in a table or a range. For example, to find an employee name/address/email etc. Based on their employee ID. In its simplest form, the VLOOKUP function says: =VLOOKUP(What you want to look up , where you want to look for it , the column number in the range containing the value to return , return an Approximate or Exact match – indicated as 1 /TRUE, or 0 /FALSE). Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. There are four pieces of information that you will need in order to build the VLOOKUP syntax: The value you want to look up, also called the lookup value. The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C. The column number in the range that contains the ...