Consulting

Results 1 to 2 of 2

Thread: Complex mail merge

  1. 03-30-2005, 05:36 AM #1
    N Prakash
    N Prakash is offline
    VBAX Regular
    Joined
    Nov 2004
    Posts
    11
    Location

    Complex mail merge

    Hi! friends,

    I have sorted list of data where ENO. is the key field. Each ENO. belongs to one employee. Each one is having multiple accounts and different balances are outstanding. I want to creat a mail merge document furnishing the details of each ENO the details of their account as at the end of each month. When ENO changes the new letter is to be generated in a new page. I have tried to use IF field in the braces by clicking CTRL+F9, but I am not getting the desired result.

    Can any body help me please. sample data in MS Excel and sample Letter in Word format is attached.

    regards,
    Prakash N
    Reply With Quote Reply With Quote
  2. 03-30-2005, 05:58 AM #2
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    This question has asiren before, never fully solved. Have a look here
    http://www.vbaexpress.com/forum/showthread.php?t=76
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules