E-mail range

[mikelever]

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 !!

[VBA Noob]

See if link helps you out

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

VBA Noob

[mikelever]

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 ?

[mikelever]

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 !

[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

[mikelever]

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 ?

[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

[mikelever]

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 !

[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

[mikelever]

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 !