Tech Problem Aggregator

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

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

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:
{ IF { MERGEFIELD DATE_OF_BIRTH } = "" "CHECKED/TICKED BOX SYMBOL" "UNCHECKED BOX SYMBOL" }

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 106.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
 

3 more replies
Answer Match 105.6%

Hi

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 98.4%

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 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 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

No.
Sorry, but this is a huge shortcoming of Word.
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg
 

1 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.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:
http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm

Mail merge issues:
http://www.officearticles.com/word/troubleshoot_mail_merge_results_in_microsoft_word.htm

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:
http://www.officearticles.com/word/view_field_codes_in_microsoft_word.htm
 

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%

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%

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%

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?

Thanks
 

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

Hiya

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

Regards

eddie
 

2 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.

Matt
 

A:Word 2003 mail merge question

7 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:

http://forums.techguy.org/showthread.php?t=292577

eddie
 

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?

thanks
 

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.9%

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:
http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm

Pay particular attention to the Propogate Labels button.
 

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%

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.

chris.
 

2 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 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 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")
SocServs.Activate

'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")
.Next
i = i + 1
Loop

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.

Regards,
Rollin
 

2 more replies
Answer Match 99.54%

Hello,

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 97.02%

Hello,

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 normal.dot 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?

thanks
 

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%

Hello,

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?

Thanks
 

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.

lol
Hew
 

2 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:

http://www.kbalertz.com/kb_825765.aspx
 

2 more replies
Answer Match 94.92%

Hi,

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

Prefix
FirstName
LastName
Add1
City
PostCode
Recommended By
Area they live in
He/She

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%

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 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 normal.dot file. Hit Alt+F11, double-click "New Macros" under normal.dot 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.

Save.
Close.
Open!

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

dear
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.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.

tom
 

A:Merge to Email Problem - Word 2003 on Vista

11 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 - Office.com

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

Use mail merge for mass mailings and more - Training - Office.com

3 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 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
Main.xls
Worksheet names:
Board
CLEC_Affliates
ISP_Affliates
MCC

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.
Thanks
Victoria
 

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%

hello,
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.
eg:
name
address line 1
address line2

city
county
postcode

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

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

7 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 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%

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%

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 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.

Thanks
 

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?

Thanks.

Mark
 

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 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 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%

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.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 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%

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...?
Help!

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

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

7 more replies
Answer Match 90.72%

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
 

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,
Thomas
 

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 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 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 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.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\4t561401.cab 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

Hello

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

steps

start
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 85.26%

Excel and Word are fine if I open a blank doc from the Quick Launch bar or even My Docs. but if I try to open either from an existing doc on the desktop, it takes forever and sometimes opens empty. Also if I try to open an attachment from Outlook Express. I have tried:
1) Making sure file associations are OK
2) Re-registering
3) Repairing Office 2003
4) Running sfc

I also sometimes find that if I have this problem, then I cannot get at my drives via My Computer.

Any ideas someone????
 

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

Hello

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.

Gregor
 

4 more replies
Answer Match 85.26%

Is there a file I can backup so when I reinstall Word and Excel, I won't have to redo all my icons in the toolbar? I think it used to be normal.dot. Is that still the case?

Thanks
Peg
 

A:Solved: Word & Excel 2003 setup

Go to Start -> All Programs -> Microsoft Office. Somewhere in there is a settings transfer wizard which will do exactly what you want. I can't find the official documentation right now, but look in the menus for it, and follow the prompts.
 

3 more replies
Answer Match 84.84%

the "mail recipient (as attachment)" in office 2003 is not available
can someone please provide me a fix for this

i read that i need to install the outlook 03 that came bundled with office for the attachment option to be available
but i remember there is a fix for this in the registry so if u don't install the outlook, the option will still show up
 

A:[Word] no mail attachment on office 2003

I don't have Outlook installed either, but if I open a new doc in word, click on file go to send to, it's the first one in the next window there.
 

3 more replies
Answer Match 84.42%

