Hello, I have tried to add a file as an attachment. I have the path and want part of the file name to be from column B in a excel spreadsheet.7
Only part of the filename to be searched for and then all files with that data from column B in their filename attached to the email.
In column B it wold be a 5 digit number re.g 41532 and the filename would start T41532
Thank you or any help provided
Please Login or Register to view this content.
Last edited by UltimateNeo; 09-28-2019 at 03:39 AM.
Perhaps...Untested
Please Login or Register to view this content.
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 [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Hello I tried your code, but get a runtime 438 error object doesn't support this property or method.
on the
Please Login or Register to view this content.
Post all your code....And a sample of your exact setup...
It is just a basic email, attaching the pdf file that has a filename of T41234 - name - initials.
In excel sheet column B I have the T41234 without the T as the T is put in the subject line of the email.
Please Login or Register to view this content.
Thank you for your help
This is from Post 1...Why change to"C:\mypath\"
Is there a file to be added at that specific path...Please Login or Register to view this content.
Declaration as per below means...Path is declared as a variant, File as string
Have to specify...
And it is...Please Login or Register to view this content.
Sorry did not pick up earlier...Please Login or Register to view this content.
Last edited by Sintek; 09-28-2019 at 01:18 PM.
Thank you I changed the code as you stated but it cant find the file pat his correct and file is there I changed the name from T54321 to 54321to see if that helps but it still cant verify and find the file
Please Login or Register to view this content.
Then it is not where the path says it is...hat helps but it still cant verify and find the file
Right click on file and check properties...See if path is as per coded path...
These are also not specified...
Please Login or Register to view this content.
I got it to find the file when I rename the file 54321, But it wont find it if I call it T54321
Thank you for your helpPlease Login or Register to view this content.
It also seems to just check row 3.
I made a file called 34212 and it finds that one but if I go to next row with 54321 it ill not find it, just opens with 34212
So it only finds the first file not moving to the next row for the different named file
Perhaps you should upload file...
Check your value of lastrow...make sure it is not 3...
Please Login or Register to view this content.
Last edited by Sintek; 09-28-2019 at 01:54 PM.
The name of the file is T54321 and in the Sheets("Estimate").Range("B" & CustRow) is 54321 so without the t
Thanks
full filename will be T54321 - name - intial.pdf if that helps I just want to find the number part in the filename as hat should be unique.
Think of the T54321 as a quote number for a job to a customer if that helps
Post 9 code is not the issue...
You say it is not looping through all...
I have attached a file
code is in the forms estimate in the vba
That helps nothing...No info in sheet...
What is the actual issue now...
The code works but does not attach the file...Your path is incorrect or the file is not at the specified path...
The code only works for the first loop...then your lastrow is incorrect as it starts from 3 to lastrow...
The code can only find the file if the file name is e.g 34212 not if that is just a part of the file name full file name would be T34212 - company name - tech initials.Pdf
The Tno is just part of the overall file name.
If this is the case then your code has to be set up too find the file...file name would be T34212 - company name - tech initials.Pdf
This cell which this code refers to...must have this value..."34212 - company name - tech initials"Please Login or Register to view this content.
I cannot assist because you uploaded a file without info and I do not have the specific files saved to the specific path...
Edit
Upload a file with at least 3 values in the Estimate sheet and give me the names of those 3 files found in the actual path
Last edited by Sintek; 09-29-2019 at 06:33 AM.
I have uploaded the file with 3 Tnos in the estimate 34212, 54321, 67890
In the location "C:\Users\Bertie\Documents" are 3 files called T34212 - Cummins - DS.pdf, T54321 - T54321 - Argos - MD.pdf and T67890 - Argos - WD.pdf
hope that helps thank you for your time.
Well now this makes sense...
How are you expecting to attach a file if your coded file name does not correspond...i.e.
T34212 - Cummins - DS.pdf
If the value in columns B is only the first numerical part...i.e. "34212"
Where do you code the rest of the filename...i.e. "- Cummins - DS" etc
Last edited by Sintek; 09-29-2019 at 07:00 AM.
I was hoping just to do the partial find, rather than the full file name, as to save time in inputing data. The T is added in the subject through the code. I was hoping to do something similar.
It looks like your telling me best way is to have the whole file name.
I thought I might be able to use wildcards or something?
Full file name in path or you'll have to loop through all files and find file like "T41234*.pdf"
Oh ok thank you i think i have an ideaOriginally Posted by sintek
Good luck...
My suggestion...Have the rest of the file name stored in a cell and build string...Why would you want to loop all files in folder
This solves...If you wanna go wildcard option...
Last question...Why are you adding spaces this way..Please Login or Register to view this content.." "
Last edited by Sintek; 09-29-2019 at 07:50 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks