Log In
Register
Home
December 5, 2016
Offline
Sorry I should have attached modified macro file for further modification...
February 20, 2020
Offline
Hello everyone,
in relation to your post 38, I think it is better to create a new topic for this purpose, just so as not to mix all the subjects in one topic ... it would be easier for others to help, because the title of the topic would be related to the subject, and for memory future, easier to find by searching in the forum...
about missing references, it's not easy, but you could tell which ones are missing!
_ To start with, you could access the Excel VBA editor
_ In VBA editor window, click the "Tools" button in the menu bar
_ Then, from the drop down list, see which of the references that were selected, has "missing", the word "missing", is at the beginning of the reference name
_ Finally, click "Cancel" button to exit
Miguel,
February 20, 2020
Offline
Hello,
I didn't understand what you meant in your posts 39,40,41
the path of the file to be attached must be complete (directory, name and extension), in your file, which I downloaded, the extensions for each file are missing
in my post 9, I already gave you a macro to get information about all the files in a folder, where in column ("B") the macro inserts the full path of the file
Miguel,
December 5, 2016
Offline
So Sorry causing too much confusion so far all my poblems in these posts has been clear and settled; except the last item we want to show in the File name of the attachment to be stated in the Email Subject, like belwo
for example : Subject : AR Monthly report - 12349
File path :C\Data\12349.xlsx
File Name :12349.xlsx
for example : Subject : AR Monthly report - 456789
File path :C\Data\456789.xlsx
File Name :456789.xlsx
for example : Subject : AR Monthly report - 789654
File path :C\Data\789654.xlsx
File Name :789654.xlsx
In short in each mail item we want to show the attachment file name in the Subject, i hope I make clear myself for this request..
February 20, 2020
Offline
hello,
Attached file with requested changes
Changes: (in Module1)
_ function has been added to retain the name and extension of all files that will be attached to the email
_ changes made in the email macro (procedures for checking the files to be attached and subject to being inserted in the email)
_ the procedure for retaining the name and extension of the files, is prepared to retain the name of all the files that will be attached, but I just put a blank space between the names (highlighted in red in the line below), if you want a symbol to divide the names, just add where the blank space is in the middle of the quotes
attachName = attachName & " " & VBA.Right(checkD, VBA.Len(checkD) - getLastOcurrence(checkD, "\") + 1)
Miguel,
December 5, 2016
Offline
Really thanks again Miguel, will try on the new Macro with actual data.
December 5, 2016
Offline
Dear Miguel,
I try the macro with live data, but File name still can not be attached in subject. Pls help further
So far no error code prompt, related attachment file can be loaded only File name do not appear in subject of the Email...
1 Guest(s)
