Over 1 million tech questions and answers.

dollar value in merge excel to word 2013

Q: dollar value in merge excel to word 2013

Addresses and a different dollar value (from a formula) for each addressee are in Excel 2010 and are then merged to a word template (letter) to be printed. Various column formats have been attempted, i.e., dollar value, currency, accounting etc.. The excel is showing the figure as the proper two decimal value, but the merge show the value as multiple figures after the decimal. This merge used to work correctly and it is not known why it does not work now. Can you assist please?

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Pentium(R) CPU G3220 @ 3.00GHz, Intel64 Family 6 Model 60 Stepping 3
Processor Count: 2
RAM: 8130 Mb
Graphics Card: NVIDIA GeForce GT 530, 1024 Mb
Hard Drives: C: Total - 953766 MB, Free - 858513 MB; E: Total - 305242 MB, Free - 198139 MB;
Motherboard: ASUSTeK COMPUTER INC., H81M-A
Antivirus: Microsoft Security Essentials, Updated and Enabled

Copy of example excel entry and word output are in attached .docx file

Note: data submitted is fictitious.

Read other answers
RELEVANCY SCORE 200
Preferred Solution: dollar value in merge excel to word 2013

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

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

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

RELEVANCY SCORE 86

I am having the exact same problem as in the post "Solved: Can't find Access Query when using Word mail merge." I am using Office 365 so I have the newest versions of both Word and Access.

When I try to mail merge starting with Access (right click the query and export to word merge), it tells me it "Could not find file 'C:\Users\Jeanne\Documents\My Data Sources.mdb'" I have a folder called My Data Sources. And yes, the database I want it to go to is in that folder. Of course the folder doesn't have a .mdb after it. What file is it looking for and why? The Access database ends in .accdb. I found some hint somewhere that that might be a problem, but I can't find how to fix it.

When I start the merge from Word, it finds the database fine, but only tables are listed. The link mentioned in the other post is broken, so I can't check that out.

I feel like I'm saying to my son "I'll see you at home" and he says "I can't find the dog." What dog? We don't have a dog, and I never said anything about a dog!!!

I am getting thoroughly fed up with Access! I am fairly tech savvy and can teach myself to do just about anything in excel just through trial and error or looking it up online, but every little thing I try to do in access gives me all sorts of problems!
 

A:Solved: Access 2013 Query to Word 2013 Mail Merge

Read other 13 answers
RELEVANCY SCORE 70.4

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

Read other 1 answers
RELEVANCY SCORE 70.4

I have a single word document letter. I also have an Excel document containing names and addresses. How can I pull these names from Excel and merge them onto the Word Document without having to tpye each address?
 

Read other answers
RELEVANCY SCORE 69.6

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.
 

Read other 2 answers
RELEVANCY SCORE 69.6

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
 

Read other answers
RELEVANCY SCORE 69.6

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
 

Read other 1 answers
RELEVANCY SCORE 69.6

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.
 

Read other answers
RELEVANCY SCORE 69.6

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

Read other 9 answers
RELEVANCY SCORE 69.6

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

Read other 6 answers
RELEVANCY SCORE 69.6

Hello
I need to label 600 Minidv boxes with titles ranging from Tape #1 through Tape #600

Is there a way to do a label merge from Excel into Word 2007 (Label Avery 5167) ? Within Excel in column A I created a text range from Tape #1 down to Tape #600

I don?t know how to export into Word that sequential range of Tape numbers? How can I do this? If I can get those tape numbers to merge into the label document that would save time manual typing 600 labels. Thanks!

A:Excel-Word 2007 Label Merge

These MS websites might help you.

How to use addresses from an Excel worksheet to create labels in Word

Demo: Use the Mail Merge feature to create mass mailings - Word

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

Read other 1 answers
RELEVANCY SCORE 69.6

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
 

Read other 1 answers
RELEVANCY SCORE 69.6

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

Read other 8 answers
RELEVANCY SCORE 69.6

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.
 

Read other answers
RELEVANCY SCORE 69.6

Not as urgent for this one. Trying to merge number values from Excel into a Word document and continue to get 12 decimals no matter what I've tried. Even tried typing them in as text, still gives 12 decimals on merge. Same problem with percentage amount. Any suggestions please?
 

A:Solved: Excel to Word Merge Problem

Not sure why I bother to post problems here since no one EVER helps me and I wind up figuring them out myself. At any rate here's the solution to this one.

