Hi Guys
I have a 2 column listbox which stores file path and File name of a file. I want to write VBA code so that when save button is clicked then an email gets sent to e.g Test@gmail.com with an attachment of the files stored in the listbpox. So the listbox first column stores Filepath and second column stores FileName. Suppose there are 2 files stored in the listbox then 2 files need to be attached to an email .
Any help will be much appreciated.
Thanks
I have a 2 column listbox which stores file path and File name of a file. I want to write VBA code so that when save button is clicked then an email gets sent to e.g Test@gmail.com with an attachment of the files stored in the listbpox. So the listbox first column stores Filepath and second column stores FileName. Suppose there are 2 files stored in the listbox then 2 files need to be attached to an email .
Any help will be much appreciated.
Thanks