Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Mail Merge (Excel 2000)

    Greetings:
    Trying to use excel to do a complex mail merge into a word document. The address block is filled in when a cell in worksheet 1has a positive number. That number's information is contained in worksheet 2. Each number is unique to contact information which is located in worksheet 2.
    If the number in the cell is negative, it then references another cell in Worksheet 1 and goes to worksheet 3 to merge that information into the address block.
    Can't seem to get a formula (or something else) to do this? Any ideas???!!!!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Mail Merge (Excel 2000)

    I am not sure I follow what you want the formula to do. Could you be a little specific?

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Mail Merge (Excel 2000)

    I want the formula to make choices based on the information in a cell (positive vs negative number) and merge information from the choice. For example, when doing the mail merge, can a formula be created to look at a cell and if the number is "86" it goes to another worksheet and gets address information to merge into the address block. If the number in the cell is negative, it goes to another cell to look at a number which references information in a third worksheet. The information referenced in the third worksheet is then merged into the address block in the Word document.
    Have I confused you yet? Don't mean to do that---just a problem posed to me by staff member.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel Mail Merge (Excel 2000)

    Something like the hypothetical

    =IF(source>0,VLOOKUP(source,addresslist,offset,FAL SE),VLOOKUP(source2,addresslist,offset,FALSE))

    (this formulas does the second lookup operation if the source<=0, rather than only if source<0)
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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