+ Reply to Thread
Results 1 to 2 of 2

VBA EMail

  1. #1
    Registered User
    Join Date
    01-26-2010
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    23

    VBA EMail

    Hi,

    Hope everyone is well.

    How do i edit the below code that automatically sends an email the the specified address, i need to change it so that it allows me to write a message in the message body of the e-mail and then i will click send on the email manually?

    Please Login or Register  to view this content.
    Basically i would like it to do all of the above but stop right at the point of sending so that i can write a message and then click send?

    Regards,
    Jamie

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: VBA EMail

    I'm not sure that is possible using SendMail.

    You will more than likely need to use Outlook and then display the message rather than just sending it.

    There are some very good code examples here: http://www.rondebruin.nl/sendmail.htm

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1