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

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top