Finding a macro to copy cells and send to one email address in outlook

[missmops]

Hello,

Please can someone help me - I have been trying to do this for three days and am thinking it is impossible but I know it must be possible so is getting very frustrating!

I have a form in excel (very simple) that I need to put on the web - People can then fill out certiain bits of the information and the idea is that they then click on the button to email it back to me. Ie complete it there and then and email it straight away so that they don't need to save it etc.

I can't for the life of me work out how to do this! I've managed to get the macro to open an email with the correct details on but not paste in the information so am at a complete loss and appear to be going round in circles!

Any help would be really appreciated - I've already tried copying numerous codes but as I'm so new to this haven't got a clue about what the coding means etc so can't spot where I'm going wrong.

Thanks
Joanne

 

[Gigi_]

hi
i think you must give more details
os version
excel version
mail manager version
and, if possible give an example of your form to better understand your needs
edit:
cms type and version

 

[missmops]

Hello,

It's Microsoft Outlook 2010 and Excel 2010 if that helps?

Thanks
Joanne