ORDER 9001KR1G







This is what it looks like when the range is emailed, I am attempting to see only ORDER 9001KR1G, I prefer not to see the empty cells that have no text in them, there may be multiple cells in this Colum that contain text I would like to see them in the email. The column I am setting the text up is G, the comparisons I am using is in the column for E and F, with E being the actual count, and F being a set minimum. My comparison statement in G is =IF (E4<F4, "order 9001ke5H2",") this statement goes down the entire G column with different Part numbers to be ordered.

Thanks,
For any and all help