Trying to reference multiple cells in an email body that satisfies a condition

[Cygneous]

Hi, is it possible to create an automatic email that sends the person the UPC, name, size, and cost when the supply status says "running low" for multiple rows if there are multiple cells that are running low. I tried looking at a table, but I don't know how to get specific cell rows that have "running low" status.

[vba_php]

there are a million ways to do this. what email client are you using? i'm assuming outlook?

[Cygneous]

Yes, I am using outlook

[Cygneous]

This is what I have so far:

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new, I have done it for you today.)

[vba_php]

so Cygn,

Does the code you posted actually work? does it create the mail item and send like you want it to? if so, I'm assuming all you are missing is the looping of the data and filtering the bad parts out, right?

[Cygneous]

I had to fix some things, but when I try to run this code, it gives me an error saying "object variable or with block variable not set" but the email still goes through. However, I want the email to include the UPC, name, size, and cost for the ones that are running low. Right now, it just says "Need to order more of these materials:067 Digital Rave is running low "

Please Login or Register  to view this content.

[maniacb]

Assuming the UPC code in in Column A, I added code to include the item from that Row in Column A. Try it out.

Please Login or Register  to view this content.

[Cygneous]

This sends a separate email for each row in the sheet whether it's running low or not. In the end, I want it to send only 1 email, containing all the info in the row that are running low. For some reason, it won't allow me to post my code...

[maniacb]

@Cygneous please post your file so we can troubleshoot further, as per the yellow banner above.

[Cygneous]

This sends an email if the status is running low, but not sure how to reference the info in the rows.

Please Login or Register  to view this content.

[Cygneous]

This sends a seperate email for each row in the sheet whether it's running low or not

Please Login or Register  to view this content.