Over 1 million tech questions and answers.

Export mailing labels from Word into Excel

Q: Export mailing labels from Word into Excel

How to export mailing labels from Word 2010 into Excel 2010 to upload to USPS for bulk mailing

RELEVANCY SCORE 200
Preferred Solution: Export mailing labels from Word into Excel

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Export mailing labels from Word into Excel

Welcome to Windows Seven Forums.

This MS website may help you, but it does seem fairly complicated.

Create and print mailing labels for an address list in Excel - Excel

Read other 3 answers
RELEVANCY SCORE 96.4

Lets say the last time I used 7 labels from my sheet of 30 labels. Now I want to use up the left over 23 labels on my avery label page.

Can I do this in Office 2007? Like somehow start printing at label 8 on the sheet?

Thank You,
Michael D
 

Read other answers
RELEVANCY SCORE 90.8

I have a address book set up in Phone Tools and would like to merge it into Word to create mailing labels. Or I could recreate my address book in Word and make labels from there. I cannot figure out how to do this. Any help would be appreciated.
 

A:Word mailing labels

Hi there.

How to do a mail merge in Word?
Click on the link for Mail Merge at www.theofficeexperts.com/word.htm
 

Read other 3 answers
RELEVANCY SCORE 90.8

Hi,

Does anyone know how to create labels in MS Word. I would need to instantly email or fax it but have know clue how to create the labels in such a way that it can be easly emailed or fax from my pc. I would appreciate it if anyone out there can help me cause I really need to do this asap.

Thanks to all.
 

A:MS Word Mailing Labels

Are you using some special labeling paper? I'm assuming it's a sticky label on one side. There should be instructions on how to do the File>>Page Setup... Then choose your appropriate type of paper. For the labels it should create a large table where you can input the many different addresses.
 

Read other 3 answers
RELEVANCY SCORE 90.8

I am running MS Word 2010. Here is my problem.

Let’s say I type a letter and have the person’s name and address in the letter. On the Word menu bar I select labels. For some reason when the label prints, it is center adjusted and not adjusted to the left like a normal mailing label would be.

Any thoughts on how to fix this.
 

A:Mailing Labels in MS word Help

double check that your left alignment is selected on the home ribbon.
 

Read other 2 answers
RELEVANCY SCORE 90.8

I have a mailing list in excel that I am trying to dump into labels in word by using the mail merge. I can go through the wizard but the data never makes it to the labels, it just leaves me with a blank label grid. I have all the records selected, etc. What am I doing wrong?
 

A:Mailing labels from Excel

I've always used the Avery wizard that comes with some of the MS Office suites(load your disk and look for Extra options in setup), I think you can download it for free here...http://www.avery.com/us/products/demos/wizard/index.html

It integrates with Word and can use Excel lists, I've just always found it easier than the word labels.
 

Read other 3 answers
RELEVANCY SCORE 89.6

I have attempted to create mailing labels using Word 2003. I used a prior Word version several years ago and was able to save the labels as a file--ready to print, not requiring database. Any ideas how to do this with Word 2003?

Thank you for your help,
Brian
 

A:Word 2003 Mailing Labels

Were you doing a mail merge? You can save the lables as a template as long as your data source for the mail merge is consistent.
 

Read other 2 answers
RELEVANCY SCORE 88.8

When trying to create a 30 label sheet from a .wdb file, WORD (Office) says it can't merge from this file. Please verify that this is a valid Works file.
At Open Data Source I call on my .wdb file and am blocked by the above message. I'm using Works Suite 2006 and Word 2003.
I can't get past that point.
 

A:Solved: Mailing labels - from database to word.

Read other 6 answers
RELEVANCY SCORE 85.6

This is a puzzle. I do a standard mail merge to create labels. In word with excel as the database. All goes well until the last step. Then, I get the first label only on each page. All others are blank. Any ideas?
 

Read other answers
RELEVANCY SCORE 84

Dear all,

