Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Oct 2002
    Location
    Blue Mountains, New South Wales, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts
    My employer has configured my PC with Office2003 and Groupwise7

    Mail merge does not work.

    I wish to send a simple email.
    In Word the document.sendmail command will not let me add a recipient email address, but it will let me use the message of the Word doc as the text of the email
    In Excel I can use recipient:=recipient@domain.com but the Excel doc goes as an attachment.

    How can I send an email with text from VBA to an email address entered via the program rather than via a dialog box?

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,978
    Thanks
    0
    Thanked 207 Times in 188 Posts
    Hi Blue Moses,

    Please explain "Mail merge does not work".
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Star Lounger
    Join Date
    Oct 2002
    Location
    Blue Mountains, New South Wales, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by macropod View Post
    Hi Blue Moses,

    Please explain "Mail merge does not work".

    When I use MAIL MERGE to SEND EMAILS, it does everything except send an email. I can use MailMerge to produce individual letters to print, but I think maybe my employer has disabled the email feature somehow <grrr>

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,978
    Thanks
    0
    Thanked 207 Times in 188 Posts
    Hi Blue Moses,
    I think maybe my employer has disabled the email feature somehow
    I that case, I suggest that's the place to start - find out whether this is intentional or perhaps a system fault. After all, if there's a fault, it may inhibit a vba solution and rectifying the fault might be all you need for a mailmerge to work. Conversely, if its due to a company policy, your efforts to get around it might not be well received ...
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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