John Stile wrote: > I need to print spreadsheet data on an Avery template for my labels. > I found a compatible .doc on the Avery web site, but haven't found how > to fill in the data. > > The tutorials say many things but none lead me to what I need. > Some say use File->New->Labels but my labels aren't compatible. > Some say to use mail merge wizard, but I'm not creating an email or > letter. > > Any pointers would be most appreciated. > The wedding is 6 weeks out and I need to send these letters out.
Other have replied suggesting what/how to go about doing this. A few additional links that might help: http://openoffice.blogs.com/openoffice/2007/10/making-life-wit.html http://openoffice.blogs.com/openoffice/labels/ http://openoffice.blogs.com/openoffice/mail_merge/ I just want to confirm that I have used OOo's labels feature with success. The interface to create new labels could be better and more intuitive, but when you create labels the first time, it is a breeze subsequent times. I have made labels when I filled different data in labels by hand, and also by reading data from a spread sheet (MS Excel or OOo ods). I would like to mention that sometimes the built in Avery label's margins are not exactly what you get when you print out the labels on your printer. So I print out one page of labels on a normal sheet first, hold it and the blank labels sheet together against the list and see where the labels' text falls on the label's sheet's grid and how the margins look like. If needed, I tweak the top margin in page setup, or text indent in the labels text to fix any problems. It is not difficult to create new labels if the built in labels types do not agree with the label's sheets you have. Good luck. -- Please reply to this list only. I read this list on its corresponding newsgroup on gmane.org. Replies sent to my email address are just filtered to a folder in my mailbox and get periodically deleted without ever having been read. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
