Tech Problem Aggregator

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

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

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:

3 more replies
Answer Match 133.2%

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

11 more replies
Answer Match 106.5%

Hi folks ... I am trying to get my holiday letter labels printed and the Word 2003 Mail Merge is driving me crazy! I am running Windows XP and using my contacts from Outlook 2003. I get all the way through the merge process, everything looks perfect, and then all I get is one page printed out of what should be 6 - 7 pages of labels. Help!

A:Printing Labels from Word 2003 Mail Merge

Sounds to me like you're using the VIEW button to see the merge results. You need to go ahead and DO the merge. See the steps here:

Pay particular attention to the Propogate Labels button.

2 more replies
Answer Match 105.6%


help with this would be very appreciated.

We run windows xp, word 2003 and excel 2003

we have created a mail-merge between our database of patients in excel and word, but when we come to the section where we tick the boxes next to the people required for the mail-merge we can select only 1 or 2 or 100, but when the mail-merge goes to the next section it has reverted to selecting the whole database of patients, which when your trying the send a letter to only a few people and it instead tries to print 5000+ letters is annoying to say the least.

i have tried changing the database to running from access, and i have started fresh and re done the mail-merge letter but this is all to no avail as the same error occurs???

any ideas,
please help

A:Mail merge problem using excel 2003 and word 2003

There may be some bad data within the columns that may be causing your issue. Look to see if there something out of the ordinary within the dataset you are trying to use for the mail merge. I think one may be column headings with spaces in them and another may be where two or more rows may have meen merged in your spreadsheet.

1 more replies
Answer Match 105.6%

Hi - just looking for some help as getting a bit annoyed cos it's not working

I've got a table which contains people's details.

What I'm trying to do is if the person has no date of birth on file (i.e. they are over 18 year of age) for the merge to put a tick into a column, but if the person has a date of birth on file (i.e. under 18 years of age) for the merge to leave the column blank.

The column after this will contain the date of birth (if any).

In the over 18 box I've put the following function:

As each form will contain anything from 1 to 8 records, the lines which wouln't contain any merged data (i.e. if only 4 names to merge into a form, the last 4 rows of the form would be blank) - but it keeps merging in a ticked box for all the rows, even if there is only one row of data.

Hope this makes sense.

Thanks in advance for any help/advice.

A:Mail Merge - Help with Word 2003 & Excel 2003 using IFstatements

This does not sound like a merge function, it sounds like you are just validating data in a cell and based on that cells content putting a check in a check box.

3 more replies
Answer Match 96.3%

When I create a mail merge to merge number into a letter, the numbers show up with 14 decimal places. I am not trying to input money or any other number format into my letter, just simple two digit number. The number should look like 4.16., but looks like this: 4.1699999999999999.

I've tried changing the format in Excel, but no luck.

Any suggestions?

More replies
Answer Match 96%

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?

More replies
Answer Match 92.7%

I am making up mailing labels using Excel 2003 and Word 2003 on XP computer. As I go through the set up I noted that when you select a field and hit a space or return all it does is add the same information again.
I have had to enter all the data in a row and then edit by adding spaces and returns to make the label come out correct.
Seems there must be a better way than this. Office 2000 had a very good system.
What if anything can I do the make this work right.
HP 2.66 Ghz CPU 512 RAM

More replies
Answer Match 89.1%

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:

3 more replies
Answer Match 83.7%

I work for a management company, so we use Office 2003 (Basic Edition) for a whole bunch of stuff. My question has to do with the Mail Merge option in MS Word. I type all the leases for my company, so being able to use the Mail Merge would be awesome. I am not very computer literate, and was wondering if anyone knows a good site for a tutorial, or if they know how to use the Mail Merge option. Any help would be greatly appreciated. Thanks a lot.

A:Help With Word 2003 Mail Merge

Check the Microsoft Office website: Use mail merge for mass mailings and more.

1 more replies
Answer Match 83.7%

I have a list of records that will be merged from either an Excel worksheet or an Access database. The ID Number field repeats for multiple records but I would like the merged document to show the ID field once but list all records with that ID as on the same document page(s). When the ID number changes, then the next group of records are merged under that ID. Can this be done?

A:Mail Merge in Word 2003

Sorry, but this is a huge shortcoming of Word.

1 more replies
Answer Match 83.1%

I finally got something to print on the labels. But it is all the mergefield jargon. Street number, etc. Not the actual information that I see on print preview. Can anyone either point me in the direction of an exact "how to" for this merge of labels for a mailing list including all the tricks for the problems existing in word 2003. Would love to go to sleep something tonight. Thanks.

A:Label Merge from Excel to Word 2003

Mail merge labels:

Mail merge issues:

Also, if you're still seeing mail merge fields, try Alt+F9 to STOP viewing field codes. This *could* be a problem you're having. See:

1 more replies
Answer Match 82.8%

How in the world can I save a mail merge data source in Word 2003 as a .doc file? Thanks.


A:Word 2003 mail merge question

7 more replies
Answer Match 82.8%

Hi, I am doing a mail merge for labels for Christmas cards. I am trying to
insert a graphic but I want the address that I have typed to be centred
within the graphic. At the moment, when I do this, the text jumps up to the
top of the graphic and if I try and cut/paste it wont work. If I press
enter, the entire document moves down. What I'm after is the actual clipart image to be in the foreground and the text to be centred in the foreground. Could someone possibly explain how exactly this can be done please?


A:Word 2003 - mail merge and graphics...


I've moved this to Business Applications forum for more response



2 more replies
Answer Match 82.8%

I completed a mail merge using 2003 & creating a list -- If I wanted to print just the list of names & address database associated with the merge letter -- how do I do that?? It looks to be a .mdb extention, but I can't seem to locate it on it's own!!

For the life of me, I can't figure it out! I think I preferred the old mail merge - when you had to create two seperate files! Seemed less confusing somehow!

A:Mail Merge (Word 2003) name list

A .mdb is an access file. Do a search and then use access to open it.

That should work out for you.

1 more replies
Answer Match 82.8%

I am trying to do a mail merge for address labels in word 2003 on my xp. The steps seem to make sense, but it never works! I am ok up until the address block. All of the addresses don't appear. It just says address block or just the first address on my data source. Thanks for your help.

A:Mail merge in Word 2003-Windows XP

When you get to the point where you insert the address block. Are you clicking the Update All Labels button. That will update all the lables with the address block and you will see all your addresses.

If you are using the task pane to do the merge it is on step 5 I think.
Let me know if that helps

1 more replies
Answer Match 82.8%

My company does utility billing. We generate over 30,000 bills a month. We have a set way of doing things, and I am having a problem. Until recently we used office 2000 to create our mail merge bills. Everything was smooth. We upgraded to 2003, and I have been troubleshooting issues ever since. We get our data from Lotus 9 spreadsheets. That data is currently saved as a .CSV file and then sorted from there. We then merge our .CSV file into a Word doc (bill form). The problem is sometimes we get errors like "Record "so and so" has too many/few data fields". I know what is causing this, empty rows or columns in the .CSV file. These can not be avoided. Is there a way to edit the registry to eliminate these messages, they are time consuming when printing. Or do you know of another fix? Thank you for your time.

A:Word 2003 Mail Merge Error

Welcome to the forum.

Within MS Word. I would just search for the double return which is what will be displaying the space in-between the rows and replace it with a single return.

1 more replies
Answer Match 82.8%

