Log In
Register
Home
June 26, 2016
Offline
Hello everyone my name is Maurizio
And my problem and this:
In Excel Sheet2 with Microsoft Office 2007
I created a routine that by taking specific data into the various cells.
He opens an e-mail sheet for me and fills it in all its parts; And so far so it's ok
But what I just can't solve is to get them to upload the attachment that is inside the call sub-folder (Oggetti_Salvati).
Since I was trying more solutions, I would like you to be able to solve the Routine of Module 1
All here Thank you now for all the help you'll be able to give me about
Greetings from A.Maurizio
October 5, 2010
Offline
Hi Maurizio,
You can use Application.FileDialog(msoFileDialogFilePicker) to let the user choose the attachment.
I've unmerged the cells on the sheet - merged cells are not good - and made a few adjustments to the code itself, see attached.
As it is, if no attachment is specified the code exits. You can change this behaviour by removing the else statement after Application.FileDialog
regards
Phil
June 26, 2016
Offline
Hi Philip
How you are always Sublime in your work.
I wish I was even half of you !!!!!!
Listen arrived at this point : It would be possible to know if it was possible to have a link that can explain to me how to use another email sheet as Gmail I Thunderbird of Mozilla ; While keeping your job
So and a way to learn better without continuing to make you work Thank you
Greetings from A.Maurizio
1 Guest(s)
