Help with Excel

“Ok all you computer wizzes...I need your help.

How can I print mailing labels from an excel spreadsheet? I have multiple names with individual columns that have:
Names address city,state zip


someone please help me...I'm about to go crazy.”

“I don't know if you can stikmon!”

“Does the paper clip guy offer any advice???”

“I think that you need to copy your data into a Word file. Excel isn't normally used for that purpose.”

“I hate Excel! Glad I could help.”

“I hate Word. I like Excel. People hate it when I attach Excel files.”

“In MS Word, create a mailing label document (MS Word has a template for the Avery labels) and specify your data source as your excel spreadsheet.

As an alternative, if you are printing to #10 envelopes, you can print the addresses directly to the envelopes with most laser printers.

I'll get more specific if you'd like. It's a little tedious to set up, but really saves a lot of time.”

“Lotus products rock! 1-2-3 and WordPro”

“hiking mood has it covered...

Excel and Word are my tools of trade these days.”

“thank you some detailed instruction would be VERY helpful. This is killing me, I seem to have gotten further with your help, but, I'm missing something and I can't seem to get it to where I need it to be, may I email you offline and then call you, or could you call me...something...this is a priority project that I am under the gun to complete. Thanks”

“can I call you? your in my neck of the woods and could really use some guidance here. I know its possible to do what I want, I just have never done it and I need to.”

“BTW...If you are free this weekend...walkindude and I are doing LBL. I live 1 1/2 hours north of you in Missouri, practically a straight line...can you make it up this far, then I can drive the rest. BPBaby will be dropping in for the festivities in the evenings.”

“Make sure you have a header row for each column:

FirstName LastName Street City State ect...

Save the excel File

Open Word with a blank page and select Mail merge from Tools

Select Create... Mailing Labels...Pick Active Window

Select GetData...Open Data Source...Open the file...Select range or entire file.

Click on Set up Document. You have to pick some format, there are several defaults to chose from. Find the one listed on your label package. Click OK

Click on Insert Merge Field.

Arrange the Fields as you want them appear on the label:

FirstName (space) LastName (return)
Street (return)
City (comma) (space) State (space) (space) PostalCode

Click OK

Click Merge

Click same or new document and OK

If that doesn't work you screwed up. Close the Word page and try again.”

“stikmon, I will be in Tampa this weekend, but will hopefully be able to make one of the hikes in April or May.

So far, I have committed to Sipsey.

If you are interested in going down there for some trail work, let me know.

I keep a manual in my bookshelf titled the "10 minute guide to Excel"....I have found it to be a handy reference when I need a refresher on Excel. It is easy to understand and should help you out.”

“I will try your step by step instructions...I appreciate it.thanks

To everyone that chimed in with assistance...thank you...tomorrow should be a better day...Maybe I can try and relax tonight. I was so frustrated and tense, I was having chest pains...work...just another 4 letter word, and the worst of them all.”

“I just printed 300 personalized letters and envelopes from an EXCEL spreadsheet database. Follow bacpac's instructions.

(Actually, I couldn't do it myself the first time because there is no help on Bill Gate's products...if anything it is negative help. My daughter showed me now, then I was on my own. You can print to any Avery label as well.)”

“bacpac!!.. oh my gosh!.. and who says Violin is the only computer brain around here!!..

:)”

“THANK YOU THANK YOU THANK YOU!!!

It works and it was sooooooooo easy.

You've made my day. I appreciate it muchly. My boss is so impressed with my genious...I took no credit, but gave it all proudly to the people on this site...he looked at me like I was nuts, but nontheless...I owe the success of the project to you all...thanks a bunch...Marc”

“muchly?”

“Way cool Stikmon!! Glad your day is going better than yesterday. Did you think bacpac was just another purty face, TD?”

“bpbaby: hehe.. ya.. :).. HEY?.. where you been?”

“So does this mean you have free reign to surf all day now? Glad it worked out for you.”

“Ummmmm....he looked at you like you were crazy because you are. I just keep being helpful here, don't I?”

“Use Microsoft Excel data as a mailing list in Word

You can use this procedure to create form letters, mailing labels, and other merged documents by merging a list of data with a Word document. You must create the list before you perform this procedure. The list must include column labels and contain no blank rows. For information about creating a list, click .

1 Save and close the workbook that contains the list you want to merge with a document in Word.
2 Switch to Microsoft Word.
3 Open the Word main document that contains the standard text for the form letter or other document you want to merge with the list.

If you're starting a new document or printing mailing labels or envelopes, click New to open a new blank document.

4 On the Tools menu in Word, click Mail Merge.
5 Click Create, and select the type of document.
6 Click Get Data, and then click Open Data Source.
7 In the Open Data Source dialog box, open the folder that contains your Microsoft Excel workbook.
8 In the Files of type box, click MS Excel Worksheets (*.xls).
9 Double-click the workbook that contains your data.

10 In the Microsoft Excel dialog box, select the named range, or type the cell references that identify the data you want to use, and then click OK.
11 When Word displays a message, click Edit Main Document or Set Up Main Document.
12 If you're creating a form letter, use the Insert Merge Field list on the Mail Merge toolbar to insert merge fields within the standard text. When you finish, click Mail Merge Helper on the Mail Merge toolbar.

If you're printing address labels or envelopes, select the printer and the size of address labels or envelopes. Then insert the merge fields in the Create Labels or Envelope Address dialog box.

13 In the Mail Merge Helper dialog box, click Merge, and then select the options you want.

Tips

· For more information about creating merged documents in Word, use the Office Assistant or Help index in Word to search for "mail merge."
· To display only the rows of data you want to merge before you select the list in Word, you can first filter the list in Microsoft Excel. When you select a filtered list as a data source in Word, select _FilterDatabase in the Microsoft Excel dialog box. For information about filtering a list, click .”

“Poster: bpbaby

Infraction: Used "bacpac" and "purty face" in the same sentence”

“QC, among other things I am the Management Representative for our ISO 9001 Quality Program.

According to the ISO standard my appearance is not a contract item that affects the quality of my posts and therefore is not a requirement for compliance. If bpbaby thinks I am a hottie it is beyond the scope of your jurisdiction.”

“bacpac and hottie used in the same paragraph??? WTF??? The world changes a little more every day.”

“I do appreciate the help that was received...all in all, the day went good and everyone was impressed that I was able to complete the job. Thank Bacpac, and thanks to everyone...its really nice to have a resource like this to tap into.

TD...yes muchly...to appreciate something slightly more than "much". Stikmon Dictionary...I can send you a copy, if you know the secret password and handshake.”