Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help! w/MailMerge (W97 SR-2)

    I'm having problems with mailmerging and emailing the document. As an example: If the "test.doc" has only one sentence in it with one field to merge, the file received by the recipient has two identical sentences with current field record being passed from "test.doc"s attached file along with record #2.

    Another example stated diffrently: Hello <<field to merge>>.

    First message received-
    Hello World
    Hello John

    Next message received contains-
    Hello Mary
    Hello John


    Does anyone have an idea why one record keeps on repeating during mail merge?

    Code=
    With Documents("test.doc").MailMerge
    .MailAddressFieldName = "Email"
    .MailSubject = "Amazing offer"
    .Destination = wdSendToEmail
    .Execute
    End With
    End Sub

  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: Help! w/MailMerge (W97 SR-2)

    Care to post your data file?
    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
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help! w/MailMerge (W97 SR-2)

    Solution: I started a new word doc and copy/pasted the code into the new doc and the code functioned properly. I don't know why but it just does...thanks bill.

Posting Permissions

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