Windows XP Professional Service Pack 1 with office 2002 plus Outlook 2003 installed, Exchange 2003 is being used as the e-mail server.

When I do a mail merge from Word 2002 to e-mail for a mass e-mailing in Outlook 2003. The process completes but there are no e-mails sent from Outlook 2003. The e-mails that were merged are never recieved by the recipents that are being set to. Help.

More replies
Answer Match 82.5%

I am doing a mail merge with Word2003 - the database info is in an Excel 2003 spreadsheet. The mail merge works just like it always has - UNTIL I get to the last step - Update All Labels. At that point only the first three labels and the LAST two labels on the first page and miscellaneous labels on the next page are populated with information. I do not have this problem on my desktop but I do on my laptop and others have been experiencing the same problem. 11.6359.6360 SP1 is the version of my Word2003 and 11.6355.6360 SP1 is the version of Excel2003. Thanks-Char Gorak

A:Mail Merge Problems with Excel 2003

Closing duplicate, please reply here:


1 more replies
Answer Match 81.9%

HI folks...

I have an issue where Word 2003 Mail Merge is skipping records once the document is merged and printed. The Merge document is a simple "voucher" (4 to a landscape page) with the user name and section being pulled from similarly headed columns in the data source document. Im using a simple (4 column) Excel data source with about 250 records.

When i merge and preview all records, every 5th record is skipped. When i got into the data source and view/edir records, i can see the skipped records and they are selected etc etc...even if i change the sort order in the data document, its still every 5th record that is skipped.

Ive tried using both an excel data source doc and recreated it ihn Word 2003, but i stillg et the same bad result.

Any ideas, or is this as clear as mud to you?


A:Word 2003 Mail Merge - skipping records

It looks like you have a <next record> field at the end of the printing page, so the next record is skipped.

So it prints 4, then sees the <next record> and skips that one then gets the next 4 etc.

2 more replies
Answer Match 81.3%

I am running a large survey for which I set up a Word 2003 file in order to match survey responses to the questions. The survey responses download in Excel 2003 format. I can locate the data source each time, but the records refuse to match up. There are nearly 200 entries in the survey -- some of the response fields are blank, but they still exist -- so going through and attaching each record becomes very confusing. I use the mail merge function and select a new data source, but just before the merge runs I get a window that says, "Invalid Merge Field, This merge field is used in the main document, but it does not exist in the data source." This is not true, of course, but from this point on, I have to connect every single merge field again. I can't figure out what is happening or how to fix this issue. Thanks.

More replies
Answer Match 81%

I have consistently had a problem with the Find Entry icon not working. It may find an entry once then quit working, I have to search for the entry using the arrow keys to scroll through the entrys of the mail merge. What can I do to make the find entry work properly.
I am using Word 2003 on a hosted network using XP. Hope someone can help me.
Thanks for your time, Mark Strohmeyer

A:Word 2003 Mail Merge Find Entry not working

9 more replies
Answer Match 81%

Have been using the same three mail merge files in one folder for 2 years.

Yesterday I decided to delete some of the records that were no longer needed.

After doing is I added some new records and tried to print the sticker forms that we use for Service Agreements.

Stick form file would not load and I received an error message saying ........***..... is a mail merge main document. Word cannot find its data source.

No file names were changed and no locations for files have changed.

How did this happen when I only deleted some old records?

How do I recover from this?

I know nothing about mail merge and am using a system set up my a former employee

Please help. I still have all my data but can not print sticker forms!!

I ever made a copy of the files in the folder before deleting the old record and saved it to my flash drive calling the folder "Old".

It will not run properly ever when I try using the old files.

Do I need to move them into my documents were the other folders is???

Thanks in advance for any help.

A:Mail Merge in Word 2003 can not find data source

6 more replies
Answer Match 81%

This fixes the problem of having word show an empty address book from Outlook Contact folder when doing a mail/merge in Word.

1. I went to Outlook, clicked on Tools, then Email Accounts, then View or Change Existing Directories or Address Books

2. I then highlighted Outlook Address Book and clicked on Change

3. I then removed each address book listed, clicked on close, clicked on finish.

4. I then went to each Contacts Folder and right mouse clicked and selected the Properties option.

5. I then clicked on the Outlook Address Book tab

6. I put a check mark in the "Show this folder as an email address book"

Prior to all this each contact folder already had this checked. So God only knows why this issue existed but it did.

After doing these 6 steps I went to do a mail merge in word and selected the Contact Folder that had been showing up empty before. It no longer was empty.

A:Solved: Issue with Word mail merge with Outlook 2003

Just a tip: if you want to mark a thread solved, use the Thread Tools at the top of the page instead of double-posting and changing the title. Go ahead and mark your original thread solved, a mod will probably delete this one.

Glad you got your problem sorted.


2 more replies
Answer Match 108.78%

I want to merge 1 record from Access 2003 to Word 2003. After trying everything, I finally was able to get a process working where I opened Word and then ran a Word macro to run the merge, passing . However, it stopped working, and I can't figure out why. I haven't changed anything.

The problem is the same one that all the other attempts run into - Word 2003 won't let me connect to the database when the merge file is opened, if a record is open in Access.

I tried having my code in Access close the form, but that didn't work. However, if I manually close all the forms, so only the database window is open, then I can open the merge form manually in Word without any problem.

When I run the macro, Word askes me to connect to the database, then bombs out, saying it is locked or Admin hasn't given permission.

Anyone know a way to get Access to merge to Word?

A:Merge Access 2003 to Word 2003

Have you change from XP to Vista or a later version of Windows? OS security changed the way things behave in the newer Windows operating systems.

Connecting to an open file isn't the best practice anyway. Forms are often linked to tables which is probably why closing the forms works for you. A possible solution, if its important to keep the database open, is to make a copy of the table thats desired for the merge and update the copy as needed.

2 more replies
Answer Match 105.42%

I am doing a mail merge with an name list from Excel. I want the labels to appear vertically and horizontally centered. How do I cause the formatting changes I made to the first label to apply to all in the main document? I know I did this some time back on another project but I cant remember how? Any help please? Thanks.

A:Formatting labels for mail merge in Word 2000

I just copy the contents of the first label and paste into all the other cells.

2 more replies
Answer Match 105.42%

I am having a problem in getting a successful mail merge to print some
labels usng Excel as a data source on a 3 column, 10 row sheet under Office
2007/Vista. (Avery 8160 labels)
When doing the merge, only the first row of labels gets completed.
I have used the same Excel data under XP without problem.
I have tried doing it manually and using the 'wizard' but have failed
miserably - any thoughts please as to whether its me or a glitch somewhere?
(The Excel sheet and mail merge works well on my
laptop under XP Pro and
Office XP)
From what I have read this is common. Any hints on how to fix this issue?

A:Mail merge (word 2007) will not do labels correctly.

Have EXACTLY the same problem.

Strangely, it happens only on my desktop, but not on the laptop w/c has the same configuration.

Don't understand this as a year ago, it was working perfectly well.

Labels are Avery 5160. 3 columns, just like above, and it only prints the first row, and then arbitrarily some records scattered through the rest of the merge.


2 more replies
Answer Match 104.58%

I've been trying for an hour to make labels to print out and stick on envelopes. I tried to use Mail Merge in Word 2000 for the very first time, but I'm doing something wrong. I really don't understand how it works. I've got a normal Word document with addresses, one address underneath the other with an empty line separating them. When I try to create the labels, a box pops up saying something about a field delimiter and record delimiter. Can anyone help me and tell me how to create my labels properly? Thank you in advance for your time.

