Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Import Excel Cell Contents Into Word Labels
Greetings,
I am running Office 2003 on an XP box. Is there anyway to import a list with 2 lines per record into Word and print onto Avery 5160 labels? Does the imported data need to be in any particular format? Any help will be greatly appreciated. -Minitman |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Import Excel Cell Contents Into Word Labels
You can do this with a mail merge. See
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm and http://www.gmayor.com/mail_merge_lab...th_word_xp.htm (applies to Word 2003). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Minitman" wrote in message ... Greetings, I am running Office 2003 on an XP box. Is there anyway to import a list with 2 lines per record into Word and print onto Avery 5160 labels? Does the imported data need to be in any particular format? Any help will be greatly appreciated. -Minitman |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Import Excel Cell Contents Into Word Labels
Hello Suzanne,
Thanks for the reply. I have been trying to apply the information in these links to my situation and have made a lot of progress, just not enough. I can get the blank labels on the blank sheet with the Next Record in each label (except the first label). Importing from Excel doesn't seem to bring in any data??? The Excel worksheet (only one sheet in this workbook) that I used as my data source, is setup with no headers, where I used column A for Label line 1 (Cell A1 is the first date I need a label for) and column B for Label line 2 (B1 is formatted as the day of the week for the first day). A1 & B1 are the same except for the formatting. All of the proceeding rows are simply the cell above + 1. The label format I need is: Line 1: mmm dd, yyyy 36 pointBoldArial Narrow Line 2: ddd 24 pointBoldArial Is there any way to use formulas and formatting to advance each label ahead by 1 day with the formatting listed above instead of importing the data from Excel? What do I need to do to get these dates in this format on these labels (Avery 5160 labels)? Any additional help will be appreciated. -Minitman On Sun, 23 Aug 2009 12:57:28 -0500, "Suzanne S. Barnhill" wrote: You can do this with a mail merge. See http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm and http://www.gmayor.com/mail_merge_lab...th_word_xp.htm (applies to Word 2003). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Minitman" wrote in message .. . Greetings, I am running Office 2003 on an XP box. Is there anyway to import a list with 2 lines per record into Word and print onto Avery 5160 labels? Does the imported data need to be in any particular format? Any help will be greatly appreciated. -Minitman |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Import Excel Cell Contents Into Word Labels
In the Excel Worksheet, insert a new row at the top of the data into cell A1
insert the word Date and into cell B1, insert the word Day. Then when you attach your mail merge main document to that Worksheet, insert the merge field Date into the first label on the sheet, then press enter and then insert the mergefield Day. Then follow the rest of the instructions on Graham Mayor's website. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Minitman" wrote in message ... Hello Suzanne, Thanks for the reply. I have been trying to apply the information in these links to my situation and have made a lot of progress, just not enough. I can get the blank labels on the blank sheet with the Next Record in each label (except the first label). Importing from Excel doesn't seem to bring in any data??? The Excel worksheet (only one sheet in this workbook) that I used as my data source, is setup with no headers, where I used column A for Label line 1 (Cell A1 is the first date I need a label for) and column B for Label line 2 (B1 is formatted as the day of the week for the first day). A1 & B1 are the same except for the formatting. All of the proceeding rows are simply the cell above + 1. The label format I need is: Line 1: mmm dd, yyyy 36 pointBoldArial Narrow Line 2: ddd 24 pointBoldArial Is there any way to use formulas and formatting to advance each label ahead by 1 day with the formatting listed above instead of importing the data from Excel? What do I need to do to get these dates in this format on these labels (Avery 5160 labels)? Any additional help will be appreciated. -Minitman On Sun, 23 Aug 2009 12:57:28 -0500, "Suzanne S. Barnhill" wrote: You can do this with a mail merge. See http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm and http://www.gmayor.com/mail_merge_lab...th_word_xp.htm (applies to Word 2003). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Minitman" wrote in message . .. Greetings, I am running Office 2003 on an XP box. Is there anyway to import a list with 2 lines per record into Word and print onto Avery 5160 labels? Does the imported data need to be in any particular format? Any help will be greatly appreciated. -Minitman |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
Import Excel Cell Contents Into Word Labels
Hello Doug,
Thanks for the reply. That helped quite a bit!!! All that is left now is the Date format. I have the size and font working. but I can't seem to find where the date formats are hiding! I need for line 1 to be formatted as a Date in the "mmm dd, yyyy" format and line 2 to be formatted as "dddd" Date Format. Right now both lines are in the "m d, yyyy" Date format How can I apply my preferred formatting on these labels? As always, any help will be appreciated. -Minitman On Mon, 24 Aug 2009 22:22:10 +1000, "Doug Robbins - Word MVP" wrote: In the Excel Worksheet, insert a new row at the top of the data into cell A1 insert the word Date and into cell B1, insert the word Day. Then when you attach your mail merge main document to that Worksheet, insert the merge field Date into the first label on the sheet, then press enter and then insert the mergefield Day. Then follow the rest of the instructions on Graham Mayor's website. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Minitman" wrote in message .. . Hello Suzanne, Thanks for the reply. I have been trying to apply the information in these links to my situation and have made a lot of progress, just not enough. I can get the blank labels on the blank sheet with the Next Record in each label (except the first label). Importing from Excel doesn't seem to bring in any data??? The Excel worksheet (only one sheet in this workbook) that I used as my data source, is setup with no headers, where I used column A for Label line 1 (Cell A1 is the first date I need a label for) and column B for Label line 2 (B1 is formatted as the day of the week for the first day). A1 & B1 are the same except for the formatting. All of the proceeding rows are simply the cell above + 1. The label format I need is: Line 1: mmm dd, yyyy 36 pointBoldArial Narrow Line 2: ddd 24 pointBoldArial Is there any way to use formulas and formatting to advance each label ahead by 1 day with the formatting listed above instead of importing the data from Excel? What do I need to do to get these dates in this format on these labels (Avery 5160 labels)? Any additional help will be appreciated. -Minitman On Sun, 23 Aug 2009 12:57:28 -0500, "Suzanne S. Barnhill" wrote: You can do this with a mail merge. See http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm and http://www.gmayor.com/mail_merge_lab...th_word_xp.htm (applies to Word 2003). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Minitman" wrote in message ... Greetings, I am running Office 2003 on an XP box. Is there anyway to import a list with 2 lines per record into Word and print onto Avery 5160 labels? Does the imported data need to be in any particular format? Any help will be greatly appreciated. -Minitman |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
Import Excel Cell Contents Into Word Labels
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Minitman" wrote in message ... Hello Doug, Thanks for the reply. That helped quite a bit!!! All that is left now is the Date format. I have the size and font working. but I can't seem to find where the date formats are hiding! I need for line 1 to be formatted as a Date in the "mmm dd, yyyy" format and line 2 to be formatted as "dddd" Date Format. Right now both lines are in the "m d, yyyy" Date format How can I apply my preferred formatting on these labels? As always, any help will be appreciated. -Minitman On Mon, 24 Aug 2009 22:22:10 +1000, "Doug Robbins - Word MVP" wrote: In the Excel Worksheet, insert a new row at the top of the data into cell A1 insert the word Date and into cell B1, insert the word Day. Then when you attach your mail merge main document to that Worksheet, insert the merge field Date into the first label on the sheet, then press enter and then insert the mergefield Day. Then follow the rest of the instructions on Graham Mayor's website. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Minitman" wrote in message . .. Hello Suzanne, Thanks for the reply. I have been trying to apply the information in these links to my situation and have made a lot of progress, just not enough. I can get the blank labels on the blank sheet with the Next Record in each label (except the first label). Importing from Excel doesn't seem to bring in any data??? The Excel worksheet (only one sheet in this workbook) that I used as my data source, is setup with no headers, where I used column A for Label line 1 (Cell A1 is the first date I need a label for) and column B for Label line 2 (B1 is formatted as the day of the week for the first day). A1 & B1 are the same except for the formatting. All of the proceeding rows are simply the cell above + 1. The label format I need is: Line 1: mmm dd, yyyy 36 pointBoldArial Narrow Line 2: ddd 24 pointBoldArial Is there any way to use formulas and formatting to advance each label ahead by 1 day with the formatting listed above instead of importing the data from Excel? What do I need to do to get these dates in this format on these labels (Avery 5160 labels)? Any additional help will be appreciated. -Minitman On Sun, 23 Aug 2009 12:57:28 -0500, "Suzanne S. Barnhill" wrote: You can do this with a mail merge. See http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm and http://www.gmayor.com/mail_merge_lab...th_word_xp.htm (applies to Word 2003). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Minitman" wrote in message m... Greetings, I am running Office 2003 on an XP box. Is there anyway to import a list with 2 lines per record into Word and print onto Avery 5160 labels? Does the imported data need to be in any particular format? Any help will be greatly appreciated. -Minitman |
#7
Posted to microsoft.public.word.newusers
|
|||
|
|||
Import Excel Cell Contents Into Word Labels
All the date formats are listed in Word's Help but also at
http://sbarnhill.mvps.org/WordFAQs/DateFields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Minitman" wrote in message ... Hello Doug, Thanks for the reply. That helped quite a bit!!! All that is left now is the Date format. I have the size and font working. but I can't seem to find where the date formats are hiding! I need for line 1 to be formatted as a Date in the "mmm dd, yyyy" format and line 2 to be formatted as "dddd" Date Format. Right now both lines are in the "m d, yyyy" Date format How can I apply my preferred formatting on these labels? As always, any help will be appreciated. -Minitman On Mon, 24 Aug 2009 22:22:10 +1000, "Doug Robbins - Word MVP" wrote: In the Excel Worksheet, insert a new row at the top of the data into cell A1 insert the word Date and into cell B1, insert the word Day. Then when you attach your mail merge main document to that Worksheet, insert the merge field Date into the first label on the sheet, then press enter and then insert the mergefield Day. Then follow the rest of the instructions on Graham Mayor's website. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Minitman" wrote in message . .. Hello Suzanne, Thanks for the reply. I have been trying to apply the information in these links to my situation and have made a lot of progress, just not enough. I can get the blank labels on the blank sheet with the Next Record in each label (except the first label). Importing from Excel doesn't seem to bring in any data??? The Excel worksheet (only one sheet in this workbook) that I used as my data source, is setup with no headers, where I used column A for Label line 1 (Cell A1 is the first date I need a label for) and column B for Label line 2 (B1 is formatted as the day of the week for the first day). A1 & B1 are the same except for the formatting. All of the proceeding rows are simply the cell above + 1. The label format I need is: Line 1: mmm dd, yyyy 36 pointBoldArial Narrow Line 2: ddd 24 pointBoldArial Is there any way to use formulas and formatting to advance each label ahead by 1 day with the formatting listed above instead of importing the data from Excel? What do I need to do to get these dates in this format on these labels (Avery 5160 labels)? Any additional help will be appreciated. -Minitman On Sun, 23 Aug 2009 12:57:28 -0500, "Suzanne S. Barnhill" wrote: You can do this with a mail merge. See http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm and http://www.gmayor.com/mail_merge_lab...th_word_xp.htm (applies to Word 2003). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Minitman" wrote in message m... Greetings, I am running Office 2003 on an XP box. Is there anyway to import a list with 2 lines per record into Word and print onto Avery 5160 labels? Does the imported data need to be in any particular format? Any help will be greatly appreciated. -Minitman |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Excel 2007 cell data into word 2007 fields? | Microsoft Word Help | |||
Import Excel Workbook into word | Microsoft Word Help | |||
import an excel list for filing labels | Microsoft Word Help | |||
Import converter Excel to Word for labels mailmerge | Microsoft Word Help | |||
How to import WordPerfect labels into Word labels? | Mailmerge |