Lantica User Forum - How do I go about printing address labels?

(UTC)

Lantica User Forum › Archived Topics › Archived Topics › How do I go about printing address labels?

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: [1] 2

Send Topic

Print

Hot Topic (More than 10 Replies)

How do I go about printing address labels? (Read 5413 times)

jenni Member Offline No personal text Posts: 29 Location: North Carolina Joined: Mar 23^rd, 2004	How do I go about printing address labels? Oct 5^th, 2004 at 12:50pm	Print Post
	We have our data base set up with rabies vaccination numbers and we need to print address labels to remind our residents to renew their pet information.


	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: How do I go about printing address labels? Reply #1 - Oct 5^th, 2004 at 1:00pm	Print Post
	The easiest way is to export your data and do a merge in your word processor. If your word processor doesn't do labels, let us know the Avery number of the labels you are using and we can probably give you a PrintString routine that you can use in a Mass Update.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

jenni Member Offline No personal text Posts: 29 Location: North Carolina Joined: Mar 23^rd, 2004	Re: How do I go about printing address labels? Reply #2 - Oct 5^th, 2004 at 1:05pm	Print Post
	Thank you. I'm going to try to figure out how to merge the information. If I can't do it on my own, i'll be back to ask for further instruction.


	IP Logged

jenni Member Offline No personal text Posts: 29 Location: North Carolina Joined: Mar 23^rd, 2004	Re: How do I go about printing address labels? Reply #3 - Oct 5^th, 2004 at 1:15pm	Print Post
	I have no idea of where to start, really. I'm trying to use microsoft word to print address labels. I need about four fields (from Sesame) to work together to get enough information to form one single address label. Is there a way to get the information from the table screen?


	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: How do I go about printing address labels? Reply #4 - Oct 5^th, 2004 at 1:44pm	Print Post
	Jenni, Do you know how to export your address information from Sesame? If not, look at the section on Export starting on page 288 of the Sesame User Guide. You should be able to just accept the default options, except that you will probably want to turn on Field Name Headers. Let me know if you need help exporting. Otherwise, let me know when you've got an export done.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

jenni Member Offline No personal text Posts: 29 Location: North Carolina Joined: Mar 23^rd, 2004	Re: How do I go about printing address labels? Reply #5 - Oct 5^th, 2004 at 1:54pm	Print Post
	Thanks for your help (patience). This may take a while because it's all Greek to me!


	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: How do I go about printing address labels? Reply #6 - Oct 5^th, 2004 at 2:05pm	Print Post
	Quote: Thanks for your help (patience). This may take a while because it's all Greek to me! No problem. Everything's Greek the first time you do it.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

JFisher Junior Member Offline No personal text Posts: 51 Location: Roswell, NM Joined: Jan 7^th, 2004	Re: How do I go about printing address labels? Reply #7 - Oct 5^th, 2004 at 8:45pm	Print Post
	For MS Word 2003, there is an 11 page tutorial that can be printed out for convenience entitled: "Printing mailing labels in Word". The location: http://office.microsoft.com/en-us/assistance/HA011269731033.aspx I have used this routine with a TXT file exported from Sesame. "Kali Mera" (greek for "Good day" Jack


	IP Logged

jenni Member Offline No personal text Posts: 29 Location: North Carolina Joined: Mar 23^rd, 2004	Re: How do I go about printing address labels? Reply #8 - Oct 6^th, 2004 at 12:39pm	Print Post
	haha...some REAL Greek. nice Thanks, Jack!


	IP Logged

jenni Member Offline No personal text Posts: 29 Location: North Carolina Joined: Mar 23^rd, 2004	Re: How do I go about printing address labels? Reply #9 - Oct 25^th, 2004 at 2:26pm	Print Post
	Okay, i'm back on this task with a very limited amount of time because I start a new job next week. I have read the microsoft instructions about mail merging but I need to know how to set up a Sesame file with a couple of different fields to make up a single address. Can anyone give me specific instructions for this, please?


	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: How do I go about printing address labels? Reply #10 - Oct 25^th, 2004 at 2:28pm	Print Post
	Do you already have a Sesame database/form with the address fields?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

jenni Member Offline No personal text Posts: 29 Location: North Carolina Joined: Mar 23^rd, 2004	Re: How do I go about printing address labels? Reply #11 - Oct 26^th, 2004 at 3:41pm	Print Post
	Quote: Do you already have a Sesame database/form with the address fields? I'm not sure about what you are asking.... I have a form that is linked to the data base. It has the address broken up... name (one field), address (another field), City (field), State/Zip (yet another field). It would take all of those fields to make up one single address label. I need to make over 1,000 address labels to mail out reminders to the Village residents. I hope that I provided enough information to asnwer your question. Thank you for your help! As you can tell, i'm LOST!


	IP Logged

proudpoppy Full Member Members Offline Do What ?? Posts: 420 Location: South Carolina Joined: Apr 7^th, 2004	Re: How do I go about printing address labels? Reply #12 - Oct 26^th, 2004 at 6:26pm	Print Post
	Jenni, 1. In Sesame do a search & update of the file containing your addresses. 2.In the left bottom pane click on the left or right arrow until it says export "your file" 3. Then click on each little box next to the field you want to export you will see a "O" appear. 4.Then Right click on the bar at the top of that bottom pane and choose run. 5.Give the file a name. 6. open Word 7.Choose Tools-mail merge 8. From there Word will walk you through it.Only 3-steps in Word-2000 Hope this is what you need.


	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: How do I go about printing address labels? Reply #13 - Oct 26^th, 2004 at 6:58pm	Print Post
	Jenni, For best results with Word, when doing your export as described by ProudPoppy, you should choose Field Name Header in the Ascii Export dialog where you set an export file name. This will add a header row to your export that Word will like.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

jenni Member Offline No personal text Posts: 29 Location: North Carolina Joined: Mar 23^rd, 2004	Re: How do I go about printing address labels? Reply #14 - Oct 26^th, 2004 at 7:30pm	Print Post
	I would like to thank you both for the information. I plan to start working on this first thing in the morning! Hammer, can you explain how to create this header? I'm not stupid, I swear i'm not! Thanks again! This is very a very important task for me to complete for the Village before I leave. The others here have even less experience with computers that I do and this will make their jobs so much easier.


	IP Logged

Page Index Toggle

Pages: [1] 2

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge