Hello
i want to add attachments when sending mail i wish to use ThisWorkbook.Path because folder name change
.Attachments.Add
Hello
i want to add attachments when sending mail i wish to use ThisWorkbook.Path because folder name change
.Attachments.Add
Last edited by dodde; 05-28-2020 at 07:12 AM.
Hi,
I suggest you do a search on this forum, there are quite many similar questions which with some editing can be made to work for you.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hello
ok i do so
If you find something you can use and need additional help, just tell us.
I also suggest you attach a sample file with non-private data for testing and where you explain everything
Hello
I try to modify because i did not find, but i miss some thing because the file will not attach, but i dont get any error
see line i red
Please Login or Register to view this content.
First of all, are you sending using Excel or is this Outlook VBA?
You are forgetting to create item
[code]
With OutMail.CreateItem(0)
.Display 'or use .Send
.To = ""
.CC = ""
.BCC = ""
.Subject = "Prisoverslag " & ThisWorkbook.Sheets("Tilbud Voortman").Range("S5").Value
.HTMLBody = strbody & "<br>" & .HTMLBody
.Attachments.Add Destwb.FullName
'You can add other files also like this
.Attachments.Add ThisWorkbook.Path & ("\Supplerende_bestemmelser_til_8415 EMV.docx") '("C:\test.txt")
'.Attachments.Add ("C:\test.txt")
Hello
i have this line also, here is code
i get error paste in code so i put the wb here
Please Login or Register to view this content.
Last edited by sintek; 05-28-2020 at 06:41 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Hello
This work thank you
It sholud have stand Thank You in your Reputation
Last edited by dodde; 05-28-2020 at 07:14 AM.
Good to know it works
..........................
THANKS.gif
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks