Consulting

Results 1 to 6 of 6

Thread: Outlook automatically send files every week days (manual trigger)

  1. #1

    Outlook automatically send files every week days (manual trigger)

    Hello,

    Every day we need to send multiple files to clients.

    Every file as it's own name... File beginning by abc100 goes to clients a, abc101 to client b, abc102 and abc103 to client c, today no abx104 available so we send nothing to client d, etc.

    We store those files in a specific folder. On Friday, they were stored in June 2024 -> June 21.

    How can I do something like that ? Something that is also available to my co-workers?

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,180
    Location
    What is the name of the original file?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    Quote Originally Posted by Aussiebear View Post
    What is the name of the original file?
    All the files use the same format. We receive them by email under a random number, but that name has no use to us and we save them as ClientDateCarrierShipmentnumber

    We need to send ClientDateCarrierShipmentnumber to different e-mail at the end of the day, depending on the client. Thinking about it, the sending of the emails should be manually triggered instead of automatically.

  4. #4
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,180
    Location
    Your file has a name from which we can then increment the number and associate with a new client.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  5. #5
    My original post is only an example.

    ClientDateCarrierShipmentnumber.pdf will be the file name. So whether the client has 0, 5, 10 or 50 files under its name, I have to send them all to that specific client. Lets say client 1 is abc100

    So if I were to send them tomorrow, I would go into the June 2024 folder then June 24, I would have to send all files starting with abc100*.pdf to that client.
    If the other client is qwerty, then I send all files starting with qwerty*.pdf to that other client.

    So pretty much, I just want to take the client's name at the beginning of the file(s) and send it to that specific client.

    Do it for like 20 different clients and it can take some time. I am looking to automate the process at a click of a button or something.

  6. #6
    Moderator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,244
    Location
    Hi MasterBash,

    It has been brought to our attention that you have cross posted this thread:
    https://www.mrexcel.com/board/thread...-days.1260707/

    You are allowed to cross post but please provide links to your cross posts, it is only fair on the people that give their free time to help you.
    It can be very frustrating, spending hours working on something that has been solved elsewhere.

    You can read the below for more information about cross posting:
    https://excelguru.ca/a-message-to-forum-cross-posters/
    Click here for a guide on how to add code tags
    Click here for a guide on how to mark a thread as solved
    Click here for a guide on how to upload a file with your post

    Excel 365, Version 2405, Build 17628.20102

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •