Hi :) I think this can be done using an existing list of addresses although it might need a bit of jiggling around to get it in the type of layout you suggested. Depending on how the first list is laid out it is often easier just to re-type it. Always kee a copy of the original safe before starting to change things around jic ;) Regards from Tom :)
________________________________ From: Steve Edmonds <[email protected]> To: [email protected] Sent: Tue, 12 July, 2011 9:59:23 Subject: Re: [libreoffice-users] Mailing On 12/07/11 10:01 AM, Sharon Van Wagoner wrote: > I have a list of addresses that I would like to print onto envelopes. How > do I do this?? > Hi. I have just done similar. I have LO 3.4.1. Create a new calc document and put your addresses in rows, with a title in row 1. I.e. Name | Address1 | Address2 | Address3 | Bob | 6 A Road | A Town | A City | Create a new writer document. Try Format>Page Select the envelope size from the drop down. Position the cursor where you want the address, i.e. by tabbing. Now Insert>Fields>Other Click Database top right, Mail merge fields on the left. Click browse to the right of Add Database file. Locate the calc file with the addresses. It should now appear in the right pane under Database selection. Expand the database you just added by clicking the arrows (triangles) until you see the address fields (column labels), select the field you want and click insert. Tab on the next line to the next address position, select the field and insert. You can highlight the fields (place holders) on the envelope and change font and size. When you click print you are asked if you want to print a form letter, answer yes, and you will be prompted to print all addresses or select the row range. Hope this helps, steve -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
