Home › Forums › Decaffeinated Coffee › How To Print Labels from Microsoft Excel?
- This topic has 7 replies, 5 voices, and was last updated 13 years, 1 month ago by popa_bar_abba.
-
AuthorPosts
-
April 10, 2011 4:01 am at 4:01 am #596207cshapiroMember
I should know this but i kinda spaced out during my excel class in brooklyn college….any ideas?!?
April 10, 2011 4:11 am at 4:11 am #757358Sister BearMemberI’m not sure you can print labels in Excel. What I think you do is use the data source from excel but make the label in word?
April 10, 2011 4:17 am at 4:17 am #757359cofeefanMemberyou do a mail merge on microsoft word.
(i only know the newest version of word so i’ll telll you how to do it on that…)
open new document
go to “mailing” tab
press start mail merge (chose labels…)
press use existing list
find and press excel list you want to use
press edit receipiant list and chose which people you want to use
press insert merge fields (make sure to put spaces commas periods etc)
then press start merge (its the last tab)
and press edit individual document
and youre good to go!
hope you understood!
good luck!
April 10, 2011 4:39 am at 4:39 am #757360apushatayidParticipantIn short, you don’t print the labels from excel, you print them using word. You can import (merge) your excel lists into word. Microsoft has a pretty simple to understand tutorial in the help section of Word and also online.
April 10, 2011 4:50 am at 4:50 am #757361cshapiroMemberokay idk whats wrong with me, but im just not getting it, it could be cause its a quarter to 1 in the morning and i got work tomorrow…ugh.
April 10, 2011 4:50 am at 4:50 am #757362popa_bar_abbaParticipantIt is really intuitive.
I did it for the first time with no instruction, and it was easy.
If you need directions, I would google: “how to do a mailmerge”
April 10, 2011 4:59 am at 4:59 am #757363cshapiroMemberthanks everyone!!
and pops apparently i am only 1 of 123,000 to view the youtube tutorial for mail merging :))
April 10, 2011 5:04 am at 5:04 am #757364popa_bar_abbaParticipantI just want to know how to do it with email. I suppose when I really want to find out, I’ll google “how to set up outlook”
-
AuthorPosts
- You must be logged in to reply to this topic.