I have Word 2003 and 2013 installed on my computer. Word 2013 can't edit files with custom XML elements, so I want to use 2003 to open them. However, whenever I double-click an XML file, it launches 2013. I tried to fix this by selecting "open with" and browsing for Word 2003. But whenever I do that, the program that appears in the open with dialog box is Word 2013--not 2003. I can't select Word 2003 from any open with dialog box from anywhere because of this. How do I fix this?

A:Word 2013 and 2003 installed; default programs won't recognize 2003

It's actually best recommended not to have 2 versions of MS office at the same time, but I guess yours is a special case.

Try opening Word 2003 and open your document from there. See if it works.

3 more replies
Answer Match 84.42%

Hiya

This document is designed to help solution developers and architects understand how Microsoft Office Excel 2003 can be integrated with back-end systems (in this case Microsoft Windows SharePoint Services) to create powerful client-side applications through which back-end functionality is exposed. In particular, this solution is used by project managers to launch a new Windows SharePoint Services team site and to collect data that will be used to manage a project. It shows how various Microsoft technologies can work together to improve and simplify business processes, with an emphasis on Microsoft Visual Studio 2005 Tools for Office. The code sample is available in C# and Visual Basic.
System Requirements
Supported Operating Systems: Windows 2000; Windows Server 2003; Windows XP

Microsoft® Visual Studio 2005 Beta 2
Microsoft® Visual Studio 2005 Tools for the Microsoft Office System Beta 2 (included with Visual Studio 2005 Beta 2)
Microsoft® Windows® SharePoint™ Services 2003
Microsoft® Office Professional 2003
or
Microsoft® Office Excel 2003


http://www.microsoft.com/downloads/...56-3fdd-427a-b512-427906359669&DisplayLang=en

Regards

eddie
 

More replies
Answer Match 84.42%

Hi,

I have a laser jet printer HP 2015. If i print email recd. with excel embedded cells in Landscape mode from a XP OS / Outlook 2003 / Excel 2003, the contents are fully printed.

But if i print the same email in landscape mode from Windows Vista / Windows 7 / Outlook 2003 / Excel 2003, the contents are not printed in full, i.e the last 3 to 4 columns of excel embedded cells are not printed.

Pl. help.

Thanks
 

More replies
Answer Match 84.42%

Hi Everyone!

I have a form that I created in Word 2003 (see attached). There are a few things that I’d like to accomplish with this form.

1) once the form is completed by the user, I want to be able to export the entered data into an excel spreadsheet (via macro button – submit/export - and VBA for the actual transfer of data?)
2) for 3 of the sections with radio boxes (employment type, rate your experience, and the 1st line of availability (1 shift/wk, 2shift/wk…)) I would like only one selection to be made. So the user can only select one of the options, and not multiple. Actually the Teaching Experience one…I need it so they can select whichever grades they teach, but only one selection of ‘years taught’. They can select any/all the MPMxx but it’s the ‘years’ that is important…

I have a very basic understanding of VBA but I work with excel all the time so I’m relatively comfortable with some things and willing to learn/try new things…

Can someone please point me in the right direction as to how I can accomplish this?

What I envision is the form being completed then sent back to me. I then hit a button embedded in the form that will then export the data to my excel spreadsheet where I can sort, etc…

Any help would be much, much appreciated as I’ve tasked myself with completing this…when maybe perhaps I should have tried to figure out how complicated this might be first…

Thanks for reading!!!
 

A:[VBA] Exporting Word 2003 Form Data to Excel

Files
http://www.mediafire.com/?xxexol8mexwi1ma

Okie, my objective here is to transfer the data from a word .doc into an excel spreadsheet. The form is all bookmarked with proper tags. I have started the VBA code, but I’m at a loss as to why some things aren’t working…