A:Solved: Creating labels with mail merge in MS Word 2000:help, I don't get it!

16 more replies
Answer Match 102.48%

I have a number of standard letters which require a dropdown box to be populated with a list of over 25 names.

When thinking this through, I figured that it would be best (due to restrictions on the network so I'm unable to use an access database) to produce this list in Excel 2003. Along with corresponding lists of email and telephone numbers.

Unfortunately I'm finding it very difficult to get the information onto the dropdown.

So far the code I have is:
Private Sub UserForm_Click()

'Define Variables
Dim xlNames As Excel.Workbook
Dim rsNames As Recordset
Dim cmbNames As ComboBox
Dim i As Integer
Dim SocServs As Worksheet

'open the spreadsheet to access the information
Set xlNames = Excel.Workbooks.Open("C:\Documents and Settings\00772367\My Documents\SocServs.xls")
'set up and activate the appropriate worksheet
Set SocServs = xlNames.Application.Sheets("SocServs")

'retrieve the information from the named column in the spreadsheet
Set rsNames = SocServs.Columns(1, 1)
i = 0

With rsNames
' This code populates the combo box with the values
' in the Names column of that there spreadsheet (I fervently hope).

Do Until .EOF
cmbNames.AddItem (i)
cmbNames.Column(0, i) = .Fields("Names")
i = i + 1

End With
End Sub
There's a few errors in there, which I can't seem to surmount. The coding doesn't seem to recognise the fact that I've got a named range in t... Read more

A:Populate a dropdown box in Word 2003 from a list in Excel 2003

Is there any particular reason why you are needing to do this using VBA? You can populate a cell with your multiple choice options using Excel's built in Data Validation feature. Simply select the cell you want the options to appear in and click DATA --> VALIDATION and then select "ALLOW LIST" from the options. Then select the range of cells that contains your list of names.


2 more replies
Answer Match 102.48%

Problem creating address labels in mail merge. Excel 2007 >Word 2007
Avery 5160.

Everything works good until I preview labels. Many of the labels are left blank. causing a whole lot of wasting labels!
in some cases the merge was filling randomly. I thought it was caused by cells that were hidden, but it still happened after i deleted all of those.

can anyone help my sanity and help me stop wasting all this label paper?


A:Solved: How to Remove blank address labels in mail merge. Word 2007

well i realized after i continued through the printing process, it eliminated the problem.

1 more replies
Answer Match 100.38%

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,

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.

2 more replies
Answer Match 100.38%

I need to print multiple sheets of the same labels in WORD. How can I do that?

A:WORD 2003 Printing Labels

Tools - Letters and Mailings - Envelopeds and Labels - Labels tab - Type what you want on the label, select below it "Full page of the same label" - Print.

Make sure in Options you have the right labels set to match those you are printing on.

2 more replies
Answer Match 99.54%


I have created a 130 page report in MS Word that consists of figures and tables created in and linked from MS Excel. The idea is that this will be an annual document that will be updated on a regular basis. When updating, people would simply make the changes in the excel file and the Word file would automatically update. This was the plan...

The problem is when I try to update the links only about the first 60 pages update. After that I get this error " Error! Not a valid link". While I can maually update this by selecting the message and clicking F9, the size of the table has changed and the font changes from Arial to Times New Roman.

Any idea of how I can fix this. I spent about a week designing this and making sure all tables and figures fit nicely on the page.

Thanks for any and all help.

More replies
Answer Match 99.54%

I'm importing a large Excel file of addresses into Word (2003).
When I select #5160 Address Labels from the Label Options popup box, the label template is added to my Word document -- BUT only the first 9 rows of labels fit on page 1 of the doc. The last row drops down to a new page.

I really need all 10 rows on a single sheet.
Am I doing something wrong?

Thanks much,

A:Word 2003 MailMerge labels don't fit on one page

Make sure there is not a hard return above the table.

2 more replies
Answer Match 99.54%


I bought a pack of address labels 3 columns by 7 rows per A4 sheet.

As it's a brand Microsoft have never heard of there is no preset label format.

I have carefully measured pitch, width, height etc but when I print a full sheet of labels it goes across 2 pages! It never used to! lol

I take it it's nothing to do with Page Setup as surely that's what I have specified?

It's driving me mad - what can I do?

A:Solved: Labels Nightmare in Word 2003

Fixed it!

I had been messing with and had left tabs et al in there.

Sorted out and it works

1 more replies
Answer Match 99.54%

We have Win7 desktops using Office 2003 professional or standard. Doing a mailmerge of addresses into a label format is producing an odd error. After going through all of the steps to select the database (Excel 2003) file and creating the first Address Block, we click UPDATE LABELS and it is only updating the top two and the bottom two of an Avery 5961 sheet of labels. All of the labels between the top and bottom rows say <Next Record> with no <Address Block>. I simply cannot figure out why this is happening.
We also use Office 2003 Standard on the corporate network by logging into a Citrix session, where it works just fine in a mailmerge. Any ideas on what could be causing this, and how I can fix this???

Thank you!

More replies
Answer Match 98.28%

I'm trying to find an Avery label template for Word 2003.

But everywhere I look I hit a dead end.

I know this has to be easy to do, once you know how.

So, where do I start?

The label package I have has this number on it: 06141.

Will in Seattle
a.k.a. "Clueless"

A:Print Avery 06141 labels in Word 2003?

Is this MS website any help for you. Read through it & you will see a link to Avery for their label wizard that you can download.

3 more replies
Answer Match 97.02%


I am having issues with Word and Outlook 2003. I just upgraded them from 2000 and now I am running into a couple of issues. Help!

Microsoft Word 2003
- Can't highlight or select an area on my Word page with my mouse. I can use my keyboard, but that becomes quite annoying as you can imagine.

Microsoft Outlook 2003
- Can't highlight or select an area on my page with my mouse. I can use my keyboard, but that becomes quite annoying as you can imagine.
- Can't open Word document attachments only. I can open excel, pdf, etc..., but not Word.

I have restarted my pc, reinstalled office 2003, erased the profile, removed the 11.0\Word\Data registry and no luck. Any solutions would be greatly appreciated. Thanks!

A:Can't highlight in Word 2003 and Outlook 2003. Can't open Word 2003 attachments.

9 more replies
Answer Match 96.6%

I'm using mail merge in Word 2003 on XP for a company holiday newsletter. It doesn't allow me to choose email merge--that option is disabled. (See picture.) Why? I can send individual emails without any trouble. I've also successfully used email merge in Word on another XP computer in the past.

A:Can't email merge in Word 2003

bump--any guesses?

1 more replies
Answer Match 96.18%

Im trying to get our program to work with MS Word 2003.

our program is a 16bit superbase based program.

when doing a mail merge, it will open word but will not merge the info in.

I get an Application not responding error.

This works fine when the user is logged in as a Power User, but not when logged in with Limited Access.

The info is exported to a text file first, and then merged into a word template (.dot).

it doesnt even bring up the letter to merge into when i get the application not responding error.

does anyone know what the routine for importing info into word is, or if any folders associated with word / windows requires the user to have full control over?


More replies
Answer Match 95.76%

I have done typing over the Internet for years. My regular computer is in being fixed and they have given me a loaner. The only strange thing about it is that when I used my own disk to load Word 2003 on the loaner computer, it came up with its own product code - you know those letters and numbers you have to put in -- anyway, I tried to enter my own, but it would not work. I had to use the ones that automatically came up. I don't know how they got there. The only thing I can think of is that the previous owner of the computer had loaded Word and that this was his product code!

Anyway, my work requires the use of templates that are merge documents. I have to install a certain SQL file in C:\WINDOWS\Temp. The file is there. I have checked. But when I open a document it says its looking for the SQL file in C:\WINDOWS\Temp -- but it can't find it.

I have tried and tried all morning - emailing the company back and forth in the UK and it just will not work. I am completely baffled. The file is there - the path is correct and yet it says Word cannot find it.

Does anyone have any suggestions? The only thing I can think of is that the previous owner - the owner of that product code - had some kind of administrative blocking on the computer.

Anyway, I am not making money and would like to figure it out so appreciate any help.

A:Word 2003 merge document problem

Hi Purley,

How did you get the SQL file into ...temp?

You need to have the SQL file point to a data source; the SQL is just a filter against a data source somewhere else and that connection needs to be established first.

Is the source database on another Server e.g. at the Company you are doing work for?

You should contact the company's IT admin to make sure you have connectivity.


2 more replies
Answer Match 95.76%


I have to combine several versions of the same document, preserving the tracked changes and their author. I can combine the documents and changes, but when I do, Word attributes some of the changes to me (I never edited any of the documents), and attributes some other changes to contributors who did not make them. Is there any way to merge the documents and still record the authorship of each change?


More replies
Answer Match 95.76%

Hey all.

My customer wants to be able to set it so that a bubble is shown when there have been additions and/or deletions in a Compare and Merge output document, instead of just the highlighting/underlining/strike-through. I showed her the options in Tools | Options | Track Changes to specify how it shows these, but she wants bubbles! Bubbles!

<-- Like that(but its all the way off the right margin, too.

Anyone have any ideas? x_X

A:Word 2003 Compare and Merge options?

The bubble you show is one that you can see if you go in and check "Hidden Text" under Tools, Options, View.
The shape of the bubble, however, is essentially the same as that of a comment.
I made 2 nonsense documents that were almost the same, then ran Compare and Merge to a 3rd document. I inserted comments where there were changes, and then entered information about the changes into the comments.
See the attached.
Oh, and the comment automatically goes to where the end stop is set (based on the margins and your paper size) so you have to reset the margins to get the comments into the page more.

1 more replies
Answer Match 95.76%

I have it set up to list an agency and then a recipient.

<address 1>
<address 2>
<city, state, zip>


<recipient name>
<address 1>
<address 2>
<city, state, zip>

In the first set it seems like it automatically set it as an address block even though it doesn't say it anywhere and if the address2 is blank it moves the city,state,zip up to fill in the gap. In the recipient address, if there is no address2, it leaves a blank line. Using the address block fix is problematic because it does not seem to want to allow me to choose the specific fields, it names them for me. Also, there are nine versions of the letter I arranged into excel fields to get around having to create multiple versions. I was going to just either put the info in the excel field or leave it blank, but it leaves blank lines on that too.

Is there a way to suppress the blank fields? I have seen some complicated sql language that supposedly will do it, but I don't understand what they're telling me to do.



A:Solved: Word 2007 Mail Merge Unwanted Blank Line!

For fields that might be blank, try conditionally adding that field versus a regular add. In your example, it would look something like this:

{Mergefield "Address 1"}{IF {Mergefield "Address 2"} <> "" "
{Mergefield "Address 2"}"}

3 more replies
Answer Match 95.34%

I'm using Word 2003 and I can't get the beast to keep my return label to Garamond 8pt font and the to address of Garamond 12pt bold. It always reverts back to the Arial font in both fields. This happens on my laptop and desktop AND on a number of pc's at the school I volunteer at.
Can anyone help out as this is driving me nuts!!
May God bless,

A:Solved: Word 2003 reverts back to Arial font in evelopes & labels..

10 more replies
Answer Match 94.92%

I have a need to Automate basically everything in regards to a Mailmerge.
I have successfully created a Main Document and even a datasource to grab the data from. I've done this several different ways. ( utilizing both the current wizard & adding the MailMergeHelper to my toolbar ).

The problems lie in trying to get this to work via macros.

If I try and load the main merge document, and then use a macro to 'Get The Data Source", it doesn't load properly. I get M, &M_1 as the only records.
I created the Macro by hitting RecordMacros and having the VBA record my steps. Obviously something is missing. Is there another command I need to add ?

If i allow the document to load the data upon startup
i get macros disabled... Any idea why that could be happening.

This should not be this difficult.

Any help is greatly appreciated.

Mindy Jeanne

A:Mail Merge 2003 - Macro Problem

Make the mail merge main doc and have it set up with the data source already. Save it as a document.

Record a macro that opens the file and creates the mail merge to a new document, and print it.

That macro code will, by default, appear in your file. Hit Alt+F11, double-click "New Macros" under Take everything out of the code after Sub Yourmacroname() and before End Sub. Delete the two remaining lines.

Double-click THISDocument under YOUR document on the left of the screen. Hit the General dropdown and choose Document. Make the other dropdown say Open. So you should now have the title and End Sub of a macro that runs when the document is open. Paste the code between the sub and end sub lines.


Oh, and set macro security to low. Many would say they don't recommend that, but the truth is, there are no WORD macro viruses running around anymore--people are having too much fun with email viruses to mess with Word anymore.

1 more replies
Answer Match 94.92%

I am doing a mail merge with Word2003 - the database info is in an Excel 2003 spreadsheet. The mail merge works just like it always has - UNTIL I get to the last step - Update All Labels. At that point only the first three labels and the LAST two labels on the first page and miscellaneous labels on the next page are populated with information. I do not have this problem on my desktop but I do on my laptop and others have been experiencing the same problem. 11.6359.6360 SP1 is the version of my Word2003 and 11.6355.6360 SP1 is the version of Excel2003. Thanks-Char Gorak

A:Mail Merge Not Completing Correctly 2003

this is what you can try
go to options in Word and on the general tab you select the box confirm conversion when opening document when you select this box you will have to select your data file in excel again and you select the DDE option
I hope this will solve your problem

with kind regards Paul

3 more replies
Answer Match 94.92%


Im trying to merge into a word doc. In the access databse there is a table that consists of

Recommended By
Area they live in

I was wonder if anyone can help me with the VBA for the button?

Thanks in advance.

A:Solved: Access 2003 mail merge VBA

16 more replies
Answer Match 94.92%

hi all,

i'm hoping someone on here has an answer to my dilema...

we recently upgraded from Office 2000 to 2003 and have run into a problem when trying to do mail merges between the Office apps. i'll do my best to explain:

1.) data in entered into an Access DB that creates job-sheets
2.) this can be printed / emailed to others (done via Excel to Word using Mail Merge)

with 2000 (on which it was developed) everything worked as it should, but since upgrading to 2003 the data is no longer getting across.

what it throws back is 'This method or property is not available because the document is not a mail merge mail document.

after discussing this problem with our database manager we think it might be because of the following:

you'll see that in 2003 the 'No' option is highlighted by default, in 2000 the 'Yes' option was highlighted!

anyone know a work around this?

currently the 'action' is dictated by VB code with a button on the Access DB entry form.

hope someone can help!

thanks in advance.

Neil Merton

A:Mail Merge & 2000 to 2003 Upgrade

Here ya go...let us know if it works:

2 more replies
Answer Match 94.5%

Merge to email does not seem to work using Word 2003 with Excel on Vista.

Word doc is merged with Excel spreadsheet that contains names and email addresses. The application works perfectly on Win XP but on the new Vista machine it works perfectly up to the point of clicking the merge to email icon on Word's merge toolbar, which is grayed out on the vista machine but fine on the xp machine.

Just to check my own sanity, i copied both word doc and spreadsheet over to my xp machine and it works fine. So Vista seems to be the culprit.

In a google search I turned up very little on the problem -- suggesting user error on my part -- but i did find a reference to the need for a win.ini entry (vista apparently does not have a win.ini) and then some other reference (though nothing substantive) about using a registry to supplant the win.ini entry.

I know the simple answer is to run it on the xp machine (mine) and not on the Vista machine (my wife's). Nuf said about that option.

Thanks in advance for any help.


A:Merge to Email Problem - Word 2003 on Vista

11 more replies
Answer Match 94.08%

Is there any way that the address block layout can be changed.

The default is:-

Survey One Pty Ltd
Mr Jack Gordon
12 Wright Ave.,
Melbourne Vic 3000
in Australian is should be:

Mr Jack Gordon
Survey One Pty Ltd
12 Wright Ave.,
Melbourne Vic 3000

More replies
Answer Match 94.08%

I am trying to merge an outlook contact file with word mail merge. I am getting the follwing error msg after I select the file:

Microsoft Word

This operation cannot be completed because of a dialogue or database engine failures. Please try again later.

Thanks for the help

More replies
Answer Match 94.08%

I have attempted to print out mailing labels from my Contacts Folder in Outlook 2003 without success.

I list here the steps taken so far :-

1.Contact page selected in Outlook containing all the addresses I want to print. I then click Tools> Mail Merge.
2. In the MM Page I have selected;- All Contacts,All Contact Fields & Mailing Labels
3. Selecting "OK" launches MS Word with instructions to click "SETUP" in Section 1 of the MM Helper Page which now appears.
4.When this is clicked , the "LABEL OPTIONS" Page appears
5 Here I select "AVERY A4 & A5 sizes" with Product Number of L7160.
6.cLICKING "ok" brings me to the Blank Label Page with MM Helper Page still superimposed on it.
7 There are 3 choices on this page with the 3rd choice "MERGE" greyed out.

I only use the Mail Merge facility rarely , the last time was almost a year ago , but I seem to remember that the 3rd choice here . i.e. "MERGE" was not "greyed out" the last time I used this facility.

Any advice as to how to resolve this would be appreciated.

A:Problem with Mail Merge Office 2003 using Outlook

Hello thenoo,
Refer to the links below to see if they can provide you with more useful information...

About using contacts for a mail merge - Outlook -

How to use Outlook contacts with mail merge in Office Word 2003

Use mail merge for mass mailings and more - Training -

3 more replies
Answer Match 93.66%

Using Outlook 2003, Part of MS Office Professional Edition 2003, which has the capability of having multiple, separate & complete email addresses, each functioning in their own profile.

E.g. I open Outlook and it gives me a drop-down box to choose which email I want to go to, say email1 or email2.

Email1 has 2 "Contacts" areas defined.
1st problem is how to combine and synch these two. I don't want two.

Email2 as 1 "Contacts" area.
2nd problem is to combine the contacts from Email1 with Email2.

I thought these were *.pab files, but a search for *.pab comes up empty.
I do find multiple *.pst files

Any suggestions?


A:Help with Contacts Merge in Outlook 2003,Part of MS Office Professional Edition 2003

Oh, and I need tips on how to make SURE I've got the existing stuff backed up before I mess with anything. This isn't my computer I'm working on, and there are 4000 contacts involved.

1 more replies
Answer Match 93.66%

Using Windows 98, trying to do Excel to Word mail merge.
Workbook name
Worksheet names:

I have named cell ranges on each of the sheets, and would like to use that information selectively for a variety of mail merges in Word. When doing the merge though, my only choice for Data source, is entire spreadsheet...and my "named" ranges do not show up? Any advice...named ranges are named in following manner:
Board='Board'!$A1!Bx17 etc
Any help would be appreciated, please cc the email to
[email protected] as I will be working on this tonite at home too.

A:Excel/Word Mail Merge

Dear TSGF: No one ever answered my post, so I assume, as is always dangerous, that no one knew the answer. However, I figured it out even though it is not intuitively obvious from the MS standpoint! Here's the answer to my own question"

If you do not have Excel ODBC Drivers, Please install them in this way :

1) Click on Start --> Settings --> Control Panel

2) Select 'Data Sources (ODBC)' and press Enter key.

3) Goto 'System DSN' tab (3rd tab out of 7 tabs) in the "ODBC Data Source Administrator" dialog box.

4) Click on ADD.

5) Select 'Driver do Microsoft Excel (*.xls)' from select driver list box.

6) Click on Finish

Now you will see 'ODBC Microsoft Excel Setup' dialog box.

7) Type a name in 'Data Source Name' and click OK.

Now, Microsoft Excel ODBC Drivers are installed onto your system.

NOTE : You must install Excel ODBC Drivers prior to using mail merge facility.The Microsoft Excel ODBC driver must already be installed.

NOTE: In the Select Table dialog box, you will see all the tables in the workbook, not just the ones from the first sheet.

To connect to Excel using ODBC, follow these steps:

1) From the Get Data list, click Open Data Source.

2) Locate and select the Microsoft Excel file. In the Open Data Source dialog box, make sure that the Select Method check box is selected.

3) Click Open.

4) In the Confirm Data source dialog box, select "Excel Files via ODBC (*.xls)... Read more

1 more replies
Answer Match 93.24%

we are running office 2003. when doing a mail merge in outlook from our contacts list
word is inserting a blank line into some of the contacts between the address line and the city line.
address line 1
address line2


has anyone else come across this annoying glitch and have any ideas how to fix it???
if you can your a star!

A:Solved: Microsoft Outlook 2003 mail merge problem please help!!

7 more replies
Answer Match 92.82%

I understand how to do a basic mail merge from excel into word.

I want to complicate it by merging data from two different sheets in the same workbook into one document.

I have one sheet with Math grades for my students and another sheet with ss grades.

I want to create a status report that will give the parents both Math and SS.

I have the same kids in each class.

Can I do it? I've searched and can only find the same info on how to do it from one sheet.


More replies
Answer Match 92.82%

I am trying to pull a mail merge off between Excel and Word. When I pull Interest Rates off of my excel sheet into word, instead of coming out as "5.00%" they come out "5.0000000000000003E-2)" instead. And then another interest rate "17.00%" gets pulled like "0.17000000000000001." Its really weird. Also my dollar values lose the dollar sign during the merge. Am I doing something wrong? I have setup mail merges before its just these arent working. Any help would be huge!

A:Problem with Excel-Word Mail Merge

6 more replies
Answer Match 92.82%

I am trying to create an e-mail merge with a word document and data from an excel sheet. I used the Mail Merge wizard, everything seemed in place, previews were correct. I "finished" by putting in a subject name and hitting ok. The box closed, but no e-mails were sent. No error message. Any thoughts? I've tried several times.

More replies
Answer Match 92.82%

We have Word 2002 and excel 2002 applications we are trying to merge an excel file to Word and we are having problems getting getting the format correct. we have 4 decimal places on excel file, when we merge it to word it changes the format and puts a lot of zeroes on the file.
I also got this window message when we open the word file "Opening this Doc will run the following SQL on Select * From 'Sheet1$' Data from your...Base wil be placed in the Document. Do you wan to continue?"
We always click yes.
I looked at MS KB online the only thing I see is 97,98 older versions of Word and Excel. Has anybody experienced this problem already?
Please help. Thank you

A:Word-Excel Mail merge problem

8 more replies
Answer Match 92.82%

Using a mail merge in Word 2007, importing the data from an Excel spreadsheet.

The problem occurs when there's empty data in the last field out of 4, which are all in one cell in a word table. If any of the first three fields are blank, Word leaves no gap, but if the last field is blank it displays as a blank line, which ruins the vertical alignment. Is there anything that can be done about this, or is it a limitation of the software?

A:Mail merge Excel+Word 2007

9 more replies
Answer Match 92.82%

I have an excel spreadsheet with names in one column and street and city address in another. I want to make a simple mail merge so I can make labels but I can not figure it out. Any ideas? I am using the mail merge wizard, but when I merge it is all blank.

A:Solved: Word and Excel Mail Merge

You merely have to name the Excel spreadsheet as the source of the data for the mailmerge (I think it is about the 3rd step) where you can select browse to use an existing list (MS calls it a database on this step, even though a spreadsheet isn't really a database).
Have you done all that?
Also, you might want to consider splitting the street and city into two separate columns, just to make it a bit more flexible in arranging your data.

2 more replies
Answer Match 92.82%

Okay, I've been working on this all day and feel like I'm trying to learn brain surgery. Here is my situation.

I have an EXCEL 2007 worksheet (name, address, city/state/zip as headings) saved with 85 records. I go to WORD 2007 and open a new document. Go MAIL>Start Merge, and choose "Label" and select my label (Avery 5160). I then SELECT RECIPIENTS, go to "Existing User" and find my worksheet and open it. The first label is blank and the other 29 labels have <<Next Record>>.

I then go to ADDRESS BLOCK and match my headings for the merge. All 85 of my records show up in the little preview box. <<Address Block>> shows up in the first label.

I then highlight the whole label sheet (clicking on the little corner icon in the top left corner) and change the font to Arial Narrow, 11 point, so the print will fit). Upon hitting "Preview Results", I have the correct address showing in the first label space.

Now I go to UPDATE LABELS and the <<Address Block>> shows up in the #2 and #3 label, and the #29 and #30 label for a total of five labels (1,2,3,29,30). When I preview, this is what I get:

85 pages of labels
Page 1 = Record 2,3,4 on the top row; Record 30,31 on the bottom row;
Page 2 = Record 3,4,5 on the top, Record 31,32 on the bottom;
Page 3 = Record 4,5,6 on the top, Record 32,33 on the bottom, etc. through page 85.

The rest of the labels are blank.

Any suggestions because you can stick a fork i... Read more

A:Excel 2007 Mail Merge with Word

