Combine 2 RonDeBruin macros - Mail+Attachment+Body - Based on value in A Column

I'm not sure, it would be easier to determine if you could attach a workbook but I would suggest trying this:

Please Login or Register  to view this content.

I've changed the arguement when you call the function from Rngx to Rng, you don't appear to define anything for Rngx before that point...

Hi, thanks for helping.
that's true - actually I tried to define each range as RngX earlier - but then it did only copy the last range no matter what I tried.
No I tried to go aroung with different ranges for each value, but I dont know how make the macro understand when to create the html copy for each range...

Anyhow - I've attached a sample file to my inital post.

thanks again

Try this:

Please Login or Register  to view this content.

Works like a charm!
Super many thanks..

I can see that you entered (cell) under my .Body statement,
and (rngx) under the function name.

Are you able to explain me the meaning here?
That RNGX will take information from "cell" as standard value, and that rngx will be the startpint from where the function search for my values?

Anyhow - many thanks!
// Joakim

Yeah basically, you can pass a variable from one macro to the other by defining it with:

Please Login or Register  to view this content.

and then when you call the macro, you can assign either a variable from the existing macro to it:

Please Login or Register  to view this content.

so when I use that to call macro_1, variable_1 has the value thisisastring and variable_2 has the value 1.

I made some other changes as well, mainly to the rangetohtml macro.