Sub Report1()
Dim path As String
Dim wdApp As Word.Application
Dim wdDoc As String
Dim curDoc As Word.Document
Set wdApp = CreateObject("Word.application")
wdApp.Visible = True
path = "C:\Users\xxxxxx\Documents\APPLICATION FORM\FINAL COPIES"
'Get first document in directory
wdDoc = Dir(path & "\*.doc")
'Loop until we don't have anymore documents in the directory
Do While wdDoc <> ""
'Open the document
Set curDoc = wdApp.Documents.Open(path & "\" & wdDoc)
Range("A1").Select
Selection.End(xlDown).Select

ActiveCell.Offset(0, 1).Value = curDoc.FormFields("DATE").Result
ActiveCell.Offset(0, 2).Value = curDoc.FormFields("FNAME").Result
ActiveCell.Offset(0, 3).Value = curDoc.FormFields("LNAME").Result
ActiveCell.Offset(0, 4).Value = curDoc.FormFields("EMAIL").Result
ActiveCell.Offset(0, 5).Value = curDoc.FormFields("OCT").Result
With ActiveCell.Offset(0, 6).Value
If FieldName = True Then
ActiveCell.Value = "PERMFT"
ElseIf FieldName1 = True Then
ActiveCell.Value = "LTOS"
ElseIf FieldName2 = True Then
ActiveCell.Value = "RET"
ElseIf Fie... Read more

2 more replies
Answer Match 84.42%

Hi,

I'm running a Win7 32-bit system with Office 2003 installed, all latest patches are installed as well. I have these periodic (and very sporadic) errors when working in a spreadsheet or document where the application stops working when copying and pasting information between sheets, cells, documents etc. and the computer freezes up and I have to reboot. The error is "Microsoft Office has encountered an error and needs to close". This has become very frustrating when working on templates and losing large amounts of information. I haven't been able to find any troubleshooting tips pertaining to these issues and it is happening across 3 or 4 computers in our network now. These are new Dell Latitude E6410 laptops with clean installs on them.

Anyone have any ideas?

Thanks,
~Chris
 

A:Excel/Word 2003 copy and paste crash

Have you ever sent an "error report" to MS? (I certainly never do, I'll admit.) I am curious as to what the error report generated would be - something to do with your anti-virus, perhaps?
 

3 more replies
Answer Match 84.42%

I run XP Professional with Word and Excel 2003. I "think" my problem started after I upgraded to Office SP3. The apps open and close very slow. If I open Word without addins using winword.exe /a -- it's fine. How do I figure out what addin is causing the problem or does anyone know which one might cause this? It's making me nuts!

Ideas?

Thanks
 

A:Word/Excel 2003 Slow Loading and Closing

I had the same issue, and after reading your post I tried the winword /a also. Word opened in a few seconds. After some searching around I found an old autorecovery file in c:\documents and settings\myusername\application data\microsoft\word.
The name was something like "autorecovery save of .....".as$.
I deleted this file and now Word opens and closes normally again.

You should also check the Startup subfolder in the folder mentioned above. Move anything there to another folder temporarily and see if it helps. You could also try moving your normal.dot (and any other templates) from the Application Data\microsoft\Templates folder.

I've also seen this happen when accessing documents on a network share, when the local DNS settings point to an external (i.e. Internet) server as the primary, then an internal one as the secondary (it should be the reverse). You can check this from a command prompt using ipconfig/all.

Other than that you'd have to disable (or remove) the add-ins one by one to determine which it is.

Hope you got it solved already, but if not, hope this helps.

Steve
 

1 more replies
Answer Match 84.42%

Hi Guys
I am new to this forum and not very technical minded so please bear with me.

I have a monitoring spreadsheet through which i monitor c40 word docs. The biggest issue i face is that these words docs have a box with an expiry date on it. I normally have to open each word doc every week and update the date to current date. Then i go back in spreadsheet and manually update a column which has conditional formatting and goes red to alert me. For my purpose i will have the same date in all word files

WHat i want to achieve is to have a button in my excel file which when pressed updates the date in all word docs to current date. Word files will be closed during the update

I hope i am making sense

Thanking yo uin advance

Regards
 

More replies
Answer Match 84.42%

Hi all -- I have read a lot about similar complaints, but the solutions
are not working. I have a new DELL XPS, and installed my copy of office
onto it. Whenever i double click a document (Word/Excel)The program
launches, but the document doesnt load. I HAD Norton A/V on the system
when it was delieverd, but i uninstalled it as soon as I got it. After
reading, I thought maybe the offiveav.dll was still registered from the
old antivirus install, but i cannot find the file when searching in my system,
including hidden files/directories.
So now i have no A/V scan, had AVG, which was requesting a virus scan
of the doc before loading -- I removed it, and the virus scan message
disappeared, but the document still doesnt load.
I reinstalled office and also tried deleting the normal.dot file and
ran word to create a new one. All have not given me a solution. Also did a repair from the help menu in word without help.
BTW from within Word/Excel i can go to the open menu, and open any file
without difficulty, but I cannot tolerate this problem. Anyone else
with a sililar problem and possibly a solution.
Thanks in advance.
kraven
 

A:Canot open Word / Excel 2003 Files

16 more replies
Answer Match 84.42%

Let's say I have data contained in Excel with each piece of data in an adjacent cell...

Name: Rank: SSN#:
Smith, John R SSG 123-456-7890

How would I take that information and merge it into a memorandum in Office, all in separate documents?

So say the memorandum looks like this:
Whomever it may concern,

Smith, John R., SSG, United States Army, 123-456-7890 has been certified blah blah blah blah

Sincerely,
Me

So if I had 50 names it would produce 50 documents or something?

Is that even possible?

A:Merging Data From Excel Into Word (2003 Or 2007)

I think you can use Mail Merge to do this kind of thing.

I'm guessing your spreadsheet is in the .CSV format?

If you are using 2003, I'm not sure what the headings are at the top, but with 2007 you need to choose the mailings tab and then select start Mail Merge.

Select the Wizard and you should then have an option somewhere down the line to import a data source.

After doing this you should be able to insert the merge fields which should look like <<Surname>> or something like that.

From this you should then be able to create a template letter and print all the records out.

Hope this helps,
Cornzey

7 more replies
Answer Match 84.42%

I have searched various forums, including this one, so I'm not sure there is a way to resolve this problem.

Every time I start Excel or Word [Microsoft Office 2003 Pro] I have to rearrange my toolbars. When I start Excel [for example], I'll arrange my toolbars [including dragging them]. After I have them all moved where I want them, I'll use Excel and then shut the app down. When I restart Excel, the toolbars will no longer be in the places I moved them to earlier. I have to rearrange them every time!

Is there a way to lock the toolbars in MS Office 2003 Pro, specifically Excel and Word?

Thanks!

Joseph
 

A:MS Office 2003 [Locking Excel/Word Toolbars]

8 more replies
Answer Match 84.42%

This is a sub routine designed for Excel 2003 that calls the 'Save As' routine and allows the user to input their own file name and directory etc. I would like to convert it to a Word 2003 routine can anybody show me how or suggest a method by which I can do the same in Word ? Word doesn't recognise the 'Application.GetSaveAsFilename' method in this routine.

I have tried using a MsgBox to define a file name and the use the ActiveDocument.SaveFileAs to save the file but I can't allow the user to choose his own directory using that method and its clumsy !

Dim file_name As Variant

' Get the file name.
file_name = Application.GetSaveAsFilename( _
FileFilter:="Excel Files,*.xls,All Files,*.*", _
Title:="Save As File Name")

' See if the user canceled.
If file_name = False Then Exit Sub

' Save the file with the new name.
If LCase$(Right$(file_name, 4)) <> ".xls" Then
file_name = file_name & ".xls"
End If
ActiveWorkbook.SaveAs Filename:=file_name
End Sub
 

A:Solved: Convert a Excel Sub to work in Word 2003

Try this

Application.Dialogs(wdDialogFileSaveAs).Show

Rollin
 

2 more replies
Answer Match 84.42%

hi

i have the hardest time trying to get the formatting in otlook 2003 right; basically, i need to send a press release so i draft a cover letter ; after that, i paste the press release (in word 2003) into outlook; it looks fine before sending but when i send it to myself (both in oe and outlook), the received mail's format doesnt look quite the same as what was sent

ie. some paragraphs are underlined and i cant seem to get rid of it; i tried the reveal code to figure out where the underline came from but no luck so far
 

More replies
Answer Match 84%

I am using Microsoft Word 2003. I have an excel spreadsheet which has a list of percentages e.g. 4.50%. When i do a mail merge in word to merge this percentage into a letter it comes up as 4.999999999999etc. To round this down I hit Alt F9 and type \#0.00 to round it down to 2 decimals but instead of it coming up with 4.50% it changes it to 0.045. My question is how do i get word to merge it into the exact format: 4.50%?
 

More replies
Answer Match 84%

Hi,

I have been grappling with the following problem for weeks, and would be so grateful of any assistance!

I have Microsoft Outlook 2003 and Word 2003 installed, and I use Word as the default mail editor.

1) However, occasionally when I try to REPLY to or FORWARD a message from a Hotmail email address, I get the following error:
"Microsoft Word is set to be your default editor. However, Word is not avaliable, not installed or is not the same version as Outlook. The Outlook email editor will be used instead."
It is strange that this error only seems to occur with Hotmail accounts.
I get this error with emails which are sent with or without attachments.

2) And whenever I get this error, and I try to open an e-mail I get a message saying "starting microsoft office word as your e-mail editor" which takes for ages and nothing happens.

