Repeat macro for next row

[MagicMan]

Hi Team,

I've got a macro that will create an email based on the active cell and inputting relative content in to the email from the worksheet

As it stands, it only works on the activecell. How would I change my coding so that it does the active cell, then goes to the next row (same column) and repeats until the end.

Here's the code (I've had to strip out some of the HTML coding)

Please Login or Register  to view this content.

In the example, I would want an email to be formulated for Fred Bloggs, then another for Joe Soap then another for "Another Person" through to end.

Any help would be greatly appreciated.

[Artik]

Try:

Please Login or Register  to view this content.

Artik

[sintek]

Please Login or Register  to view this content.

[Artik]

sintek, I wonder if With CreateObject("Outlook.Application") shouldn't be before the For Each loop.

Artik

[MagicMan]

Artik and sintek,

Thank you so much, both suggestions work and achieve what I asked (I'll rep you guys up shortly)

I have to say there is absolutely NOTHING wrong with sintek's solution, but I'm going to go with Artik's. The reason being that, whether by accident or design, it includes an ability for me to select a certain cell within a row and the macro operates from this point.

If for example I have an original list of 100 people and send the email to them. Then, at a later date, I add another 50 people (effectively rows 101 - 150), I can select the appropriate cell on row 101, run the macro and it will work from that row onward. This could prove to be invaluable.

Thank you both again.

Kindest Regards

MagicMan

[sintek]

sintek, I wonder if With CreateObject("Outlook.Application") shouldn't be before the For Each loop.

Artik

Nope...Then the same Outlook window is edited...That way a new window is created during each loop...

[Artik]

MagicMan, you can also use the sintek code slightly modified

Please Login or Register  to view this content.

It will be even safer as you do not have to select the cell in column C. You can select in any other column. As important is that the active cell is not in a row below the data range.

Artik

[sintek]

@ Artik

Now I see what you meant...Yes, much better than creating App instance al the time...