Spread Sheet to Labels? - Preferably Avery

Using them, Making them , Finding them

Spread Sheet to Labels? - Preferably Avery

Postby ivorykeys87 » Sat May 15, 2010 2:37 am

I have recently started a part time business which requires me to look up Names, Addresses, City/State/Zip code, and phone number in spreadsheet form (in that order). I list these "leads" 100 per page. I need to be able to transfer the names and addresses into label form so as to quickly print and mail information. Can anyone help me on how to do this? I know there must be a way to transfer the information from one format to the other because FedEx Kinkos was going to do my mailing for me and told me to just bring the names and addresses to them in spreadsheet form. Any help would be greatly appreciated!
open office 3.1 on windows XP
ivorykeys87
 
Posts: 1
Joined: Sat May 15, 2010 2:24 am

Re: Spread Sheet to Labels? - Preferably Avery

Postby acknak » Sat May 15, 2010 3:02 am

AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Spread Sheet to Labels? - Preferably Avery

Postby jrkrideau » Sun May 23, 2010 6:13 pm

ivorykeys87 wrote:I have recently started a part time business which requires me to look up Names, Addresses, City/State/Zip code, and phone number in spreadsheet form (in that order). I list these "leads" 100 per page. I need to be able to transfer the names and addresses into label form so as to quickly print and mail information. Can anyone help me on how to do this? I know there must be a way to transfer the information from one format to the other because FedEx Kinkos was going to do my mailing for me and told me to just bring the names and addresses to them in spreadsheet form. Any help would be greatly appreciated!


I think acknak has given you information you need but can I suggest that in the long run you might want consider moving that data to a data base (e.g. Base)? It will be a pain to do but once the data is in the database you can do a lot more with it, including such things as much more targeted marketing.
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3746
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Spread Sheet to Labels? - Preferably Avery

Postby TheGurkha » Sun May 23, 2010 7:00 pm

Here's a long page of all kinds of useful stuff to do with labels: Labels Tutorials
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
User avatar
TheGurkha
Volunteer
 
Posts: 6482
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.


Return to Templates

Who is online

Users browsing this forum: No registered users and 1 guest