+ Reply to Thread
Results 1 to 10 of 10

E-mail range

  1. #1
    Registered User
    Join Date
    10-02-2007
    Posts
    12

    E-mail range

    Hi all,

    I have finaly been able to put in words what I want to do. Hope this makes sense. I have the excel document should anyone want to see it.

    In worksheet “Summary table”, column A is a job number (Txxx), that worksheet is a summary of all the jobs. If you select a job number and run a macro (lets call it macro5) it will then give you a detailed / itemized listing of the job in a separate worksheet. I already have created macro5 for the detailed bit. However now I am looking for a macro that will lookup the email address in worksheet “Tenacity jobs” corresponding to that job number and then email the result of macro 5 to the user.


    So, for example, I begin in worksheet “Summary table” I would like to see the details on job # T456 which has a subtotal of 420,227.05. I click on this and it runs macro5 showing me the detailed breakdown. However once that macro has run I would then like to email this off to; cha@velocity.com; laur@velocity.com as they are the contact people which corresponds to #T456 in worksheet “Tenacity jobs”

    Any help as to how I can do this would gladly be appreciated !!

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    See if link helps you out

    http://www.rondebruin.nl/sendmail.htm

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    10-02-2007
    Posts
    12
    Quote Originally Posted by VBA Noob
    See if link helps you out

    http://www.rondebruin.nl/sendmail.htm

    VBA Noob
    Yup, looked at that and tried to incorporate it into my worksheet and macro. Unfortunately it was way past my knowledge and was getting errors.

    all I am looking to do is lookup a senders address which can be found in sheet2 and mathes job number T123

    Plan b ?

  4. #4
    Registered User
    Join Date
    10-02-2007
    Posts
    12

    Plan b

    Ok, so here's a logical alternative that I've thought of just need help with the code.

    If B1 = today then

    1. Find the value in A1
    2. Execute macro5 based on the value of A1
    3. Email it to address in C1

    I know this is in basic english but it would really be appreciated if anybody could help !

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Mikelever,

    What is to be emailed? Do you have a subject line that will sent as well? If so, what cell is located in?

    Sincerely,
    Leith Ross

  6. #6
    Registered User
    Join Date
    10-02-2007
    Posts
    12
    Quote Originally Posted by Leith Ross
    Hello Mikelever,

    What is to be emailed? Do you have a subject line that will sent as well? If so, what cell is located in?

    Sincerely,
    Leith Ross
    Hi Leith,

    Thanks for the reply.

    after the macro has run it copies and pastes a detailed breakdown into a separate worksheet, that is then sent off. Subject line isnt critical but it can be job number ie T456.

    If it makes things easier i can post the file onto an FTP site ?

  7. #7
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Mike,

    If you can zip the file, you can post here it here at the forum along with your post, provided it is less than 100Kb. It would be helpful to see your workbook.

    Thanks,
    Leith Ross

  8. #8
    Registered User
    Join Date
    10-02-2007
    Posts
    12
    Quote Originally Posted by Leith Ross
    Hello Mike,

    If you can zip the file, you can post here it here at the forum along with your post, provided it is less than 100Kb. It would be helpful to see your workbook.

    Thanks,
    Leith Ross
    Hi Leith,

    Book4.zip

    Ive simplified things quite a bit in this attachement but everythings there.

    My problem still remains as in the first post in this thread.

    thanks !

  9. #9
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Mike,

    Looking at the Workbook, the emails are on the "Tenacity" sheet, but the URLs are in column "D" not "C". Did you make a mistake in your previous post? Is it the "Summary" sheet you emailed, but I can't find Macro5???

    Thanks,
    Leith Ross
    Last edited by Leith Ross; 10-08-2007 at 07:33 PM.

  10. #10
    Registered User
    Join Date
    10-02-2007
    Posts
    12
    Quote Originally Posted by Leith Ross
    Hello Mike,

    Looking at the Workbook, the emails are on the "Tenacity" sheet, but the URLs are in column "D" not "C". Did you make a mistake in your previous post? Is it the "Summary" sheet you emailed, but I can't find Macro5???

    Thanks,
    Leith Ross
    Hi Leith,

    My apologies. To clarify; the url's are in "D" not "C" my mistake. I have also included macro5 for your reference. However it wont work as it requires all the data to be there. The entire Excel file size is 31mb !

    Book4.zip

    Thanks for all your help so far !

+ 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