3) In Tools-> Options -> Mail Format, the option which allows one to select Word as one's mail editor, magically becomes "unticked", even though it was ticked.
I have to then re-tick it, but if I try and forward or reply one of these mails again, the box will magically unticked and the error message will still appear.

4) Also in connection with this error, when I want to close Word I get the following message:
"Changes have been made that affect the global template - normal. Do you wish to save those changes?"

I am running Windows 7, if it makes any difference.

Many thanks in advance... Read more

A:Word 2003 as Outlook mail editor problem

Check to see if winword is running as aprocess in the background after you close Outlook. Hit alt-ctrl-del and open task manager and look in the processes tab.
 

2 more replies
Answer Match 84%

I have a folder in Word 2003 called "Cooking". I get e-mails (Outlook Express) from Cook's Illustrated, with recipes contained therein. How do I transfer them as a titled file to the "Cooking" folder in Word 2003?
 

A:Solved: Moving e-mail part to Word 2003

12 more replies
Answer Match 84%

Hi,

I was wondering if anyone had any ideas to fix the following problem:

http://support.microsoft.com/kb/278214

Thanks a lot,
Danny
 

More replies
Answer Match 83.58%

I am using Excel 2003 to create a database of hyperlinks to different paragraphs and then through the use of a macro I can create word documents. I inherited this macro from a different department and want to customize it for my needs. That being said I have no idea how to edit a macro this large and complex. What's the best way for me to post the macro and my questions, through email, message through this site, post it in this window? The macro is about 15 pages in length. Thanks.
 