I am designing a data entry template for a questionnaire survey that will be conducted in eight developing countries. I use SPSS for this, but some of the researchers in these countries do not have SPSS (or at least not for five or so computers on which data entry is done) and will need to use excel. I can easily export the SPSS file to excel, but the coding (‘values lables’ in SPSS, e.g. Gender: 1=Male; 2=Female) is lost. Excel just saves the variable names and data (I can choose whether it saves the label (e.g. male/female) or the number (e.g. 1,2), but I want the data entry template to keep the functionality of entering a code that converts into a label. If this is not possible (or not in Excel 2003, which I am using, I could uprade), does anybody know whether I can manually add such functionality to an excel data entry sheet. I tried with the IF command and with Drop-down lists, but both methods have big disadvantages.

Many thanks in advance. I greatly appreciate your support!

K
 

Read other answers
RELEVANCY SCORE 79.6

Hi, I think I have a new one for you. I've seen this problem posted on other sites and no solutions ever addressed.

I'm mail merging a a mailing list onto sheets of ten labels, a different number of labels every day, anywhere from 30-200. I've used the wizard any number of times, always with the same result, never with an option or menu that provides a fix:
-- 1st sheet looks okay -- records 1-10 appear
-- 2nd sheet, records 2-11 appear
-- 3rd sheet, records 3-12 appear
-- etc, till there are as many sheets as there are records in the database. So for today's mailing list of 45 records, I had 45 sheets instead of 5.

The first label in my template has a header that says "Research Study" followed by the mail merge fields -- custom arranged, not using Address Block or anything preset. The propogated labels all say "<<Next Record>>" in front of "Research Study". I can provide an example if needed.

It also doesn't allow me to choose the order in which the emails propogate, i.e. I can go across but not down. I've done this many times in older versions of Word without these problems. I've used the Avery system, but I have to go thru the wizard each and every time when all I want to do is make a reusable template to copy and merge new records into each day.

Please help.
 

A:Labels-Mail Merge,Word 2003 & Excel 2003-labels repeating ad nauseum

Read other 11 answers
RELEVANCY SCORE 75.2

Hello all,

I have been presented with a project that involves Forms that I am not able
to resolve.

Basically I have been asked to create a document template where other team
members can fill out a form that asks a series of questions, then to have
only the completed form results export to a new file.

I am aware that Word can export the form results to a text file, but when I
do this all of the questions that were on the original form are exported to
the new file.

What we are looking to achieve in the end:
If the end user is faced with 20 questions, but only 12 of the questions
pertain to the end users project, only the 12 completed form fields will
export to a new file.

I know that this should be possible with using a macro button to export the data, but that is where I need the help.

I tried searching for this exact situation, but I did not find any matches, hence the new thread.

Thank you in advance,

Bill
 

A:Macro help needed to export Word form results to a new file... Word/Excel

Read other 11 answers
RELEVANCY SCORE 74.4

Hi
I am trying to export data from word or excel form into a spreadsheet. I have tried the macro at http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html and it worked for all text fields but not the drop down list options that I have in my form. Can anyone please help/

I have never done this before, hence the struggle. Any help would be much appreciated.

I attach the word form and the excel form which also includes the excel spreadsheet that will collate the data for analysis.

I would prefer the form in word and have it set up as that indicated in the forum thread above but picking up the data from the drop down lists as well.

Thanks
LAD786
 

A:Export data from word or excel into Excel spreadsheet

Hi there, welcome to the forum.
It seems this post you added on August 12th hasn't given you much answers.
You mention the two files, OK, But what I don't understand
I am trying to export data from word or excel form into a spreadsheet. ...
Click to expand...

You probably forgot to attach the macro's with it, that is if you did anything with the link you mentioned.
If you could attach the files with the macros, I could take a look and see what I can do for you.

Another thinng From Word or Excel.

Which one is it going to be?
 

Read other 1 answers
RELEVANCY SCORE 74

I am having trouble taking labels and transferring them to an excel sheet. I have tried everything I know and cannot get it to work.

Help!

Thanks!
 

A:Solved: Labels from Word to Excel

Read other 16 answers
RELEVANCY SCORE 74

I have a 2007 word file that i am trying to convert into excel format with the address blocks separated by first name, last name, address, city, state, and zip code. I tried using word mail merge to make an directory but that did not work. Can anyone help me out? I think i need some kind of macro, but i do not know how to use those....

I can email you the file. Just let me know.

Thanks
D
 

A:address labels from word to excel

Hi computerwiz5

Send me a pm and I'll send you my e-mail address and I'll put it into an excel file for you.
 

Read other 1 answers
RELEVANCY SCORE 74

I have an excel file I created of addresses I want to put on labels. I followed the help wizard and got as far as the Mail Merge Recipients dialog box. I'm not sure what they mean by Word identifiers on the left. I have browsed to my excel document and opened the first page (for 3 pages of avery 8160 labels). I don't think I set up my excel sheet correctly. I have columns like this: envelope, family names, last, apartment, Street #1, City, State, Zip. Word's merge must be confused. What I get on the labels is just the last name, city-state-zip. I want the Mr. and Mrs. Name, street address, city, state, zip. How do I get this?

thanks for your help
bhbrown
 

A:labels in word from excel problem

Did you use "address block"? If so, don't!
See if this helps:
http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm
 

Read other 3 answers
RELEVANCY SCORE 73.2

How do I take a list of names and addresses created in Excel, and transfer it into word in the label making format? (running Office 98) I'm trying to make address labels to mail a bunch of stuff out. The addresses are in list format from excel.
 

A:creating labels in Word from Excel list

Read other 9 answers
RELEVANCY SCORE 73.2

Hi,

I am trying to figure out how someone who used to work at the company did the following:

She had all of our file folder names in an Excel Spreadsheet and would then merge them into Word as Labels. How is this done???

Thanks,
Kristy
 

A:Mergine Excel Columns Into Word Labels

http://www.theofficeexperts.com/word.htm#MailMerge
 

Read other 1 answers
RELEVANCY SCORE 72.4

Hi,

I'm trying to mail merge from Excel to Word for some simple address labels. I've always done this previously without a problem. What I now want to do is to add an image to these labels. It's the same image for every person.

The issue I'm having is that if, for example, there are 10 labels to a sheet, and I have 11 names, the first sheet will be great, but the second sheet will just have the 11th name and image on the first label, but will continue to print just the image on every other label.

It merges using a names range in Excel, and I had thought that when it came to the end of the named range, it wouldn't print any more pictures for the remaining blank labels. I have tried using INCLUDEPICTURE and storing the filename in the named range, and did have a bodge at using IF (but couldn't quite get that to work), but this seems to make no difference.

