Re: mailing labels

[Dave Barton]

 Original Message  
From: Maurice Howe
Date: Wed, 29 Jul 2015 17:37:31 -0400

> I've asked this before but a virus forced a re-"whatever" and I've lost the
> previous advice, so I have to ask again: How do print mailing labels for a
> newsletter using a WRITER file?
> 
> All I could find is for a DB file; not a WRITER file.
> 
> Maurice Howe

Hi Maurice,

Is this what you are looking for:

> That worked like a charm, Alan.  Thanks so much for your help.
> 
> On Wed, Apr 29, 2015 at 8:46 AM, Alan B  wrote:
> 
>> On Tue, Apr 28, 2015 at 5:01 PM, Maurice Howe 
>> wrote:
>>
>>> I need help printing mailing labels for a newsletter.  My data is a
>> ".doc"
>>> file comprised of a TABLE with names, addresses, etc.
>>>
>>> Using writer/tools/mail-merge, I get as far as use-current-doc/letter but
>>> the "insert address block" fields are grayed-out.  The
>> select-address-list
>>> tab shows my filename but I can't get past that.
>>>
>>
>> Hello Maurice -  I've tried a few experiments to perform mail merge. I have
>> not been able to find a way to have the source of the data be in a .doc
>> file (or a .odt file for that matter).
>>
>> The instructions I found provide reference to using a text file or a
>> spreadsheet as the data source.
>>
>> https://wiki.openoffice.org/wiki/Documentation/How_Tos/Creating_Mail_Merge_Documents_From_Text/CSV_or_Spreadsheets
>>
>> My suggestion would be copy the address table from the Word document into a
>> spreadsheet. (I tested copy from Word table into Calc spreadsheet and that
>> preserved the column and row layout.) Then use the spreadsheet as the data
>> source.
>>
>> This method worked in my tests.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: mailing labels

[Brian Barker]

At 21:19 14/11/2015 +, Karen Cook wrote:

How do I add another page of labels to the document I have started?


Are you using the official way to create labels (File | New > | 
Labels)? If so, create your page image - with the field names you 
require - but don't select the required records yet from the data 
source. Now go to File | Print... (yes: that may seem perverse!) and 
in response to the challenge "Do you want to print a form letter?", 
select Yes. Now you will see the data source display again and can 
make your selection of records, possibly requiring more than one page 
of labels.


You may find that the document produced has alternate pages blank. If 
so, this is because OpenOffice is accounting for the possibility that 
your printer may be set up to print double-sided. (You will want the 
backs of your labels to be blank!) If you are using a single-sided 
printer, you can suppress this by removing the tick at Tools | 
Options... | OpenOffice Writer | Print | Other | Print automatically 
inserted blank pages. You will discover this when you create test 
prints on waste paper before actually printing on your label stock.


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: mailing labels

[Martin Groenescheij]

On 23-Nov-15 11:35, j-k c-w wrote:

How do I add pages of labels? I am trying to put together and print labels for 
a group.


You asked the same question on 30 October and 15 November and you never 
responded to the given suggestions.





Sent from Yahoo Mail on Android