Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    Ames, Iowa, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge Macro HELP (Word 97)

    I'd like to create a macro that will run a mail merge where the data source changes everyday and the user must select the file to use during the Opendatasource portion of the macro.

    I've done this successfully ages ago... but can't for the life of me remember how.

    Thanks

    JC<img src=/S/smile.gif border=0 alt=smile width=15 height=15>


    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Macro HELP (Word 97)

    Isn't that what the merge help tool does?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    Lounger
    Join Date
    Apr 2001
    Location
    Ames, Iowa, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Macro HELP (Word 97)

    Ah gheeze <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Yes of course... but I need to kick off a macro that only allows the user to pick the file to use as a data source... then it completes the merge straight to a new document. Very primative user here... going to have the macro kick off on opening the merge document, goes to the opendatasource automatically to the correct network directory allowing him only to pick the file to use for the merge. It's a daily file and all he needs to do is pick the file named with today's date, click open and the macro will complete the merge to a new document.

    Can't get the macro to NOT tie to a specific file. I've done this before... I believe with a query in place of the file name... but can't remember the correct syntax.

    Thanks for your support

    JC)

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Macro HELP (Word 97)

    Yeah, that Helper tool is fine the first time you investigate
    mail merge. After that it just gets in the way.

    Well, you can alway use

    dialogs(wdDialogMailMergeOpenDataSource).Show

    to open then process the data source. Does that help?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  5. #5
    Lounger
    Join Date
    Apr 2001
    Location
    Ames, Iowa, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Macro HELP (Word 97)

    Dialogs.... [smacking self in forhead]

    Dang... it's Friday... and Friday the 13th no less... jes let's pretend I was never here...

    JC<img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Cairns, Queensland, Australia
    Posts
    885
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Macro HELP (Word 97)

    <hr>[smacking self in forhead]<hr>
    There's no need for that, try this smiley <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22> <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Granville

  7. #7
    Lounger
    Join Date
    Apr 2001
    Location
    Ames, Iowa, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Macro HELP (Word 97)

    <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>

Posting Permissions

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