tables vba for/next

Hi, I am looking to make emails for each line in excel that reads Y email is needed. It would take the line and make a table to send to users. Anyone done this vba before? I am just finding selected ranges and big tables pasted to outlook. I would it to loop each line to create bulk emails.

PLEASE HELP!!! This community has never let me down and I doubt you guys will start now!! I have a table on a Data tab. This data has multiple values for the Vendor Name column. I need to create separate sheets based on each individual vendor name and name each sheet by each vendor. I don't...

hi everyone, I'm not the best in marcos and I've been searching for a solution to this for a while. So what I'm doing is copying a table in a worksheet into another worksheet and transposing it. Some worksheets that contain the original tables can have a lot of tables which is way a marco...

MR. Excel Help Hi all, I am having trouble with a delete row macro for one of my tables in excel. When I run my "Call_Delete_Row" code in an existing table after I open my excel spreadsheet, the last row for two tables on two different sheets are deleted. However, AFTER I run...

I have a table where I need to find the elements present in different samples. For every sample, the no of iterations is a variable - I can have two rows of sample 1 and 3 rows of sample2 or 5 rows of sample4. the number of columns which are the elements can also be different. I have considered...

I have created several tables on an excel worksheet and I need help creating a VBA code that will move the rows into the table that they belong in when I add more data. For example if I have a tables based on the color of notebooks and in the table it includes the price of the notebook and the...

Hello, I have a worksheet with two tabs, each tab has one table. Tab "Main" has a table called "Current" and tab "Past30Days" has a table called "Old". I need the macro to look in the "Date" column in the "Current" table and if the date is past 30 days from today to cut the row and paste/add...

Hi all! I was trying to make use of table/list functionality (filtering and referencing) while looping. I was thinking it might allow for something more efficient /elegant than what we have which loops through every row with if/then statements. I am starting to think I am making it more...