excel question

Posted By Message

MrsRitaB
Love of my life! <3

Member since 4/10

4669 total posts

Name:
Ri

excel question

does anyone know if there is a way to make addresses you put into excel into labels?

TIA

Posted 8/23/10 11:05 AM
 
Long Island Weddings
Long Island's Largest Bridal Resource

neener1211
:-)

Member since 4/07

22952 total posts

Name:
J

Re: excel question

yes, you can do a merge into a word document.

Posted 8/23/10 11:08 AM
 

BabyBoy
is Skylar Elizabeth

Member since 5/05

4189 total posts

Name:
Tom

Re: excel question

as above post said, mail merge

to make life easy...make a row with your headers (first name, last name, address, city, state, zip, etc...)

Posted 8/23/10 11:13 AM
 

PotofLuck06
Our Baby Boy Is Here!!!

Member since 11/06

13241 total posts

Name:
Betsy

Re: excel question

Posted by neener1211

yes, you can do a merge into a word document.



In Word, there is a step by step tool bar that can help you create the correct mail merge document. If you don't see the tool bar, look for it under View menu or type it into the search function.

Posted 8/23/10 11:15 AM
 

MrsRitaB
Love of my life! <3

Member since 4/10

4669 total posts

Name:
Ri

Re: excel question

Posted by PotofLuck06

Posted by neener1211

yes, you can do a merge into a word document.



In Word, there is a step by step tool bar that can help you create the correct mail merge document. If you don't see the tool bar, look for it under View menu or type it into the search function.




thanks ladies

I went to work, picked mail merge, choose labels, than uploaded my existing file. It asked me if I wanted the whole workbook and I choose that and it is coming out funny. In excel all of my rows were titled.

Can anyone pinpoint what I am doing wrong?
Chat Icon

Posted 8/23/10 11:23 AM
 

PotofLuck06
Our Baby Boy Is Here!!!

Member since 11/06

13241 total posts

Name:
Betsy

Re: excel question

Instead of choosing the whole workbook, does it give you the option of just using one of the Sheets within the workbook? Like Sheet1, Sheet2?

Posted 8/23/10 11:32 AM
 

MrsRitaB
Love of my life! <3

Member since 4/10

4669 total posts

Name:
Ri

Re: excel question

Posted by PotofLuck06

Instead of choosing the whole workbook, does it give you the option of just using one of the Sheets within the workbook? Like Sheet1, Sheet2?



yes it does but mine is only one sheet

Posted 8/23/10 11:39 AM
 

PotofLuck06
Our Baby Boy Is Here!!!

Member since 11/06

13241 total posts

Name:
Betsy

Re: excel question

Posted by MrsRitaB

Posted by PotofLuck06

Instead of choosing the whole workbook, does it give you the option of just using one of the Sheets within the workbook? Like Sheet1, Sheet2?



yes it does but mine is only one sheet



That's fine, but don't choose whole workbook. Select Sheet1 if that is where your information is stored.

Make sure the data you need in the labels runs under each correct column and each column is labelled correctly (name/address/city/state/zip).

The in word, I would use the Microsoft Word step by step guide to ensure you have the correct set up for the label.

Posted 8/23/10 11:48 AM
 

MrsRitaB
Love of my life! <3

Member since 4/10

4669 total posts

Name:
Ri

Re: excel question

Posted by PotofLuck06

Posted by MrsRitaB

Posted by PotofLuck06

Instead of choosing the whole workbook, does it give you the option of just using one of the Sheets within the workbook? Like Sheet1, Sheet2?



yes it does but mine is only one sheet



That's fine, but don't choose whole workbook. Select Sheet1 if that is where your information is stored.

Make sure the data you need in the labels runs under each correct column and each column is labelled correctly (name/address/city/state/zip).

The in word, I would use the Microsoft Word step by step guide to ensure you have the correct set up for the label.



tried this to and nothing thanks though

i sent it to my sister to see if she could help

Posted 8/23/10 12:18 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Excel question... igottabeme 1/22/08 4 Families Helping Families ™
URGENT EXCEL QUESTION kerrycec03 10/18/07 8 Families Helping Families ™
Excel Question spooks 8/22/07 1 Families Helping Families ™
Excel Question spooks 6/8/07 2 Families Helping Families ™
Excel masters - a question SweetestOfPeas 5/18/07 18 Families Helping Families ™
Dumb excel question JenniferEver 4/23/06 3 Families Helping Families ™