Here's my Mail Merge code:

{ INCLUDEPICTURE "../{ MERGEFIELD Image }.jpg" \* MERGEFORMAT \d }
{ADDRESSBLOCK \f "<<_FURST0_>><<_LAST0>><<_SUFFIX0__>><<_COMPANY_>><<_STREET1_>><<_STREET2_>><<_CITY_>><<_STATE_>><<_POSTAL_>><<_COUNTRY_>>" \l 2057 \c 2 \e "United Kingdom" \d }

So as I said, this does work, and gives me an image with the name and address below, but it's just the problem of the image being repeated onto the blank labels at the end of the last sheet th... Read more

Read other answers
RELEVANCY SCORE 72.4

Anyone have any idea how to export a microsoft word document that consists of several tables to an excel spreadsheet? I heard that you can do it but I have no idea how.
 

A:How to export word doc to excel

I thought Word had a direct export feature, but I just tried it and can't find it... The easiest way might be to just copy them from one to another, which will work. Try this:
In Microsoft Word, select the rows and columns of the table you want to copy.
If you want to select the entire table, click the table, point to Select on the Table menu, and then click Table.

Click Copy on the Standard toolbar.
Switch to your Microsoft Excel worksheet.
Click in the upper-left corner of the worksheet area where you want to paste the table.
Cells from the copied table replace any existing cells in the area.

Click Paste .
To adjust the formatting, click Paste Options next to the data, and then click Match Destination Formatting to use any formatting that was previously applied to the Excel cells, or Keep Source Formatting to match the formatting of the Word table as closely as possible.
Note that Excel pastes the contents of each cell in the Word table to a separate Excel cell. If you want to split the data in the cells further, for example to divide first and last names so they're in separate cells, use the Text to Columns command on the Data menu.
 

Read other 2 answers
RELEVANCY SCORE 72.4

Hello there!

I have browsed the previous requests on this topic and while I follow what is going on I don't feel like I am fully grasping it as I do not have all the info. I am currently working on my first export project. I hope you may be able to help me with my extremely simple need. I know that if I follow it once in my own work it will click.

