Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Wilmington, NC
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AutomergeField???? Where are my variable names?

    Hello,
    I'm running a mail merge in WD2K pulling List data from Excel2K. When I use the insert Mergefield dropdown list, it only shows AutomergeField and AutomergeField1. It was previously listing my actual fieldnames, so I'm guessing I somehow goofed up on the Insert Name process when I defined the Headernames as dynamic ranges using Insert Name Define.
    I've since taken that out and renamed the column labels the old way, but no use. Any ideas?

    I've X-posted this in the Word Forum

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    New Zealand
    Posts
    295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AutomergeField???? Where are my variable names?

    Mark, I would try and attach the merge again, by clicking on the Merge Helper in Word and opening the source document again. This should work through and find the correct range of cells.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Wilmington, NC
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AutomergeField???? Where are my variable names?

    Thanks Mike, but no joy. Heres a new wrinkle-I finally just copied the new labels and ranges into an older workbook that wasn't having any merge problems, inserting a new worksheet on which to past them. Now Word will show the new labels (in this case being used as a header for field names) but doesn't show any that are still on the previous worksheet (which I did however, rename). This is my first Excel project, so I hope I'm not being glaringly stupid.

Posting Permissions

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