So you might have columns that read Email, First Name, Surname etc.1 Writer Guide Chapter 11 Using Mail Merge Form Letters, Mailing Labels, and EnvelopesCombine the first and last names with functions. This file should be set up with headings in each column with the first column being email. All data that will be merged into the email is taken from an excel file. Mail merge emails are written and managed from Word, not from Outlook.Excel formula: Cell 1&Cell 2 However, in this case we want to combine a first name and a last name, say Jane Doe.First install Sage 50 on the computer that will store your Sage 50 company data. If you just want to combine two text strings, simply start out with the equal sign, select the first cell add an '&' and select the second cell. Concatenate(A2, ' ',B2) Step 1: In a blank cell, such as C2, enter the formulas of Concatenate(A2, ' ',B2), see screenshot:By using the ampersand (&) you can combine content of two cells into one new cell.Jean Hollis Weber John A Smith Feedback Please direct any comments or suggestions about this document to the Documentation Team s mailing list: Note: Everything you send to a mailing list, including your address and any other personal information that is written in the message, is publicly archived and cannot be deleted. Contributors Ron Faile Jr. All trademarks within this guide belong to their legitimate owners. You may distribute it and/or modify it under the terms of either the GNU General Public License ( version 3 or later, or the Creative Commons Attribution License ( version 4.0 or later. Contributors are listed below.
![]() Merging First And Last Name In 2008 Excel Mac Equivalent Effect2) How to create and print form letters, mailing labels, and envelopes. The steps include: 1) How to create and register a data source. This chapter describes the entire process. Windows or Linux Mac equivalent Effect Tools > Options menu selection Right-click LibreOffice > Preferences Control+click and/or right-click depending on computer setup Access setup options Opens a context menu Ctrl (Control) (Command) Used with other keys F5 Shift+ +F5 Opens the Navigator F11 +T Opens the Styles and Formatting window Documentation for LibreOffice is available at3 Contents Copyright.2 Contributors.2 Feedback.2 Acknowledgments.2 Publication date and software version.2 Note for Mac users.2 What is mail merge?.4 Creating and registering the data source.4 Deregistering a data source.7 Re-registering an existing data source.7 Creating a form letter.7 Editing merged documents.11 Printing mailing labels.11 Preparing for printing.11 Removing blank lines from labels.14 Printing Editing a saved file of mailing labels.15 Printing envelopes.16 Setting up envelopes for printing.16 Merging and printing the envelopes.19 Creating an envelope template.19 Using the Mail Merge Wizard to create a form letter.20 Step 1: Select starting document.20 Step 2: Select document type.20 Step 3: Insert address block.21 Selecting the data source (address list).22 Selecting the address block.22 Matching the fields.23 Step 4: Create salutation.24 Step 5: Adjust layout.26 Step 6: Edit document and insert extra fields.27 Step 7: Personalize documents.28 Step 8: Save, print or send.29 Using Mail Merge 34 What is mail merge? LibreOffice Writer provides very useful features to create and print: Multiple copies of a document to send to a list of different recipients (form letters) Mailing labels Envelopes All these facilities, though different in application, are based around the concept of a registered data source, from which is derived the variable address information necessary to their function. For a more detailed list, see the application Help.For the following example we start with a spreadsheet with the following column (field) headers: Title, First Name, Last Name, Address, State/County, Country, Post Code, Sex, and Points. If the information to be used in the mail merge is currently in a format that LibreOffice cannot access directly, you need to convert it, for example by exporting it to a comma-separated values (CSV) file. LibreOffice can access a wide variety of sources of data to create the database, including spreadsheets, text files and databases such as MySQL, Adabas, and ODBC. This chapter assumes that you are using a data source. Although you can create and print mailing labels and envelopes without using a data source, in most cases using one is the best approach. Creating and registering the data source A data source is a database containing the name and address records (and optionally other information) from which a mailing list may be derived. Buy microsoft access for mac4 Using Mail Merge6 5) In the next dialog, click Browse and navigate to the spreadsheet that contains the address information. 1) From within any Writer document, or from the LibreOffice Start Center, choose File > Wizards > Address Data Source. You only need to do this once after that, the data source is available to all components of LibreOffice. Figure 1: Spreadsheet data example After being created as described below, for a data source to be directly accessible from within a Writer document, it must be registered. Figure 6: Because this is a spreadsheet, do not click Field Assignment 8) A database file will be created. Because this is a spreadsheet, do not click Field Assignment. 7) On the following page, click Next. Figure 5: Selecting the spreadsheet document 6) Click Finish. At this time you may wish to test that the connection has been correctly established by clicking on the Test Connection button (not shown in illustration). In our example, the name Points was used for both. The name in this field is the registered name, which LibreOffice will display in data source listings. You may also change the name in the Address book name field. The default is Addresses.odb but you may replace Addresses with another name if you wish. ![]() Re-registering an existing data source To re-register an existing database file of addresses do the following: 1) Open the Data sources window (by selecting View > Data Sources from the Menu bar, or by pressing F4, or by selecting the Data Sources icon on the Standard toolbar). It can be registered again using the methods outlined below. This does not delete the database from your system. 7) Click OK to close the Registered databases dialog. 6) Repeat steps 4) and 5) as required. 5) Click Delete, then click Yes in the confirmation box which opens. Click the Open button to return to the Create Database Link dialog. 4) In the Registered databases dialog which opens, click the New button 5) In the Create Database Link dialog which opens, click the Browse button and navigate to the database file location and select it. 3) Select Registered databases from the context menu. Creating a form letter Example: Sending a letter to your customer base A mail order company organized a campaign to assign credit points to their customers according to the quantity of goods they buy during one year. 8) Click the OK button to exit the Registered databases dialog. 7) Click the OK button to exit this dialog. ![]() A) Choose File > Print and respond with Yes in the message box. 7) The document is now ready to be printed. To test for multiple conditions use the operators AND and/or OR between the conditional statements, for example:!and! d) Click Insert, but do not close the dialog until you have amended all the lines that should be suppressed. For example, in our Points database the condition to test if the Last Name field is empty would be:! as illustrated in Figure 11. C) Click OK to send the letters directly to the printer. To select a block of records, select the first record in the block, scroll to the last record in the block, and Shift+click on the last record. To select records to be printed, use Ctrl+click to select individual records.
0 Comments
Leave a Reply. |
AuthorDennis ArchivesCategories |