In the Word document, in the merge field: right click the merge field and toggle to see the code inside the field (i.e. {MERGEFIELD "Salary"}. To this code, add a formatting switch inside the braces for salary amounts as follows: {MERGEFIELD "Salary" \# ##,###.00}. For percentages: {MERGEFIELD "Percentage" \# #.00}.
 

Read other 2 answers
RELEVANCY SCORE 68.8

In mail merge, when I attempt to select the excel file, it brings up a window
called "Data Link Properties." When I click "test connection" it gives themessage "Test
connection failed because of an error in initializing provider. Catastrophic
failure." This causes word to shut down.

Any ideas on a fix appreaciated.. Thx Russ - Russell.Neuman @ lfg.com
 

A:Solved: Word Merge Connection to Excel failing

Welcome to the forum.

Open the Word document up and have it ignore the connection. Then reconnect to the Excel spreadsheet via the data source option and then you should be fine.
 

Read other 2 answers
RELEVANCY SCORE 68.8

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?
 

Read other answers
RELEVANCY SCORE 68.8

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

Read other 16 answers
RELEVANCY SCORE 68.8

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

Read other answers
RELEVANCY SCORE 68.8

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

Read other 7 answers
RELEVANCY SCORE 68.8

I have an excel file with over 2000 names that I need to make a word merge document out of. I copied and pasted the information from excel into word 2000. I put it all in tables so that it would be separated by the fileds so that I could sort it alphabetical by city and state. But when I go to make the merge document, I already had a letter to merge the names and addresses into, it will not merge. What have I not done, or still need to do? Can someone help me please. I missed my deadline 2 days ago.
 

A:Excel Spreadsheet to Merge Document in Word 2000

Read other 7 answers
RELEVANCY SCORE 68.8

(I cross-posted on the Business Application forum as well because I'm not sure if this is an email problem or a Word/Excel problem.)

I maintain a basic database in Excel 2000 and use Word 2000 to do an email merge. There are about 130 records on the list and the emails go to my outbox in my earthlink account. The first time I did it, I merged all records at one time and everyone received the same email twice. The second time I did it, I merged about 20-30 at a time, in different batches, but it still duplicated everyone. Any suggestions on what's going on and then how I can fix it/create a work-around. (One I've half considered is importing the Excel file to Access and trying it from there...but I'm not an Access expert and I'm hoping someone has an 'easier' solution.)
Thanks in advance for your time,

Michelle L. Coover [email protected]
Creative Memories Senior Consultant
"There is no better time than today to
preserve the stories of yesterday."
 

Read other answers
RELEVANCY SCORE 68.8

I maintain a basic database in Excel 2000 and use Word 2000 to do an email merge. There are about 130 records on the list and the emails go to my outbox in my earthlink account. The first time I did it, I merged all records at one time and everyone received the same email twice. The second time I did it, I merged about 20-30 at a time, in different batches, but it still duplicated everyone. Any suggestions on what's going on and then how I can fix it/create a work-around. (One I've half considered is importing the Excel file to Access and trying it from there...but I'm not an Access expert and I'm hoping someone has an 'easier' solution.)
Thanks in advance for your time,

Michelle L. Coover [email protected]
Creative Memories Senior Consultant
"There is no better time than today to
preserve the stories of yesterday."
 

Read other answers
RELEVANCY SCORE 68.8

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
 

Read other 3 answers
RELEVANCY SCORE 68.8

Hi guys,

So here's what I'm trying to do. Basically I need to create a word document report from data in an access database. The access database basically contains risk items for different entities. So, the report will contain all the risk items for one specific entity and a summary.

What I want to be able to do is enter all this information into the database and then automatically generate the report. The database is basically setup, including the queries I need. I just don't know how get the information over to word in the way need.

The main problem is that I need a summary section that lists the number and types of risks found above, and then the details of each individual risk below. So a very simplified example:

Report for ENTITY 1.

Summary
1 High Risk
2 Medium Risks
6 Low Risks

Detailed Information
Risk 1: RISK 1's NAME
Severity: High
Infomation: This is the information about risk 1.

Risk 2: RISK 2's NAME
Severity: Medium
Information This is the information about risk 2.

...

I know that this is not a standard "mail merge", but I thought it might be possible using VBA. I have used a (very) little VBA, but I am willing to learn more. I just need a push in the right direction as to where I might get the information I need. Several other things I would like to be able to do (but could sacrifice if necessary) are pulling images stored as OLE objects in the access db into the report for each risk and being able to control the backg... Read more

A:Access/Excel merge to complex Word document

Read other 16 answers
RELEVANCY SCORE 68.8

When merging data from excel to a blank word page I keep getting section breaks after each line of data merged from excel. I've tried clearing all formats from excel before merging, when viewing excel in page view there are no breaks. On the word page it is a "new" page completely blank. I insert the merge fields only. I've tried several times each time it inserts "section breaks" and therefore gives me one line of data per page.
How can I get rid of the breaks and or tell how they are being inserted?
 

A:Merge to word from Excel / Automatic section breaks

If you have created a mailmerge main document (the coded file), and you are putting more than one record in it, you must insert the word field "Next record".

Suppose I want to list names and addresses down a document. I'd put it something like this (I cannot include the greater than/less than characters for the merge codes because HTML will not show the text, so I've used dashes instead.)

