dn1509
06-10-2010, 04:15 AM
Dear all,
I am new to this forum so forgive me if this should go in a different forum. Excel is the main or 'host program in what I am trying to achieve so I felt it best fit here.
I have a spreadsheet which is nothing fancy at all - basic columns with manually entered information. I want to be able to highlight one row across 4 columns and have a macro button which will take the information and insert it into certain locations on a pre-existing Word document. I do not need it to save at this point (though this is functionality I may wish to incorporate later).
For example, say columns A, B, C, and D hold my data. I then want to highlight A1 : D1 and click the macro button. This will take the cell values and insert them into the word document as follows:
----------------
Dear A1,
Thank you for your letter dated B1. Your query has been forwarded to our C1 department for further investigation. Should you have any queries please contact your HR representative, D1, who will be happy to assist you.
Regards,
Dominic
----------------
Please note this is a very crude and fundamental example of what I am doing, but there is no need to go into great detail and hopefully this gives you the idea of what I am trying to achieve.
If I need to be clearer on something then please do let me know.
Any help you can offer greatly appreciated!
Regards,
Dominic
I am new to this forum so forgive me if this should go in a different forum. Excel is the main or 'host program in what I am trying to achieve so I felt it best fit here.
I have a spreadsheet which is nothing fancy at all - basic columns with manually entered information. I want to be able to highlight one row across 4 columns and have a macro button which will take the information and insert it into certain locations on a pre-existing Word document. I do not need it to save at this point (though this is functionality I may wish to incorporate later).
For example, say columns A, B, C, and D hold my data. I then want to highlight A1 : D1 and click the macro button. This will take the cell values and insert them into the word document as follows:
----------------
Dear A1,
Thank you for your letter dated B1. Your query has been forwarded to our C1 department for further investigation. Should you have any queries please contact your HR representative, D1, who will be happy to assist you.
Regards,
Dominic
----------------
Please note this is a very crude and fundamental example of what I am doing, but there is no need to go into great detail and hopefully this gives you the idea of what I am trying to achieve.
If I need to be clearer on something then please do let me know.
Any help you can offer greatly appreciated!
Regards,
Dominic