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
Bookmarks