A:Excel 2003 - Macro for creating word document question

First, welcome to the forum!!!

The best way for one of the Excel gurus to work on your problem would be to post your file, after you have removed any confidential data (make a copy and do the editing in it). If it is too large, zip it first (and zip is preferred to rar).
If you are unable to post the file (there seems to be a problem at times with people who don't have very many posts being able to attach files) just send me an email via my profile (include the URL link to this thread). I will respond to you and then you can send it to me, after which I will post it for you.
 

1 more replies
Answer Match 83.58%

Well I'm puzzled and intrigued by the following:

I have two macros.
I started with one triggered in Word to search and replace for a string and replace with with another one.
The mcro opens an Excel file and stores the necessary data in an array and then the array's values are used to search and replace the corresponding strings in a word file:

Below is the code that works if you use it in Word
where fString is the search to look for and rString the string to replace it with, works perfect no problem here
Code:

Sub FindColALL(fString As String, rString As String)
' Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = fString
.Replacement.Text = rString
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = True
.MatchWholeWord = True
.MatchByte = False
.CorrectHangulEndings = True
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = False
.MatchFuzzy = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
End Sub

Now I decided to do it the other way. Open Excel, read the contents into the same array, then Open work (VBA references set and everything)
and do the same but calling it from Excel but the above code will not work,

Seems it doesn't recognize the Word commands even if the references are set.

I now use the following code... Read more

A:Solved: VBA Search and Replace (Word and Excel) version 2003

10 more replies
Answer Match 83.58%

For the past two weeks I have noticed that hyperlinks placed in email I am sending are being stripped by Outlook. I use Word 2003 as the email editor. I can write an email, insert (or have automatically convered) emails but if I either send or save those emails, the hyperlinks are removed. The problem does not occur if I use Outlook's email editor.

I have made no setting changes on my system, except moving from XPSP2 beta to XPSP2 Final.
 

A:Word 2003 hyperlinks stripped in Outlook 2003

Security by MS turned on by default in the final version.
 

2 more replies
Answer Match 83.58%

Hello,

I originally posted this question on November 3, 2010 in the Email section and in spite of many views, there were no replies. That is when I thought I might be going about asking the question the wrong way.

Windows XP - SP3 Microsoft Word and Microsoft Outlook 2003

I use Word as my email editor for Outlook. I had had a problem or two awhile back and I used the Detect and Repair Function that comes with Outlook 2003. Problems cleared up HOWEVER I got a new and IMHO worse problem: my emails that are advertisements like Newegg, TigerDirect, Overstock, etc. are fine but anything else that is actually text that is sent to me comes in very, very small and I can not find a way to change it. I have looked everywhere in Outlook; Microsoft online, and Google. Sample attached.

I can't find it and it is driving me crazy. If anyone could help, I'd sincerely appreciate it!

Thank you for your time.
 

A:Word 2003 used as email editor for Outlook 2003

Hi and welcome to TSG.

From the main Outlook Mail screen, try ...

Tools ->
Options ->
Mail Format Tab ->
"Fonts ..." button in Stationery and Fonts section ->
"Choose Font ..." button under "When composing and reading plain text"
 

1 more replies
Answer Match 83.58%

This appears to be a common problem, with many solutions, though I have yet to find one that works for me. When using Outlook 2003 with Word 2003 set to be the email editor, Word opens and works fine to CREATE a new email. However, when trying to REPLY TO or FORWARD an email, I get the error message "Microsoft Word is set to be your email editor. However, Word is unavailable, not installed, or is not the same version as Outlook. The outlook email editor will be used instead...," and when I click OK to that message the native Outlook email editor opens. Word 2003 worked fine with Outlook 2003 replying to or forwarding emails till this morning, but the behavior described above now applies. The OS, by the way, is Windows 10. I have tried to both "repair" and "reinstall" the 2003 Office 2003 suite, both to no avail. Would appreciate a much needed solution to this puzzle.
 

A:Outlook 2003 Can't Use Word 2003 As Email Editor

15 more replies
Answer Match 83.58%

Okay I have 2 issues that I can't figure out if there is a way to get word to act the way I want.

When not using word as an email editor and you compose an email but do not send the email. Then you perform a file/print this printout prints the person the email is from, the To and CC and the subject and the body of the email.

When you turn on Word 2003 as the editor you only print the body of the email with no subject and no To and CC.

When not using word as an email editor and you add contacts the interface shows the To people from the contacts list as Firstname Lastname; Firstname Lastname and so on.

When you turn on word as the email editor you get Firstname Lastname <email>; Firstname Lastname <email>

Is there any way to run with Word 2003 as the email editor but have these 2 functions work the way outlook operates without it being the editor?

Basically I have a woman who loves using words advanced clipart and other functions but has to have these 2 settings to be enabled (the non email address showing just the contact name and the format of the whole email being printed not just the body)
 

A:Oultook 2003 with Word 2003 as email editor

shameless bump still not solved.
 

2 more replies
Answer Match 83.16%

I am looking for help in writing a macro that will do the following.

With Excel 2003 open and the current workbook open. The macro should be able to save 3 variables from the current spreadsheet (some text, a value and a date ) The macro should open up Outlook 2003 as a task, attach the current workbook. In the Subject field of the task it should add the user's name, then the attached spreadsheet's filename then the text variable, then the value variable and finally the date.

Also it would be great if the Priority of the task could be set to High and the Start and Due dates set to 3 calendar days before the date variable.

Finally the macro would set a list of people the task is assigned to. The macro should NOT save the task as a check would need to be done manually.

I have tried unsuccessfully to write a macro in Outlook as I cannot seem to access the attachment filename or any data from the file. I have tried a macro in Excel which I can create a task and add some text to the Subject of the task but with no real progress on the attachment.

I have tried searching the net for help but a lot of code for Outlook is for the mail side of things rather than tasks and the little code snippets I have found have been of limited use. I have limited skills in programming Visual Basic and C so quite prepared to get my use code which does similar things
 

More replies