mailing labels

[Maurice Howe]

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

mailing labels

[lovebirdsforfun]

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


Karen Cook






Sent from Windows Mail

mailing labels

[j-k c-w]

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

Sent from Yahoo Mail on Android

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

Christmas mailing labels

[Chuck Popenoe]

I have been trying to use the database application to print mailing address

labels.   I have created the database file, and created the labels page 

image-which shows the 30 label images with the generic ", ,<

city>", etc, but I haven't figured out how to have the data file records
associated

with the labels merge, so the labels are correctly printed with the actual

records.   Any help will be appreciated!

Chuck Popenoe

 

Re: Christmas mailing labels

[Eldon Fredericks]

I had this same problem. I wound up copying my OO spreadsheet information into 
Apple Numbers then exporting those addresses to a csv file and creating the 
labels using Apple pages merge file. See the web address here for a little 
information:

https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=80059 


Hope that helps you.

Fred

> On Dec 24, 2015, at 12:13 PM, Chuck Popenoe  wrote:
> 
> I have been trying to use the database application to print mailing address
> 
> labels.   I have created the database file, and created the labels page 
> 
> image-which shows the 30 label images with the generic ", ,<
> 
> city>", etc, but I haven't figured out how to have the data file records
> associated
> 
> with the labels merge, so the labels are correctly printed with the actual
> 
> records.   Any help will be appreciated!
> 
> Chuck Popenoe
> 
> 
>