Hi all,
I like to experiment in excel to learn new things (as I am still relatively unexperienced), but sometimes I feel I am trying to reinvent the wheel. This is also the case for what I am trying to accomplish right now.
See, I want to create an excel template with “fill-in-the-blanks” boxes to create a standardized outlook e-mail for purchase requests for me and my colleagues. When the blanks are filled in, the user of the excel (e.g. me) only has to push a “send” button. Then, when the superior that has authorization to actually purchase the indicated products receives the mail, he can easily fulfil the request (easy, because of a standardised form for requests).
The request format should generate a mail looking something like this, with the underlined text as filled-in blanks:
''
Hi Richard,
I have the following purchase request(s) for you, regarding the production of apple pies.
<tbody>
</tbody>
If you have any questions about my order request, please contact me on 079-44251826.
Thank you in advance,
Greetings Max
''
I think you get the idea. It seems very likely to me that someone, somewhere already ‘developed’ something very similar to this. I hope that that someone can share this with me, so I can tweak it to my intended use. Thank you in advance!
Max
I like to experiment in excel to learn new things (as I am still relatively unexperienced), but sometimes I feel I am trying to reinvent the wheel. This is also the case for what I am trying to accomplish right now.
See, I want to create an excel template with “fill-in-the-blanks” boxes to create a standardized outlook e-mail for purchase requests for me and my colleagues. When the blanks are filled in, the user of the excel (e.g. me) only has to push a “send” button. Then, when the superior that has authorization to actually purchase the indicated products receives the mail, he can easily fulfil the request (easy, because of a standardised form for requests).
The request format should generate a mail looking something like this, with the underlined text as filled-in blanks:
''
Hi Richard,
I have the following purchase request(s) for you, regarding the production of apple pies.
Product ID | Product description | Quantity | Supplier ID | Req. delivery date |
22023 | Butter | 2 | 076 | Monday, April 29 |
83391 | Pastry | 9 | 339 | Friday, April 26 |
4653 | Eggs | 50 | 23 | Monday, May 6 |
etc. | - | - | - | - |
<tbody>
</tbody>
If you have any questions about my order request, please contact me on 079-44251826.
Thank you in advance,
Greetings Max
''
I think you get the idea. It seems very likely to me that someone, somewhere already ‘developed’ something very similar to this. I hope that that someone can share this with me, so I can tweak it to my intended use. Thank you in advance!
Max