I certainly welcome any suggestions you may have for any portion of my project. I have a simple Word Form for supervisor to fill out after reviewing PM work packets. She will enter the info and then save the file as a Word doc to a shared folder. I would like to be able to take those saved Word docs, save them as .txt and export info into a simple worksheet. I have attached both documents here.

I thank you for your help!
 

A:Another Export Q re: Word to Excel

Read other 6 answers
RELEVANCY SCORE 71.6

I am using Windows XP, Excel and Word. My address list is in Excel. I start out in Word, selecting the mail merge option and go through the sequence to mail merge labels, when I select PREVIEW the labels, they are completely blank. At the step that shows the labels in which I select which names are going to be used, everything seems normal. But the next step of PREVIEW reveals that the labels are blank. My excel list is in the same format of every other list I have every used to print labels, ie it has Last Name, First Name, Street number, Street name, City, State, Zip. All on one line. I don't know what is wrong. Help!
 

A:Mail Merge problem with labels Excel to Word in Windows XP

In step 4 of 6, "Arrange your labels," you should be able to type an X (or any other character for that matter) in the first label, click the "Update all labels" button, then see the X in each label at step 5 of 6, "Preview your labels." If you can't do that, then perhaps something in Word 2003 is broken. Visit this site for instructions on how to do a repair:
http://support.microsoft.com/kb/821593
 

Read other 3 answers
RELEVANCY SCORE 71.6

