+ Reply to Thread
Results 1 to 2 of 2

VBA to send a message from outlook.

  1. #1
    Registered User
    Join Date
    10-13-2006
    Posts
    1

    VBA to send a message from outlook.

    I am sorry to ask such a basic question, but I am trying to use VBA for the first time. I am trying to write code that will look up a cell in a spreadsheet and if the value of the cell is YES, it will generate an email in outlook. The email will have a standard title and content, but it will have blanks that need to be filled with data that is generated within the spreadsheet.

    Is there anyone out there who would be able to help me with this.

    Many thanks,

    Nicola

  2. #2
    Registered User
    Join Date
    10-26-2004
    Location
    Portland, Oregon
    MS-Off Ver
    Excel in Windows
    Posts
    49
    That is not a basic question, especially for a beginner! I can't teach/walk you thru the whole process but here are two pages that helped me do this:

    http://www.rondebruin.nl/sendmail.htm
    http://support.microsoft.com/default...b;en-us;161833
    ~Toby

+ 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