+ Reply to Thread
Results 1 to 2 of 2

Excel Marco: Compose Mail from Excel

  1. #1
    Registered User
    Join Date
    05-16-2011
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    16

    Talking Excel Marco: Compose Mail from Excel

    Please Login or Register  to view this content.
    Hello,

    I have the above code. The code will compose a new email with a selective subject based on a cell.

    Now, I came up with this coding using internet resources but could not get it to output a cell value (string) as the subject of the email. Is it possible? If then how should I approach it?

    In a sense, I want the subject to be

    "<Cell Value> Vendor Request"

    Thanks in advance!

    Edit:

    I put in

    Please Login or Register  to view this content.
    but gave me error
    Last edited by Vibu212; 05-24-2011 at 12:19 PM.

  2. #2
    Registered User
    Join Date
    05-13-2011
    Location
    New Zealander in London
    MS-Off Ver
    Excel 2007
    Posts
    74

    Re: Excel Marco: Compose Mail from Excel

    Quote Originally Posted by Vibu212 View Post
    I want the subject to be
    "<Cell Value> Vendor Request"
    I have changed the following lines in your above code. This might work a little better for you:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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