Vba code

i need someone that is good with vba. i need vba code to send an email attachment via a macro. i.e when a button is clicked a file is created, attached to an email with email addresses. I also need a macro foe various copy and paste. For example copying from a1 to j26. Also if a new line is added i want the macro to still work and not just stop at j26 for example