word 2007

Good morning, all. I am trying to create an Excel spreadsheet that will accurately feed a Mail Merge labels document. In my data, I have the following: Item Units ax2 7 ax3 5 But, what I think I need to do is show 7 occurrences of ax2 - to print out 7 labels - and 5 occurrences of ax3, to...

Howdy, Excel world. Here's one I haven't even seen before. I have a program that opens a Word doc, links it to a worksheet and merges. So far, kindergarten stuff. Since I have a number of different types of docs I produce daily, each with its own set of data fields, the page I link to is...

I am reasonable familiar with VBA for Excel but new to Word VBA. I have cobbled together a couple of simple Word macros and assigned keyboard short cuts. These worked successfully for a while but suddenly for no reason I can discern the hot keys stopped triggering the macros and whenever the hot...

Hi, I created a series of custom quick parts on Word 2007 and I need to distribute these quick parts to other computers. I saved the custom quick parts in Normal.dotm and have emailed that folder to other computers and saved over that computer's normal.dotm found in...

Hi all, I've got a complex workbook with lots of linked data - on one sheet there are 8 fan charts showing financial data. When I paste the charts as pictures into Word 2007 , everything is fine. This is all on XP. However, when I try to paste special them as linked Excel Chart objects, 4...

I am using a spreadsheet to feed a mail merge in word, and I've run into a problem: on sheet1 Column A through O contains data that I paste in from another workbook, Column P contains the following formula; =IF(NOT(ISBLANK(A2)),VLOOKUP(TRIM(A2),Sheet2!A:D,4,0),"") and is working fine. However...

I'm creating an automated report in Word which will enable someone to enter data (based on several observations from different sites) into excel, and then create a report summarizing this information from a template Word document. The Word document has been created and Mail Merge has been used...

Hi-- I have multiple school groups for one school name/contact -- how do I get them to merge into one doc. for each contact? The wizard just picks up each row and it creates a new doc. for each line... so a contact with 15 schools gets 15 docs.... this is what my excel doc looks like. <table...

I have a macro in Excel 2007 that interacts with Microsoft Word. I apply the Microsoft Word 12.0 Object Library in order to access the necessary commands. However, when an Office 2003 user tries to use the macro, he gets an error. This is because Office 2003 uses the Microsoft Word 11.0 Object...

I'm having trouble creating a report, in Word, from Excel. Every other time I try to execute the macro, I get an error 426. I did a search and found someone else with the same problem: http://www.mrexcel.com/forum/showthread.php?t=124028&highlight=remote+server+machine And his problem was...

Recently switched to Office 2007 and when trying to mail merge in Word using an Excel 2007 data file, I keep getting an error message "Word was unable to open data source". I tried clicking on New Source and choose ODBC DSN and then Excel Files, but that doesn't work either. I can copy the...