Does anyone know how to (if it's even possible) to import data into Excel (into proper fields - name, address, city etc.) from a Word mailing label template? I'm using Office XP and have a large Word file I would like to get to Excel...

Thanks!
 

A:Word/Excel Import/Export

Read other 16 answers
RELEVANCY SCORE 71.2

I WASN'T FINISHED YET! I want to be able to print Avery labels from information I've input. Is this already in this program? If not, how do I format the labels? (Obviously, from this message, I am a computer infant!).
Thanks!
 

A:Mailing labels

What do you mean "I wasn't finished yet"?

Where is the information?
Can you describe how you typed it?
 

Read other 2 answers
RELEVANCY SCORE 70.8

Running WinXP and Office 2003

Hello. My question is same as http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html

Thanks to Rollin_Again's script, I have managed to export the Word form data perfectly into the Excel. However, as I close the Excel, reopens it and re-run the macro, the new data will somehow overwrite the last row of the previous batch of data.

Example:
Batch 1: 9 cases successfully exported from Word to Excel Row #2-10
Batch 2: 5 cases successfully exported from Word to Excel Row #10-14 (Row #10's previous data is overwritten by Batch 2's data...)

Have I missed anything? Can anyone help please? Thanks a lot!
 

A:Solved: Export Word Form to Excel

Read other 11 answers
RELEVANCY SCORE 70.8

I edit in Microsoft Word (MS Word 2010) on Windows 7, using the outline view. How can I paste/import into MS Excel 2010 so that each level of indenting in MS Word, is indented into a new column in Excel? i.e. MS Word Level 1 items show up on MS Excel Column A, MS Word Level 2 items show up on MS Excel Column B, etc.
 

Read other answers
RELEVANCY SCORE 70.4

I have some old Maco M-5351 copier labels I want to use in my desk printer but Act does not give Maco options for labels. I tried setting up custom labels but that didn't work. Anyone have any ideas, or should I just order the Avery labels I normally use?
 

A:Act 2000 Mailing Labels

Hiya

Whats the name and version of the printer you're using?

May do some delving into it, to see if there is a way

Regards

eddie
 

Read other 2 answers
RELEVANCY SCORE 70.4

we have created a wordpro mailing label file listing multiple addresses - we would like to delete an address - but when we do, it creates a blank space, instead of filling in the space with the next address in the file - is there some way to close the open gaps???
 

Read other answers
RELEVANCY SCORE 70.4

I am trying to create mailing labels with clip art on them.
After inserting the clip art I try formatting it (tight text), when I apply this the clip art disappears off my label. Does vista not have the capibility to do this. I have done it on xp and on a lap top with vista home/student words. I do not want to create mail merge this is only for a few labels. I don't understand what is going on.
 

A:Solved: Mailing Labels

Vista does NOT not do word processing, and neither did any of versions of Windows. That said, what PROGRAM are you trying to do this with?
 

Read other 1 answers
RELEVANCY SCORE 70.4

Whilst generating mass mailing labels for my Christmas Cards in Word 2007, when I click on Update Labels, the Address Block only appears on the top two and bottom two labels of each sheet. The labels are Avery L7163, 14 to an A4 page. I'm using Windows 7 and Word 2007.
 

A:Mass Mailing Labels

I've sorted this problem by using my daughter's Mac Book which worked perfectly! Either there's a glitch on my computer or in Word 2007 that stops the mass label print working with Windows 7. Hey-ho!
 

Read other 1 answers
RELEVANCY SCORE 70

I have been given a last minute assignment to create a survey to send to a few end users and I want to compile the data of all the forms I receive into one excel workbook. I tried a few macros, but they aren't 2010 macros and so I am running into issues; I just don't have to time to re-write and could use a little assistance. I think the main difference is that I am using radio buttons instead of text fields.

ALSO I want to automate the entire thing. Meaning I want to open the workbook and run the macro to pull unprocessed forms from one folder, scan for data, import data, and then move them to another folder for archiving.

Also, in my form I don't think I made the comments section into a text field; I am sure I am going to have to correct that in order to capture the data... Right now I am too tired to think on it. At the end of each section I there is a comments field and I want to collect that data onto different sheets in the workbook. I already labeled the sheets.

I have attached the drafts for reference; I only shortened it for upload; the original draft has about 30 questions total. I need to get this done by 1/15/15 so that I have time to receive and compile data by 1/20/15.

Please help!
 

A:Export Word Form Data into Excel Workbook

Read other 7 answers
RELEVANCY SCORE 70

I'd like to create a macro which creates a new MS Word document in the same directory as the excel book which copies specific data from an excel worksheet into the new document. The items contained within the cells should appear as a bulleted list on the word document, not a table.

Is this possible?
 

A:Macro to Export Excel Data to New Word Documet

I'm not a Word macro person at all..But I'm thinking (quick and dirty) you could do this with mail merge. Don't use the address part just 'insert merged' fields...Your 'cells' would have to be in the same row in excel.

There are also excel to word conversion programs(google). I have never used one. If your data was in Access a 'Report' would suit your needs. Also a script that reads the excel file and writes to file and saves as .doc might do this also.

Going to word 'for the sake of being in Word' seems counter productive but management wants what management wants.
 

Read other 1 answers
RELEVANCY SCORE 69.6

I have Peachtree Complete Accounting Release 8.0. I created a custom 2-up customer mailing label list using the Design Form. It works fine EXCEPT that the bottom 4 rows of labels always print in multiples. That is, the top several rows will print fine and then, customer XYZ will print over and over on the next 4 rows of labels. I can't see any reason for this. Any ideas?
 

A:Peachtree Customer Mailing Labels

I have never used Peachtree Complete Accounting Release 8.0 so unfortunately i am unable to help you there. I use to print address labels through word and excel but now i just use a british labels company to print my address labels.
 

Read other 1 answers
RELEVANCY SCORE 69.6

base file? I'm using ver 6.0 and need to know how to create mailing labels....if possible.
Thanks in advance.
 

A:Mailing labels from a MS Works data

I use to use word and excel for printing address labels, i did face a few problems with getting the text on the labels to print within the margains. I found some templates which i downloaded which helped me have decent looking labels. However, i didn't really have the time for printing out address labels every night so in the end i decided to get a british labels company to print my address labels out.
 

Read other 1 answers
RELEVANCY SCORE 69.6

When I print mailing labels in Office 97 I am given the choice of which label on which to print by row and column.
However, no matter which row and column I choose it always prints row1/colomn1.
I am using the Mailing Label Wizard, I have WinME, and my computer has plenty of horse power.
Any ideas?
 

A:(solved) Office97: Mailing Labels

Read other 16 answers
RELEVANCY SCORE 69.6

Following a computer crash recently, the only data base now available with appropriate address information is Windows Address Book. This is a .wab file. Using either MS Works 2007 or MS Word 2002, I am unable to merge this data base to produce mailing labels. The .wab file is located in Application Data\Microsoft\Address Book\"my name".wab. When I try to get Word to use this Address Book for the data base in mailmerge, it brings up a small screen with a bunch of gobble de gook. Trying various other interpreters changes the gooble de gook occassionaly but never produces text suitable for the address labels. I have been unable to find a way to convert the .wab file to a readable data base file.
 

Read other answers
RELEVANCY SCORE 69.6

People,

I have to send out form letters to about 50 contractors on my community's vendor list.

First, I created the form letter in Word (2000.)

Then, I opened Address Book, created a sub-folder under Main Identity's Contacts; & entered in Company names & addresses as new contacts for every contractor.

Now...all I want to do is create mailing labels for all the various companies.

How in the heck is this done?

I started down the mail merge path, but got extremely lost.

Thanks,

mark4man
 

A:Mailing Labels from Address Book?

Read other 7 answers
RELEVANCY SCORE 69.6

I am trying to print some mailing labels using Word. To do that, I have to use the Mail Merge function. My data source is a list of addresses in a Word document in the following format:

XYZ
123 Main
Anytown, MO 12345
Attn: So and So

I'm trying to print to Avery labels 8160 which has 30 labels to a sheet. Each label is supposed to be a different address.

I follow the instructions in Word's help file. When I get to the step where it asks me for the data source, I select to open my Word document as the data source. A box opens with three windows in it. The first is field delimiter, the second record delimiter, the third contains my list of addresses from my data source. I'm not sure what to put for the delimiters so I leave them as they are--field delimiter: none, record delimiter: enter. I tried other combinations like tab for the field delimiter but it doesn't seem to make a difference. I click on OK. I get another box to set up main document. I do that. Then the next step is a box titled Create Labels. Here I choose Insert Merge Field. A drop down appears. Only the first line of the first address appears. I select it & click OK. Then I set up the main document. The final step is to click Merge Labels With The Document.

Here's the problem: When I click Merge, I end up with two documents. The first document has the first line of the first address printed on all the labels. In other words just the name of the place I'm mailing to that appear... Read more

A:Trouble Making Mailing Labels

do you have the Avery "Wizard" installed? it ussually comes with the office suite (depending on version) Look on the tool bar for a red triangle shape with lines, or check to make sure it is on you tool bar....View/Toolbars...check off Avery Wizard (if there).

I like using it for labels, you can import from Excel, look for the Steps to "use existing list or database file"
 

Read other 2 answers
RELEVANCY SCORE 69.2

I hope someone can help me out with this. I have a summary page in an excel quote workbook and I have designated cells for contact information of our bidders (name, co., phone, fax, price etc..) and I currently do a mail merge in word for all the contacts. It would be a lot easier if I could just export all the information in my excel to my cover letters. The cover letters all have the same format with contact info up top, and a basic paragraph, but they all have to be on separate pages. I wasn't sure if there was any way I could do this with word fields or what. Any help would be appreciated. I'm not completely lost with this stuff but I have no idea where to start. Thanks!
 

A:Export excel contact fields to word cover letters

Read other 9 answers
RELEVANCY SCORE 68.8

Hi, I have a one page word document of the same label that I need to be a form. I don't want the users to have to fill in each label and since the whole page will be the same, I want to create the first cell to be fillable and the rest of the cells to automatically fill with the same information. Can this be done? I know it's not the same as MS Excel using formulas.

Any help would be appreciated!

Read other answers
RELEVANCY SCORE 68.4

I hope the title isn't too long, this is my first time posting ...

My auction site is really starting to take off, and my handwritten inventory list isn't cutting it anymore. I have created an Excel doc with all of the relevant subject columns, and have started filling in the info.

I would LOVE to be able to export, or populate, a whole row of info (the product) into a Word Template. I have seen some examples (macros) online that seem to be what I need, but they fall short or just don't run correctly. I suspect that my mac might be running macros differently than a windows machine? Also, some of the macros I've come across are from 4 years ago, and I am running the latest version of Office (2011 = Word and Excel 14) and the latest Mac operating system (snow leopard 10.6) ...

Ideally I would like the Word doc to read in plain english, not be a an excel row regurgitated into another data sheet. For instance, if I have entered in "excellent" (regarding the items condition) into a cell in my in my "inventory" spreadsheet, I would like the export to read: This item is in excellent condition. I assume I can type a "form" sentence into a Word doc &#8211; this item is in BLANK condition &#8211; and have the BLANK be autofilled.

However, this might be too advanced, and I might want to start with just regurgitating the spreadsheet row data into a "product spec" sheet.

Here is one example that partly worked, howe... Read more

Read other answers
RELEVANCY SCORE 68

I exported files from access to excel, after formatting i opened word2010 and attempted to merge mailing labels from from excel. after choosing the file I wanted to merge and clicking finish and merge I got an "invalid feilds" box. Our systems have recently been updated from xp to windows 7 and the fields are no longer matched. I manually matched the fields and clicked the option to "remember" the fields, but they don't apply and are "forgotten" so to speak. Please help, I needed these labels two days ago
 

A:Solved: Getting an Invalid Fields box when trying to print mailing labels

Welcome to TSG,
I would simply do a new mail merge from the beginning and not use the (saved) one that is giving you problems. That will be easier than trouble shooting this one.
 

Read other 3 answers
RELEVANCY SCORE 68

My fiance and I are trying to print some address labels for our wedding invitations but we are unsure of what to do. We can type them up in Word, Excel or whatever and put them into a label type format so we can print them up.

What's confusing to us is that we can't figure out how to make the labels print different address on each label.

Fortunately for me I have all of my addresses already stored in my Windows Mail. I could just copy and paste them into whatever someone can recommend to me.

I'm very new to Office and Office 2007. We can import or type them up, but we need we just need to know how to start and what to do?

Any ideas?
 

A:How to print mailing labels in Vista with Office 2007?

Hi Imola,

There is a good feature in Word called (Mail Merge) you can easily have all your contats stored in an excel file or outlook contacts (not sure about windows mail but you can export them to excel if it doesn't work)

In word 07, click the (Mailing) tab, choose (Lables) and choose the type of your lables,(select recipients), (insert Merge fields) Edit as necesart and print. It should be an easy step by step procedure
 

Read other 1 answers
RELEVANCY SCORE 65.2

I am using the mail merge wizard in Word 2003 to create address mailing labels from a mailing list I saved in an Excel 2003 worksheet.

Everything is fine, I've tested is several times. But there's one very aggravating little problem.

The labels are all created with a space in front of the first line (name) on each and every label.

I want them to look like this:

John Smith
123 Main Street
Charlottesville, VA 22901

But instead they all look like this (the underscore I typed in is actually just a blank space):

_John Smith
123 Main Street
Charlottesville, VA 22901

I've tried everything I can think of.

The spreadsheet cells for names do not have an extra space in them before the names. I have one column in the spreadsheet called Name that has the entire name of the person I want to appear on the first line, so I'm not using separate values for first name and last name, it's just one: Name.

Please advise. Thanks so much!
 

A:Labels-Mail Merge,Word 2003 & Excel 2003-space at beg.of 1st line

Yup. It's a PITA. You need to NOT use the Address Block. Instead, insert the individual fields. See this article:
http://www.officearticles.com/word/insert_merge_fields_in_microsoft_word.htm
 

Read other 3 answers
RELEVANCY SCORE 56.8

Im wondering if it is possible to do this before i start trying...

I recieve an email containing an excel sheet containing several peices of info such as:
Name
Surname
ID
Etc Etc... Now when i open this.. i need the information posted into specified columns in a new excel document where it will have
NAME | SURNAME | ID |
-------------------------------------------
STEVE NORTH 01874
Any help given appreciated.
 

A:Excel - Auto export data into specified excel sheet

Read other 6 answers
RELEVANCY SCORE 56.8

I tried sending an e-mail in Microsoft word with the e-mail icon on the quick toolbar, couldn't send it and couldn't close Word. I got this message:
"This error can occur if you try to send a Word document by using the Email ( Microsoft Office Button | Send command) command. If Word hangs, or you closed Word and a new message dialog does not appear, it is possible that Outlook did not receive the request to start a new message.
To avoid this issue, restart Word and attempt to send the attachment again, but wait for Outlook to respond prior to attempting another action.
You cannot close Microsoft Office Word until the Send Mail Command is finished. Switch to the New Message first, and either send or close the message". I had to manully close down my computer, then restart it. I can use all my programs but everything is different, and Outlook background is grayed out.
Can you tell me how I can correct this problem?
Thanks
 

A:E-mailing using Microsoft Word

Read other 8 answers