Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

Unable to complete merge process.

When merging an excel spreadsheet with a word doc, I am asked to confirm data source in a window that shows several ".xls sources". I've tried cliking on each one, but each one states "word was unable to open data source". As long as I've been doing mail merges, I have never seen this window before???

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

Make sure you have closed the "data source" your excel file before trying to merge. This has been throwing different errors but not allowing the merge process to continue.

Is your Excel data in various worksheets or in the same worksheet - And does your Excel source data contain headers in the first row. Once you have selected this from the range you will

At what stage are you failing in the merge now?

Posted on May 21, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

HOW DO I CREATE A DATA BASE FOR FILE LABELS USING AVERY LABELS 6646? THANK YOU, BARB KOWALSKI


you can do it in excel
then mail merge excel file with
word https://support.office.com/en-us/article/Mail-merge-using-an-Excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3

and use avery template in word
http://www.averyproducts.com.au/avery/en_au/Templates-%26-Software/Templates

Jan 27, 2017 | Avery Office Equipment & Supplies

2 Answers

Can information on an Excel spreadsheet be transferred to a Word spreadsheet to use as a "Word Merge" document, and if so, what is the procedure for this?


go google and type in --user manual for excel--
there is a pdf version for download , around 900 pages which explains in detail everything you need to know on how to do what in excel
there are shorter version that deal with specific topics so cruise the sites until you get exactly what you want

Jan 18, 2017 | Excel Computers & Internet

1 Answer

When using Mail Merge, how can you make Word 2007 ignore any Blank cells in Excel 2007?


  • Open the Microsoft Excel 2007 spreadsheet file on your computer that contains the blank cells that you want to merge.

  • 2

    Use your mouse to select the adjacent blank cells that you want to merge together. The cells you want to merge should then be highlighted in blue.

  • 3

    Click on the "Home" tab and then click on the "Merge and Center" option from the "Alignment" group. The blank cells will all be merged and centered.

  • 4

    Click on the arrow next to the "Merge and Center" option and then click on the "Merge Across" option if you don't want the blank cells centered.

  • 5

    Select the merged cells and then click on the "Merge and Center" button again at any time to split the cells.

  • Mar 07, 2011 | Computers & Internet

    1 Answer

    When I try to merge my excel document with 250


    Hi deloisr

    It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
    Check these
    Do you have column headings for every column?
    Make sure which folder contain the file? What exactly is the name?
    When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
    The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
    Have a good day.
    luciana44

    Nov 09, 2009 | Microsoft Computers & Internet

    1 Answer

    Merge two records in ms works 2000


    The easiest way I could think to do this was using text formulae concatenate - The issue I thought you might have was the lack of spaces between each entry - hence the " "

    =CONCATENATE(B2," ",B3," ",B4,B5,B6)

    Jan 25, 2009 | Microsoft Office Standard for PC

    2 Answers

    Mail Merge won't print


    AppleWorks is a quirky and hopelessly outdated product. I am aware that a few people have an extreme fondness for it however.
    It should only have taken minutes to import data, but don't do it in AppleWorks - they stopped making it years ago and it is unsupported and non-standard.
    I have just taken two AppleWorks databases, - one older and one newer that needed to be combined. I exported them as tab delimited text and then imported them into Excel (You could use Apple Numbers - the modern equivalent to AppleWorks). Because the to db's had different headers, I imported them into two different Excel docs first and moved the columns around so the matched first, them copy each column over to the 'master' excel sheet.
    You can either use the basic database tools in Excel, or once your data is combined and in this kind of data form, it is easy to import a .xls, or .csv into a new database program, such as Filemaker.
    If you do copy over the data to Excel, any merge function - for label printing etc. has to be done in Word (or at least up to Word 2004). I was thrown by this until I realised you have to do this. Once a merge doc is set up with the right labels, it worked beautifully. Typical MS though it is a wholly unintuitive process.
    Copy and importing data should be done with attention to care obviously. Make sure you have your original AW files backed up before you start.

    May 20, 2008 | AppleWorks 6 for mac

    1 Answer

    Mail Merge Print Problem


    Was a recipient address created in an Excel spreadsheet or a database? Data needs to be pulled from somehwere to be added to the envelope.

    Dec 05, 2007 | Dell Latitude D800 Notebook

    Not finding what you are looking for?
    Microsoft Office Professional 2007 Full Version for PC Logo

    183 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2658 Answers

    Piyal Perera
    Piyal Perera

    Level 3 Expert

    528 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18389 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...