Alan McGowan
Senior Member
- Outlook version
- Outlook 2013 64 bit
- Email Account
- Exchange Server
I am looking for a way of sending data from a userform in Outlook to an Excel spreadsheet.
At present the userform contains three textboxes and I need the data from the text box to pass to three cells in the spreadsheet on the same row e.g. textbox1 to A1 and textbox2 to B1 and textbox3 to C1 etc. If A1 already contains information then textbox1 would go to A2 and textbox2 to B2 and textbox3 to C2.
Can anyone suggest a solution or some directions to get me started.
Thanks
Alan
At present the userform contains three textboxes and I need the data from the text box to pass to three cells in the spreadsheet on the same row e.g. textbox1 to A1 and textbox2 to B1 and textbox3 to C1 etc. If A1 already contains information then textbox1 would go to A2 and textbox2 to B2 and textbox3 to C2.
Can anyone suggest a solution or some directions to get me started.
Thanks
Alan