word 2007

  1. K

    Returning Multiple Occurrences of an item

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

    Word merge keeps old fields

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

    Word VBA - shortcut keys suddenly triggering a rogue dialogue box

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

    Transferring Custom Quickparts

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

    Excel 2007 - incorrect chart pasting into Word

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

    Return Blank if FALSE

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

    How to include tables in Mail Merge using hyperlinks

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

    Merge data into word - multiple rows in one doc?

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

    Microsoft Object Library compatibility between 2007 and 2003

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

    Automation Error -- I Need a Guru!

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

    Error Message: Excel 2007 data file/Word 2007 mail merge

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top