Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    16

    Unanswered: massive mailmerge

    I need to put a whole lot of excel numbers(uniformly spread out through a whole lot of worksheets) into a whole lot of word text. What are my options?

    Here is what I have considered:
    Use brutforce and write a vba code that will put each excel number I want into a predefined bookmark in word file

    Use mailmerge - however I cant figure how to markup the excel document - mailmerge just takes the top values from worksheet and thats not what I want.

    Anything else? tips how to make mailmerge work?

  2. #2
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by NaugGc
    I need to put a whole lot of excel numbers(uniformly spread out through a whole lot of worksheets) into a whole lot of word text. What are my options?

    Here is what I have considered:
    Use brutforce and write a vba code that will put each excel number I want into a predefined bookmark in word file

    Use mailmerge - however I cant figure how to markup the excel document - mailmerge just takes the top values from worksheet and thats not what I want.

    Anything else? tips how to make mailmerge work?
    Hi NaugGc,

    Whereas this is a great forum to come to, I think you posted your question in the improper place. This section is for ACCESS. There is a section in here for EXCEL help just below the Access help link. You might find better and faster help posting in the right place. But nice to have ya just the same.

    have a nice one,
    BUD

  3. #3
    Join Date
    Nov 2004
    Posts
    3
    Quote Originally Posted by NaugGc
    I need to put a whole lot of excel numbers(uniformly spread out through a whole lot of worksheets) into a whole lot of word text. What are my options?

    Here is what I have considered:
    Use brutforce and write a vba code that will put each excel number I want into a predefined bookmark in word file

    Use mailmerge - however I cant figure how to markup the excel document - mailmerge just takes the top values from worksheet and thats not what I want.

    Anything else? tips how to make mailmerge work?
    Word 2000 and above has a Mailmerge Wizard that allows you to link to excel worksheets

Posting Permissions

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