merge excel with word

  1. cvincent

    Excel VBA to Run Mail Merge with Word

    I have been able to use vba somewhat, by lookiing into other file codes, but I need a lot of help! I have an excel file, "Estimate of Charges Worksheet.xlsm", with calculations on one tab. Those calculations transfer over to a hidden tab in the file with named columns for the data. That tab...
  2. cvincent

    Connecting to Word Merge Doc

    I have an Excel 2010 worksheet, with a macro to open Word 2010 and merge the data into a letter. It works fine the first time I use it after opening Excel. But after that, it won't work again until I close out Excel and re-open. Any ideas why this is happening? Even though Word is not...
  3. K

    Creating documents from an Excel file

    I receive an Excel file from our customer with 6 lines of contact info (from a single merged column F&G:4-F&G:9) at the top of the sheet and 1-to-25 lines of stuff ordered (10 columns B-K, rows 19 to end of data) across the bottom of the sheet. I need to print purchase orders from this sheet for...
  4. cvincent

    Excel 2007 VBA to Merge Selected Data into Word Merge Form

    I am attempting to utilize data from my Excel file to merge into a Word form. Users can use search buttons to filter selected data, which is then copied to a tab entitled "Selected Contacts". I can then run a macro that opens my Word 2007 merge document, but I am unable to create the code to...
  5. K

    Merging Excel Files = Formatted Word or PDF Report

    I'm trying to merge two Excel files and output a single, nicely formatted pdf or Word report that combines the two Excel spreadsheets. Could you please tell me if that is possible and if so, how? I'm looking to take the results of an online form (40% of the final report information), that...
  6. A

    Users locking spreadsheet

    I have a spreadsheet that I use for merging for details to word forms on a regular basis. My problem is that a colleague often opens the spreadsheet to obtain data and this then stops me from either using the spreadsheet to merge or from entering new data (using a user form). Is there...
  7. L

    Merging Excel Charts with Word Document

    Hello. I have searched and searched and can not seem to be able to find a solution to a question asked of me. Is there a way you can merge an Excel spreadsheet with Word and have the accompanying chart/graph change in each record?
  8. J

    Merge Excel into Word

    I have a Word document template & need to fill in the blanks (blanks= name, address, phone, misc info, etc, etc...) So I also have an Excel template where I can fill in those blanks. How do I merge/link the two documents?? I know how to link excel worksheets, cells etc...but I have to send...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top