VBA set reminder and followup via outlook.

your code seems like a muddled combination of code from different places
can't tell if you understand what bit of the code does what?

Anyway, your using a function called RangetoHTML(rng As Range)
which i can presume you mean to be the one made by Ron de Bruin

Please Login or Register  to view this content.

Here is what i think your code might look like
see attached example