Dear All,

I've created a file wich can send standard emails for me to my customers.
In this email I need to add some specific data for the customer.
In this case i need to add Serial Numbers.
The problem is, the number of serial numbers keeps changing.
sometimes it are 4 numbers, the other time there are 40 numbers.

I need to copy paste the numbers from different sources so i created a range of cells
in wich i can paste the rawdata.
In the email layout i've created a range of cells with =CELL formulas to the Rawdata.
This way I can make sure I keep the correct font/fontsize/etc.

so it looks like this:

RAWDATA RAWDATA RAWDATA RAWDATA
RAWDATA RAWDATA RAWDATA RAWDATA
RAWDATA RAWDATA RAWDATA RAWDATA
RAWDATA RAWDATA RAWDATA RAWDATA
RAWDATA RAWDATA RAWDATA RAWDATA

____________________________________

HEADER EMAIL

TEXT TEXT TEXT TEXT TEXT TEXT TEXT
TEXT TEXT TEXT TEXT TEXT TEXT TEXT

=RAWDATA =RAWDATA =RAWDATA =RAWDATA

TEXT TEXT TEXT TEXT TEXT TEXT TEXT
TEXT TEXT TEXT TEXT TEXT TEXT TEXT


Is there a way with macro or formula to auto create or delete rows
in the email section.
For exsample, if the first row of =RAWDATA contains data, then create new row.
Or if the first row only contains 3 cells with data, then delete the second row.

I hope you understand the question, and that somebody can help me!
Thanks in advance