On the Microsoft forums, a semi-fix was posted for the same problem. Go through the Mail Label Wizard and when you get to "Step Four", press "F6" and tab to the "Update Labels" and hit enter (don't use the mouse to "enter". For some reason, that propagates all the labels.

However, for 85 records, it created 85 pages of labels.

Page 1 = Record 1-30;
Page 2 = Record 2-31, etc.

So I printed pages 1, 31, 60 and got my 85 labels.

Is any of this sound familiar to anyone?



1 more replies
Answer Match 92.82%

Hey all,

Using Words Mail Merge with Excel as the source, however when i merge to new document, it merges into one long document, as I want to email out the merged letter separately, how can I make the merge to new documents rather than document?

Multiple letters ready to be saved separately for each merged letter.

More replies
Answer Match 91.98%

Hi all

I have an old Access 2000 database which has a number of queries feeding mail merge letters in Word 2000. These have always worked perfectly. We are upgrading our systems to XP, and now have Access 2003 and Word 2003. We have moved everything onto new servers and set up folders exactly as they were on the old system, so for example the database and Word letters are in exactly the same places in relation to each other that they always were. But the merge letters cannot find the data source. When I open the letter and click the Find data source button on the window which appears, I can navigate to the database but the queries which are needed (and which are in the database) do not get listed in the Select Table dialog box. Basically the letters can't find their data source, despite the fact it's in the exact same spot, and when I navigate to the data source I can't see the queries I need which I know are there.

Also I should say that there is no VB code involved. Open the Word letter (in the working 2000 version) and it links automatically to the database and to the correct query which runs and then puts the data into the letter. All extremely simple. Or should be...

We're meant to be starting to use the new system ASAP and this is driving me crazy! Any and all suggestions gratefully received.

A:Mail merge worked in 2000, but can't find data source in 2003

Ok, so you don't see the queries listed, but do you see anything? Like the tables the queries are based upon?

It sounds like your data source might not be configured correctly.

Check the basics in the Data Link Properties. On the provider tab, make sure you have the right provider selected (probably should be Microsoft Jet 4.0 OLE). On the Connection tab, browse and select your database. On that same tab, make sure you have the correct username and password (if any). Use the "Test Connection" button to see if it all works. You can often ignore the "Advanced" and "All" tabs.

3 more replies
Answer Match 91.56%

I have done mail merges for years, but for some reason, the word merge document can not find any excel data folders.

I have a fairly new Dell laptop running windows 7. My Excel program seems to run OK and Word seems to run OK as well.

After I browse for the data file and select it, I get "OLE DB Database Files". I hit "OK" and then I get another box that says

"Word was unable to open the data source".

What am I doing wrong?

A:2007 word-excel mail merge problem

The Word document you're using is that based on a previous word version?
There may be a problem with the docuemnt reference files or something like that since it uses a kind of ODBC link to read the data and probably cannot find the expected reference and throws the error.
I don't know the solution to this but it's meant as a tip to try and point you in the right direction.
Office versiosn are nat all the dwonward compatible as they like us to think

3 more replies
Answer Match 91.56%

Hi there,

I'm trying to import data from an Excel spreadsheet into a Word document that already has the mail merge set up in it. Whenever I try to do this, I select the source after which it just sits there with a message in Word indicating 'Initiating DDE Link with Microsoft Excel.' I tried it with the same document on another machine and it worked... Is there another way other than reinstalling Word and Excel to fix an issue like this. I already tried /unregserver and /regserver and also tried creating another document with a mail merge.

Thanks a lot in advance!!

More replies
Answer Match 91.56%

I have Office 2003 with a Vista operating system. Everytime I try to do a mail merge to create label with a Excel csv file it forces me to close the application.

I can complete the mail merge using the same file on any other computer. The only why I can get the mail merge to work is to save a csv file as a regular excel file. It doesn't matter what csv file I try on, it just crashes word.

Tried unistall and re-install of Office and the problem is still occuring.

I don't know why word won't allow me to use th csv file type.

Please hlep

More replies
Answer Match 91.56%

Hi all,

I have never had this problem before. I have an Excel file with a number of worksheets in it, all running a macro (thanks XLGuru) that prevents the entering of duplicate data in an area of each sheet (it is a seating chart for a number of days). Not too fancy. I have the print areas set and a correct worksheet is set first to have the data taken from.
BUT, when I try to run a mail merge to word in order to print tickets, I get the following message: "Word could not re-establish a DDE connection to Microsoft Excel to complete the task."
I have tried just copyng the data to another Word document and using that for the data info, and that worked fine, so...?

Thanks again, in advance (what a great site)!

A:Solved: Word 97/Excel 97 mail merge problem

7 more replies
Answer Match 91.56%

I am trying to merge Excel spreadsheet data into multiple areas into a Word document. I cannot figure out on our 2003 Office version if I am missing a step or not...every time I "merge" it tells me it is merging hundreds of fields (we only have about 60 rows and 15 columns of data).

When the merge is done it inserts one row of data multiple times. I know there is a way to tell it to only pull from certain areas (like a data range) but the selection is "greyed out". I've tried the "if" statement to pull information by department and that didn't work either. I've included a PDF of the spreadsheet and the final document (no "real" data is inputted) just to give you a clue as to what I am trying to accomplish..which may be a pipe-dream at this point.

At this stage I'm about willing to let my staff hand-enter the information into Word, but there's got to be a way to do this. MS Office help, is no help - they only talk about merging if you are doing a mail/letter merge. Thanks for any assistance!

A:Using Excel NOT for Mail Merge but Merging Data into Word

16 more replies
Answer Match 91.14%

I have a document written in Word 2003 that seems to have portions of the text with extra tall line spacing. It's as though line spacing were set to 1.5 or even 2, even though the settings say otherwise. What gives? If necessary, maybe I can provide samples of the problem.

A:Tall line spacing in Word 2003

11 more replies
Answer Match 91.14%

I have tried to find shortcut forlline deleting in MS Word 2003 (only to have cursor on the line and press shortcut for deleting) but I was not able to find it.

Could you help me?

Thanks, Jixm

A:Shortcut for line deleting in MS Word 2003

hi jixm,

I don't think I'm aware of 1 shortcut for what you want, but others might know.

However here is a quick 2 stroke:

at the beginning of a line press Shift + End at the same time (this selects the whole line), then DELETE.

You could record a simple Macro to do the above and store it in Normal.Dot and run via a new shortcut key, but I wouldn't think that was necessary.


3 more replies
Answer Match 90.72%

I have a Microsoft word mail merge with around 11 fields, I wish to export 2 specific fields into an excel spreadsheet, is this possible and how would I go about doing this?
I use Windows 7, Microsoft Word 2007 and Microsoft Excel 2007
Please assume I have very basic skills in relation to these programes, so may need to be spoon fed a lot of the information

Thanks in advance,

A:Exporting specific field from word mail merge to excel

9 more replies
Answer Match 90.72%

I have been successfully using an excel database to create mail merge labels in word. I have now made that spreadsheet read only (as others will be accessing it) and now every time I try to export the information into word my labels only show #N/A in the fields where the name and address details should be.

Is there a way to get around this and make it work or will I have to remove the read only security?

A:Is it possible to create a mail merge in word when the excel data is read only

I think it does cause problems with the sheet in general, there are two things you can try.

1. create the mailmerge document when the spreadsheet is not read only and save the successful mail merge template. Then rather than exporting from excel open the word doc again and hopefully it has remembered the link and it will be able to pull to date.

2. Alternatively could you have a duplicate sheet hidden in the background of your excel file that literally copies every thing that has a value. and mail merge from that?

Does that make sense

2 more replies
Answer Match 90.3%

hello all

I am having trouble with something that seems like it should be so simple! I need to recreate a form for my boss that she only has in hard copy. I am using a table and removing the borders so that everything is straight in the form that people will need to fill in. I need to put a place for people to write on, like a line, and each cell will need text then a line. I tried using the underscore but it comes out looking spotty, meaning there are spaces between each underscore.

there has to be a better way of doing this? I have never recieved any formal education with regards to word 2003, so all I know I've learned by trial & error but I can't seem to figure this one out.

I can't access photobucket or anything like that, so I can't add a screenshot. Basically it needs to look like this:


^ that was done with underscores but they don't show up nicely in word 2003.

thanks for your attention, all!


A:Solved: creating a line in a form in word 2003


This is a simple one if you are using tables to layout your form.... just add the border to the bottom of the cell where the text will be entered.

I have attached an example of this if that helps.....

2 more replies
Answer Match 90.3%

I'm trying to remove the blank line that Word 2003 inserts after a paragraph mark. But the "Don't add space between paragraphs" check box is grayed out on the Format>Paragraph settings box.

What I'm trying to do is reduce or narrow down the blank space between lines of text on file folder labels I'm trying to print. Each line of text on the label ends with a paragraph mark. And Word 2003 inserts a blank line between the lines of text on the labels.

What's the trick to getting rid of that additional blank line?

Will in Seattle
a.k.a. "Clueless"

A:Word 2003 inserts blank line between paragraphs

Go here
and try the first option using Find and Replace.

1 more replies
Answer Match 89.88%

As part of a program i am working on data is transferred into an excel document with usually more than one worksheet. after that happens a mail merge is manually done to create labels. the problem i am having is that the first time i open the excel workbook i can choose a table and make labels fine but if i try to open the excel workbook again to change the table to make new labels an error pops up saying that word cannot open the data file because it is already open. i know for a fact that the only place it is open is in word because i already have labels open from it, and this operation works perfectly fine on another computer. i am concluding that this is a Microsoft office error however i cant find any other people having problems with this.

A:Error when changing excel data sheets in word mail merge?

Welocme tho TSG,
If word is open and linked to the spread sheet, opening the spreadsheet in exel would evoke the "in use" response. Closing word is the only option here.

3 more replies
Answer Match 89.46%

I am using cross-references in my Word document. At the end or beginning of the sentence where the cross-reference exists is a mysterious vertical line. I have never seen Word do this before and not sure how to turn this off as it appears in Print. The cross-references are to Figures within the same document-if that matters.


A:Solved: Word 2003 cross reference vertical line

7 more replies
Answer Match 89.46%

Hi, my problem is that when I was using Microsoft Word 2003, I reduced the font of one of the files I was working on and the entire file just transformed so that:
after every line, this symbol appears: ¶
before some lines, this symbol appears: º
and between words, this symbol appears•

This actually happened before, but i, ah, don't remember how i got rid of it. I know it's kind of a small problem, but it's really driving me crazy.


A:Solved: microsoft word (2003) files keep showing this after every line: ¶

8 more replies
Answer Match 88.62%

I have Microsoft Office Pro 2003. When I clicked on the Word icon to open up a new document today, I noticed that there were no spaces between the three pages of data that I had pasted on it. Just dotted lines that signified what I guess you would call a page break.

Let me see if I can explain that better. It used to be that when I opened up Word to start a new document, there was one white page displayed with a colored border all the way around it. I don't know where that border or color comes from or how to change the color. I just see it in front of me.

Then, after I finish typing on page 1, Word automatically brings up page two, but there's a good quarter inch of space between the two pages and I can even see that color I mentioned.

Obviously something is wrong and either there's a setting somewhere that will restore it to the way I described above or I'll have to run a repair installation on Office, maybe even an uninstall and reinstall.

But first, your thoughts.
Thank you

A:Solved: No space between pages in word 2003

11 more replies
Answer Match 88.2%


When you make a hyperlink there's a option of selecting email. Which then makes a box appear asking the me to insert the email address, subject line and body of text.

what I would like to do is auto-populate the subject line with words written in the document--or---auto populate the subject line with the contents of a fill-in form field.

Is this possible -- Oh i'm using Microsoft Word 2003.

Any assistance would be greatly appreciated.

Thanks in advance

A:Solved: Auto populate subject line in word 2003 - hyperlink

I figured it out!! I don't know how to remove the thread....

1 more replies
Answer Match 88.2%

Completely baffled. I've sync'd Windows mail with my Gmail account, everything back and forth is fine. Trying to send email w/attachments from Word 2003 results in nothing-no error, no nothing. I have the 'mail' icon on Word 2003 set, I can access the 'send to mail recipient' on 'file' so that I can enter email addresses to send the attached file to whomever-but when I click Send...nothing. I am absolutely at my wits end, and I can't self diagnose this to fix it. Again, my Gmail and Windows Mail are sync'd fine-can send msgs back and forth. About to blow a gasket on this, have depositions to send and can't! thanks so much

More replies
Answer Match 87.78%


Any one know if there is a way to remove"White Space Between Pages" from all Computers containing Word 2003 on a Domain?


A:Remove White Space - Word 2003 over Network

This is a user-specific setting so you'd have to push down a script that runs on all the computers and edits all profiles. Seems like a lot of work for that change.

1 more replies
Answer Match 86.94%

Word and Excel want to be reinstalled every time they are opened. When opening some other programs that have nothing to do with word processing, such as Reg. Mechanic, Adobe Photo Shop, Word wants to be installed. I have uninstalled and reinstalled frequently, but it still happens and if I don't do it the program just closes.
Any ideas please?

A:Word 2003 & Excel

Not sure why this happens, but have had a similar problem before. I solved it by completely uninstalling office. I even went as far as to delete the local user files for office. Then installed office, selecting custom install and then selecting to run all things of my computer. Problem sorted, although can not say what the problem was.

On my new computer I also have this sometimes, but it is because I have office 2003 and 2007 on the same machine. A reg edit more or less solved the issue, but in the end I had to also remove access 2007 and only have access 2003 on the pc.

2 more replies
Answer Match 86.94%

i cant open an excel file...i think i've tried everything. it's not just one file either. its any file that requires excel. help please.

A:Word Excel 2003

Hello stupidblonde,

Is there an error message that displays when you try to open the file?

15 more replies
Answer Match 86.94%

When I tryto print Christmas mailing labels/mail merge labels, I get 1 label per page instead of a page full of labels. Can anyone help?

More replies
Answer Match 86.1%

I really screwed up these programs. I downloaded a free trial of system mechanic and something happened to the programs. When I open word or excel a installer opens and trys to install the program but gets an error message that a cab file is missing. Error 1311 c:\msocache\allusers\90000409-6000-11d3-8cfe-0150048383c9\ The computer is a Dell and on microsoft site said I had to go to manufactor for help. They won't do anything except ot sell me the programs as the warranty is expired. Only other thing I can think of is to restore the computer to its origanal state but it would wipe out all the stuff on it. Tried to back it up on floppys but too many files 80,000. Any help woild be greatly appreciated as I have very little knowledge of computers. thanks

A:office 2003 word and excel


do you remember when you install the (system mechanic) ?

if to you can do this a long as you dont have the system restore turned of on your system


select ( all programs
select (accessories
select ( system tools
select ( system restore

now you will be given the option to ( restore to a specific date or create a restore point

select (restore to a specific point

now a window will open with a calender on it

select a date that was befor you installed the (mechanic

then do the restore / now this may fix your issue and it may not

this is the issue with useing programs like this / they normally just make things worse or kill your system

hope it works for you

1 more replies
Answer Match 86.1%

Good afternoon,

I hope someone can help me. My Op/Sym is Vista. I am trying to merge a word document (label) with my list ( tried excel and access) to create about 600 labels. What the mail merge is giving me is the first 6 labels ( I do have 6 lables per sheet), but then thats it. It will not update all of my names.
I am not using the mail wizard.
I've tried using the instructions from windows support about using the Tablet PC Input Panel, but cannot seem to understand how that works.

Please somone help me.

More replies
Answer Match 86.1%

Hello, I am trying to mail merge some labels. The problem is I have a custom label template that Word wont let me use. I have added in some additional cells, coloring, and formatting myself, but cannot use when I select Label option. If I select the letter option, it lets me use it, but I can't get it to repeat with <<Next Record>>. I'm sure there is an easy solution for this, but just cant figure it out.

Thanks in advance

A:Mail Merge Labels w/ custom template

ok. well i made it work. what i had to do was choose labels, then recreate my formatting (which took a while with lots of cells and shading), found the insert field for NEXT and made it work. if anyone has another solution to make it easier next time, let me know. otherwise, problem solved.

1 more replies
Answer Match 85.68%

I am creating merge labels (Avery 5160) for a list of students which were created in Excel.

Does anyone know a way to only print two records on each sheet of labels? would have 15 same labels for the first student then 15 same labels for the second and continued.

I can create the first 15 and then insert a NEXT RECORD for the second set of 15. The problem is once it gets to the next page it still includes the second set of 15 and then includes the third record.


Brian Smith Brian Smith Brian Smith
Brian Smith Brian Smith Brian Smith
Brian Smith Brian Smith Brian Smith
Brian Smith Brian Smith Brian Smith
Brian Smith Brian Smith Brian Smith
Tammy White Tammy White Tammy White
Tammy White Tammy White Tammy White
Tammy White Tammy White Tammy White
Tammy White Tammy White Tammy White
Tammy White Tammy White Tammy White

Tammy White Tammy White Tammy White
Tammy White Tammy White Tammy White
Tammy White Tammy White Tammy White
Tammy White Tammy White Tammy White
Tammy White Tammy White Tammy White
Lisa Tully Lisa Tully Lisa Tully
Lisa Tully Lisa Tully Lisa Tully
Lisa Tully Lisa Tully Lisa Tully
Lisa Tully Lisa Tully Lisa Tully
Lisa Tully Lisa Tully Lisa Tully


Brian Smith Brian Smith Brian Smith
Brian Smith Brian Smith Brian Smith
Brian Smith Brian Smith Brian Smith
Brian Smith Brian Smith Brian Smith
Brian Smith Brian Smith Brian Smith
Tammy White Tammy White Tammy White
Tammy W... Read more

A:Solved: Word 2007 Merge 5160 Labels

11 more replies
Answer Match 85.26%

Hey Folks,

So I'm hoping that someone here can help me out. I rebuilt my machine last week with a fresh install of XP Pro (SP2).

Four days later, Outlook started crashing whenever I tried to send a message (with Word as my email editor). So I checked out Word, and it would crash when I opened it. I sent the report to MS and of course, they recommended that I get all of the Office 2003 updates, which I did. Still, both Word and Excel crash every time I try to do anything in them. Outlook is fine now that Word is no longer the email editor, and the other Office apps work just fine.

Any thoughts on how to fix this one? I have tried reinstalling Office, but of course, since it never completely removes...yeah.

Helo would be greatly appreciated.

A:Word and Excel 2003 Crash All the Time


I have the same problem here. Windows XP+SP2.I tried the repair option in Office 2003 and the problem dissapeard but only for about 2 weeks, the it reapeard again. Then I uninstall and reinstall Office 2003 again and for now (3 days) it's ok.
Before uninstal I also tried installing Office SP2 but the problem was still there.

Any of you guys found working solution?

Thank you very much.


4 more replies