--firstname-- --lastname--
--street address--
--city-- --state-- --zip--

--nextrecord-- --firstname-- --lastname--
--street address--
--city-- --state-- --zip--

--nextrecord-- --firstname-- --lastname--
--street address--
--city-- --state-- --zip--

--nextrecord-- --firstname-- --lastname--
--street address--
--city-- --state-- --zip--

Word automatically puts a section break between merged letters. If you have a merged letter that does NOT exceed the end of the page, perhaps the information after merging forces it just enough to go beyond the bottom of the page, thus 2 pages. Just delete some paragraph returns in your document. Other than that, I'd need to see the file to see what's wrong and what you're attempting. Email to [email protected].
 

Read other 1 answers
RELEVANCY SCORE 68.8

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
 

Read other answers
RELEVANCY SCORE 68.8

Oh dear! I created a mail merge in Word 2013 and chose the Edit Individual Documents option under Finish and Merge. I edited each and every email to personalize them. There was no option to email directly from that document, so I went back to the original email and sent them all. To my dismay, every person received an email including a [ ] in the space where I had entered their personalized information! Totally embarrassed. How can I email the edited documents??
 

Read other answers
RELEVANCY SCORE 68

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.
 

Read other answers
RELEVANCY SCORE 68

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
 

Read other 2 answers
RELEVANCY SCORE 68

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

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

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

Read other 3 answers
RELEVANCY SCORE 68

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

Read other 9 answers
RELEVANCY SCORE 67.2

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.
 

Read other 3 answers
RELEVANCY SCORE 63.2

Good morning,

I recently upgraded from Office 2010 Pro to Office 2013 Pro. However, after the install, all of the office products are showing as <NAME> (desktop) - i.e. Word (desktop), Powerpoint (desktop). Yet, when they are opened, the program is shown as Word 2013, Powerpoint 2013, etc. When I try to pin a file to the taskbar, it pins it under the Word (desktop) program, but when I open that file, it opens in Word 2013.

I am able to pin both Word 2013 and Word (desktop) to my taskbar. I am ONLY able to pin files to Word (desktop), but files only open using Word 2013. Both options open the same program. It is frustrating to have one program pinned just to have files pinned, only to have those files open in another taskbar "tile."
Why are they separate? Is there any way to get rid of one?

Any assistance is GREATLY appreciated!

-Andrew

A:Updated to Office 2013 Pro: Word (Desktop) vs Word 2013

Hi PrimetimeHero welcome to Windows Seven Forums.

It does seem that you have a duplicate set of short cuts to your Office products.

Normally it is best to store your Office product files in your Documents Library, under their various Folder titles such as Word Documents, Excel Spreadsheets etc. This keep them all in the one area for easy location.

Check to see whether you have duplicate copies of the actual files & if so make sure they are up to date & correct & delete one of them. Then delete the duplicate Shot Cuts then open your Documents Folder in your Documents library. Then locate a file in Documents such as Word xxx & if you want to have a short cut to it on your Desktop, right click on it & use Send To (create Desktop short cut).

As your information is not really clear, perhaps you could post back with more info on where your various Office files are actually located.

Below is a screen shot of my Documents Folder to expalin what I have been saying.

Read other 9 answers
RELEVANCY SCORE 62

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

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

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

I want them to look like this:

John Smith
123 Main Street
Charlottesville, VA 22901

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

_John Smith
123 Main Street
Charlottesville, VA 22901

I've tried everything I can think of.

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

Please advise. Thanks so much!
 

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

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

Read other 3 answers
RELEVANCY SCORE 61.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.
 

Read other 1 answers
RELEVANCY SCORE 61.6

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

Read other answers
RELEVANCY SCORE 61.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:
{ 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.
 

Read other 3 answers
RELEVANCY SCORE 61.2

Hi Greeting for the day!

Am seeking for help do it? i have one excel and one word sheet. in excel i have created commend button if i click button merging should happen step by step in sample document. please help me for using vba code for this. Please find the reference documents in attachments. please let me know so i can provide more information.
Appreciate your assistance.
Many thanks,
Saleemu
 

Read other answers
RELEVANCY SCORE 60.4

Using Excel 2003, I have names and addresses and some other information across 5 different workbooks. I'd like to be able merge these tables into a single table, preserving unique records and avoiding duplicate records. The format varies across the workbooks, but we can make it the same if needed. Tools/"compare and merge workbooks" is currently grayed out. Can you tell us how to do this?
 

A:Solved: help with excel merge (not mail merge)

Read other 9 answers
RELEVANCY SCORE 60

So I've been having quite a large amount of internet problems recently, and all evidence pointed to my router. I've had my Netgear RangeMax 150 Wireless Router for around a year and a half and just today I picked up a Netgear N600 Dual Band Router. It was then that I noticed the 150 did not support online gaming, which ironically, is mostly what its used for... Anyway, I seem to be having an even worse time with the new "Better" router then my old one...

Problems with the old one-v
-Wireless drops constantly
-Slow connections to everything and very laggy online games.

So, as you can see, the issues were getting out of hand, and in the last 3 days my WIRED connection dropped a good 17 times. It was at that point I called my ISP and they came out and supposedly fixed the issue.... But, even with this new router, everything is worse.

Problems with the new one-v
-Pages load almost 3 times slower then before
-During gaming I get a loading icon occasionally (Followed by lag) as well as a very slow startup
-Sometimes pages don't load at all and require a refresh
-Disconnecting constantly just like before on both WIRED and WIRELESS

In addition to this a number of new issues popped up with my Xbox and Xbox Live. Keep in mind I fixed this router up EXACTLY like my old one (Port Forwarding, opened the NAT, disabled Sip Alg), as well as disabling the 5G Net.

New Problems with Xbox-v
-It takes 10-15 seconds to sign in verses less then a second with my old r... Read more

A:New 80 dollar router is worse then my 20 dollar one..?

Read other 8 answers
RELEVANCY SCORE 58

Are there any advantage to using the Mail Merge feature with Office Professional 2013 versus Office Professional 2007?
 

A:Mail Merge with Office 2013

Its a little fancier with more templates and conditional merging, but the basics the same, and still clunky when connecting to access.
 

Read other 1 answers
RELEVANCY SCORE 57.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

Read other 11 answers
RELEVANCY SCORE 56

Hi,
I want to merge two excel files into a 3rd one.

The data are in the files Book1, Book2 and the result in Book3.

I know that i can use VLookup to do the above. But what i have pasted is just an example. The real excel files contains about 9 columns with at many repeating row!!!

Any help will be much appreciated.
Thx
 

A:Excel - macro to merge 2 excel files using a common column

Hi welcome to the board. How are you going to treat the duble items, If you want to merge 2 files adn duplication occurs here must be one cell whihc is common to let's say Book1 and Book2.

Do you have a common value? Index? Whatever you call it?
 

Read other 3 answers
RELEVANCY SCORE 55.6

I'm trying to Merge an Excel spreadsheet to Outlook and provide alerts for critical dates in said spreadsheet in the Outlook calender !
 

A:Excel - Merge Excel spreadsheet to Outlook with Alerts

Welcome to TSG faithtronic.

I've never done it but your thread has been setting here a while. A method to do this here http://www.ehow.com/how_5685419_create-calendar-excel-data.html

I would start with a couple of dates so not to screw up the whole calender! There are some sharper excel folk on this site that might provide a better answer. But this is a starting point?
 

Read other 1 answers
RELEVANCY SCORE 54.8

If I open up a link which has a word document, IE 11 will download and open it. If i then leave word open and then go to another link to and try to download
and open up another word document, the window doesn't become active and it sits minimised in the taskbar flashing. If I click on it to give focus it opens and shows the document I downloaded. This is very annoying. Does anyone have any ideas? I have tried
loading both word in safe mode and IE with no addins and still get the same behaviour.

Read other answers