Mail Merge (??)
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Mail Merge (??)

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need to do something similar to what is called a "mail merge" in Word, but in Excel. I have a form in Excel and I want to be able to add information from another data source (also an Excel file). For example, the form I need to fill in has cells such as Name, ID #, Date of Birth, etc, and the data source is a list of members with this information in an excel file.

    I tried pasting the form into Word, but it was too large and I couldn't reduce it to fit the page. I also tried creating a chart in Word, but not all of the values came out. Any ideas? I asked earlier, but the suggestions were too complex. Are there any simple solutions?

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you only have a few items a vlookup would work... If more than that I would have to gove it some thought.

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The form has 10-15 blanks to fill in.

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Would it be too much work to setup the vlookups for wach entry - and then manually select them for the print out ?

    Or, so you want complete automation like a maile merge ?

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mail merge would be easiest, but if that is not possible, VLOOKUP would work. Problem is, I've never used it before and have no idea how to set it up.

  6. #6
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Check this out:

    http://www.thewordexpert.com/tipwarez.htm#MyVlookup

    And also check out:

    http://www.thewordexpert.com/word.htm#MailMerge

    to find out that it probably IS NOT what you want.

    _________________
    TheWordExpert

    [ This Message was edited by: Dreamboat on 2002-04-03 18:38 ]

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    nope, I'm sure what I want is Mail Merge, but I'll take VLookup--a little more manual than I had expected, but will work ok.

  8. #8
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    If you need help let me know, send me an e-mail.... PJ

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com