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.

Need to send some cell data from Excel to Outlook Email

Discussion in 'Business Applications' started by GRIMESJ, Oct 18, 2012.

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

    GRIMESJ Thread Starter

    Joined:
    Oct 18, 2012
    Messages:
    1
    Hello,

    I am trying to figure out how to get MS Excel to send a few cells of data to an email address. We are a fire department whose dispatch is using an excel spreadsheet as the dispatch log. The goal is for the data to be entered into a few cells. Column H1 would ask to "send page". If 'Y' is put into the cell then an email automatically be with the data in this format:

    c1 d1 e1 f1 g1
    type;location;street address;details;report #


    The email pushes an alert to responders smart phones through an ap.

    Thanks!
     
  2. CDHarm

    CDHarm

    Joined:
    May 26, 2011
    Messages:
    255
  3. 20_2_Many

    20_2_Many

    Joined:
    Jun 29, 2012
    Messages:
    518
    Hi Grimes,
    This certainly can be done, and seems to be a common question here. If you use the Search box near the top of this page, and search for Send Email from Excel, there are quite a few all ready coded examples. Make note of your version of Excel, and email program and OS to help narrow down which to select.
     
  4. hariexcel

    hariexcel

    Joined:
    Nov 16, 2012
    Messages:
    5
    Dear All,

    I would like to seek your advice to find out a solution for the below query:
    Daily I would be having plenty of documents on hold which I need to intimate to respective people for the reasons on the same : so…..
    Every time I need to send an e-mail for these to concern people , so I wanted to create a macros for sending an e-mail from the excel on their respective documents: so here is the same format
    E-mail should be in the below format

    Dear Sir/Madam,
    Your Doc# and Code # is on hold due to the “reason”, please provide us the clarification to process further
    Data is like below
    A B C D
    Doument # Code Reason fo hold E-mail id
    12 1 Due to Mismatch [email protected]

    13 2 Wrong doc [email protected]

    15 3 amount mismatch [email protected]

    17 4 Wrong Details attached [email protected]

    19 5 Wrong person details [email protected]

    21 68 Due to Mismatch [email protected]

    23 455 ddsss5 [email protected]


    Please provide us the Macro code for the same , Thanks in advance
    Your’s friends
     
  5. hariexcel

    hariexcel

    Joined:
    Nov 16, 2012
    Messages:
    5
     
  6. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    Hari,

    Don't hijack this thread please start a new thread of your own.




    Rollin
     
  7. Sponsor

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/1073185

  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