Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If text then email macro
Hey all,
I am looking to create a formula or a macro that will email information from a row based on whether there is text in a certain cell in that row. And apply this solution for every row that will contain text in that column. I've been using Ron de Bruin's macro (VBA code) to set-up the email, which works perfectly to create individual emails based on the information, but I'm hoping to have this automated based on whether any text is present or not, and have this apply to each row. A possible issue is that the text in this cell is based on information from another sheet and will not show up on the active sheet until it is entered on the indexed sheet. Ie. =IF(ISNA(MATCH(ROW(A1),Main!K:K,0)),"",INDEX(Main! B:B,MATCH(ROW(A1),Main!K:K,0))) I hope I've explained this well enough...Any help would be appreciated! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email Macro | New Users to Excel | |||
Email Macro help! | Excel Worksheet Functions | |||
Email macro | Excel Discussion (Misc queries) | |||
How do I create an email macro to auto fill the email? | Excel Discussion (Misc queries) | |||
Macro To Email XLS | Excel Discussion (Misc queries) |