Count Data Then Send To Correct List

Hi,


I have a spreedsheet with a list of areas and items which are in that area.
I need to be able to count the number items in the area and send the count to the area Distribution List until the list ends.


Thank you for time


Nurofen

The data doesn't pair off, London is not London Send Count, how do you match them?

Hi Xld,

Sorry that was just so i could show what I wanted to match.

London Send Count would just be London and then the email address.


Nurofen

Hi,

I've been able to change a cell value and send email to London List, but i'm not sure if it right, if it is right how do i make the same happen for other cells and send to other areas? I'm stuck

Any chance someone can help with the countng number before sending to please.


Thank you all for your time


Nurofen

Hi,


I'm using offset to go do the rows until it hits a cell with something in it how do i show that count of rows before it hits a cell with a value, count entered in cell D8.

Thank you for your time

Nurofen

Got your PM,

What are you actually trying to count in this?

Is your intent to actually place the value in D8?

What exactly do you want the email part to do? It seems you want to send London their total (count?), and each other their respective totals....

but then you also want to send all 4 areas total(count?)

Would be happy to help out, just clarify what it is really want to happen here.

Hi XLGibbs,

Thanks

I just want to count the amount of item for the area and send a email to the correct Distribution list. London has 6 item, copy 6 to the email with a bit of text then send to London list.
the item amount will change so my intent is put the count where ever the count finishes.

Sending all four area counts is just a backup just in case I need to send the information to one person or list

I hope this clear

Thank you for taking time to help

Nurofen

Well, it is clear, and I can likely find a solutoin, but emailing from excel isn't my forte and I would be searching the board for answers same as you. I will post what I can get together tomorrow sometime. Calling it a day for now.

Hi XLGibbs,

No Problem, what ever you can do i'm sure will be helpful.
I'll will be searching too.



Thanks again


Nurofen

Hi,

I found code at Ron's Excel Tips about emails which works on an E address located in A1 of every sheet I have attached a example of how it would work for me but my only problem would be the increase areas would mean more and more Tabs.
Can this be done for match data and send to correct Distribution list?

Please don't think i'm all over the place and not sticking to my original question, i'm just trying to find code and ideas to maybe put together my request to meet my original question.

Thank you for any help


Nurofen

Hi Nurofen,
What does this mean?

Quote:

---

Can this be done for match data and send to correct Distribution list?

---

Hi Lucas,

I want to be able to count the items in London and then
match london to the Distribution list and send the email with the count and same for the others



Thank you for you time



Nurofen

The key here is finding or create code that will simply send the email. From there, doing the count, and or passing the email addresses from a list through that sendEmail mod is much easier.

I am buried with a sudden server issue for work and won't be able to help out today as much as I had hoped.

Hi XLGibbs,

Quote:

---

The key here is finding or create code that will simply send the email. From there, doing the count, and or passing the email addresses from a list through that sendEmail mod is much easier.

---

Sorry But my understanding of what you said is find/create a code that will send the email after the count is complete to the correct list.

Quote:

---

I am buried with a sudden server issue for work and won't be able to help out today as much as I had hoped.

---

No problem XLGibbs hope all gets sorted.

Thank you for taking time to help

I'll carring on searching if I can find anything or someone has a code thats does what you said..


Thank again

Nurofen

What I mean is, it is easier to compartmentalize the tasks.

Primary task: Get code that sends an email directly (not just the dialog box)

Secondary task: modify the above to accept variables passed to it for send To, subject and body.

Third piece: build code that gathers the information to send through the email sub in Secondary task.

Parts 2 and 3 are really simple for me to help with. Part 1 I don't have any experience with, but if you have Outlook, there is tons of code here that can be modified.

XLGibbs,

Quote:

---

sends an email directly (not just the dialog box)

---

Yes I have Outlook just set it up today. Can you just expalin a bit more about the above and I will start searching.

Thanks

Nurofen

Just do a search for "send email outlook excel"

Once you have a procedure that can send an email (send it to yourself for testing) on the click of a button, we can work off that.

http://vbaexpress.com/forum/showthread.php?t=15913 which I have started in the Excel Help

I need help with this sorry i can't be more clear.

Primary task: Get code that sends an email directly (not just the dialog box)


Thank you for your time


Nurofen

I didn't see that post XLGibbs


I've just posted the question in the Outlook Help section

http://vbaexpress.com/forum/showthread.php?t=15925

But i will search for that now


Thanks you really for taking time to help mate :friends:

Nurofen

XLGibbs


I've got that if thats right I hope it is, whats next mate



Nurofen