1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Email sending from Excel programming

Discussion in 'Business Applications' started by shashank1320, Nov 1, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. shashank1320

    shashank1320 Thread Starter

    Joined:
    Oct 31, 2012
    Messages:
    2
    Hello All techies here,

    I am very much new to this forum.I am aware that it is possible to send emails from Excel using VB programming but I am very much unaware of VB programming and tricks.

    I am working on a work where I need to generate automated mails from excel via outlook based on the contents of the selected cell and some logics.

    Here is the URL for image that will give some rough idea.

    https://fbcdn-sphotos-d-a.akamaihd.net/hphotos-ak-snc7/s480x480/391681_552548121437857_52068638_n.jpg

    or
    https://fbcdn-sphotos-d-a.akamaihd....480x480/391681_552548121437857_52068638_n.jpg

    or
    [​IMG]


    from this sheet(shown in image) I want to generate mail with logic like this :


    case 1) If i click on MSS in row ABC ,click on APD and then press " @ " then it should generate a mail like below and send it to [email protected] and cc : [email protected]

    subject : "card request"

    mail body
    **********
    Hello,

    My name is ABC (i.e. A2 content).
    I need to have some MSS card of APD type
    value 1
    value 2
    value 3
    if above cards are not present then we can also use VD
    value 4
    value 5
    value 6



    Regards,
    Shashank1320
    *************



    case 2 )but if I press MCS in row ABC ,APD and then press @ then it should send mail to [email protected] and cc : [email protected]

    subject : card request
    mail body
    *****
    Hello,

    My name is ABC (i.e. A2 content).

    I need to have some MCS card of APD type
    value 1
    value 2
    value 3

    if above cards are not present then we can also use VD
    value 4
    value 5
    value 6



    Regards,
    Shashank1320
    ****


    case 3)
    if I click on MSS ,VD and then press @ then its it should send mail to [email protected] and cc : [email protected]

    subject : " card request "

    mail body
    *****
    Hello,

    I need some MSS card of VD type
    value 4
    value 5
    value 6

    Regards,
    Shashank1320
    *****


    same goes with row XYZ and PQR.
    @ in row ABC will send mail to [email protected] cc to [email protected]
    @ in row XYZ will send mail to [email protected] cc to [email protected]
    @ in row PQR will send mail to [email protected] cc to [email protected]

    One important thing to note :
    either of MSS or MCS will be used to generate the email for required type.and it should be generating the mail for based on 3 things MSS/MCS , APD/VD and @.


    Also MSS values are
    value 1 :1011
    value 2 :1012
    value 3 :1013

    Value 4 :1014
    value 5 :1015
    value 6 :1016



    MCS Values are
    value 1 :2011
    value 2 :2012
    value 3 :2013

    Value 4 :2014
    value 5 :2015
    value 6 :2016



    I know it will be a logic defined for the cells Type1,type2,card1,card2 and generate mail and whole thing will work only by clicking these 5 cells in a row.
    I tried very basic VB ,it worked but I cant event think for this high funda logic.

    I am using office 2007 at home on my laptop and using 2003 in office workstation.(mainly the tool will be used on office workstation only)

    I really appriciate all your help and suggestions.
    Thank you in advance.
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    Welcome to the forum,
    I suggest you do a search for similar posts, give or take minor differences they all come down to the same solution.
    Once you've found something taka a look and try it out.
     
  3. shashank1320

    shashank1320 Thread Starter

    Joined:
    Oct 31, 2012
    Messages:
    2
    Sorry,but I still didn't get anything more or less specific to this..

    I will appreciate if you could help me out
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    Have you rtied to look and search?
    I'm not.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1074962

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice