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. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

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

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

    Paul Edstein
    [MS MVP - Word]

  4. #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>

  5. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,866
    Thanks
    0
    Thanked 179 Times in 165 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
  •