+ Reply to Thread
Results 1 to 2 of 2

sending emails using macro button from excel, with variable data

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    5

    sending emails using macro button from excel, with variable data

    Hi,

    I'm hoping to add a macro button through VBA to a worksheet that will automatically create and send an email (to address in cell I) if the content of cell M is 'printed'. Then, I would like the subject line of the email to contain (after a standard greeting) the contents of cells B,C,D,E followed by a standard message.

    Then, in the body of an email, a short standard message.

    I have had success using aspects of coding taken from other places, but can't seem to get the whole thing to work!

    HELP! And many thanks.

    GShep

  2. #2
    Registered User
    Join Date
    09-20-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: sending emails using macro button from excel, with variable datFoa

    Forgot to upload sample!
    Attached Files Attached Files

+ 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