Re: [libreoffice-users] Mailing

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 <steve.edmonds@ptglobal.com>
To: users@global.libreoffice.org
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 users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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 users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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