Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Location
    Tulsa, Oklahoma, USA
    Posts
    10
    Thanks
    8
    Thanked 1 Time in 1 Post

    Complex MailMerge (Word2000)

    I want to use MailMerge to merge data from an Access database into a Word table, where one field (CustOrderNo.) may have more than one entry at any given time for each customer (CustNo.), so that CustNo.1 may have CustOrderNos. 1, 2, 3, and 4 (each with its own date and description), all of which need to be merged into the table. The options offered by the "If... Then... Else..." Word Field do not allow me enough flexibility to do this since the CustOrderNo. may be any multiple digit-number at all, with corresponding different dates and descriptions. Any ideas on how to get this done?
    Cyndie Browning
    Tulsa, Oklahoma USA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Complex MailMerge (Word2000)

    Hi Cyndie:
    Can you do a query in Access that will give you what you want & then use that query as the data source of your Mail Merge?

    Alternatively, I might be able to figure out an IF field in Word. Perhaps you could post a document with a small table that would show what headings you want in Word. Do you envision a table where the Customer number is duplicated (with one for each order) or just one customer number?
    Cheers,

  4. #4
    New Lounger
    Join Date
    Feb 2001
    Location
    Tulsa, Oklahoma, USA
    Posts
    10
    Thanks
    8
    Thanked 1 Time in 1 Post

    Re: Complex MailMerge (Word2000)

    Good news! Using the WD2000 "work-around" as an example, I actually got MY merge to work!!! (in theory, anyway.... we have yet to try it on our actual database). Thanks to you and Phil Rabichow for your excellent suggestions. Also, my boss was verrrrrry impressed that I had a source (Woody's Lounge) to go when I had a problem I couldn't solve on my own, and even more impressed that y'all responded so quickly. Thanks muchly!! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
    Cyndie Browning
    Tulsa, Oklahoma USA

Posting Permissions

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