+ Reply to Thread
Results 1 to 1 of 1

Excel select cell on condition for Mail Merge Word

  1. #1
    Forum Contributor
    Join Date
    Hendersonville, TN
    MS-Off Ver
    Excel 2010

    Excel select cell on condition for Mail Merge Word


    I hope someone can help out on this issue. I have an excel workbook that feeds to a Word Doc mail merge. I am having issues constructing a workable merge field on one entry of the word document.
    From my worksheet I have 3 different cells to pull data. One is an Identifier with either 95941 or G0453 as an entry. The others are calculated times. One in hour units. The other in 15 min increments.

    Data pull sheet is A2:BK2

    My goal: If identifier 95941 (cell T2) is listed in the worksheet, then take hours from Cell Z2 of my sheet. If the Identifier G0453 (cell T2) is listed, then take time from BK2. The time selection should then go to the Merge field of the word document.

    Any thoughts?

    Attached is a screen shot of some of the Word Document. Highlighted is the field I am working on.

    Many thanks in advance,
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Running Word Mail Merge from Excel 2010 - Mail Merge workbook fails
    By pl05.lau@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  2. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  3. Word Mail Merge & Excel
    By Olasin in forum Excel General
    Replies: 2
    Last Post: 11-23-2007, 10:44 AM
  4. Mail Merge from MS Excel to word
    By wei82 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2007, 02:50 AM
  5. [SOLVED] Mail Merge Excel - Word - PDF
    By GastonFranzini@gmail.com in forum Excel General
    Replies: 0
    Last Post: 04-20-2006, 04:45 PM
  6. word to excel mail merge help please....
    By jojo in forum Excel General
    Replies: 4
    Last Post: 09-22-2005, 10:05 AM
  7. merge with Word How can I get excel to mail merge zip codes plus 4 correctly?
    By Kathy at Sauder Feeds in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2005, 07:05 AM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1