USD$30 - auto generated email with specific fields, outlook 2010

    10% paid via paypal - ID# 42406091H4385625G


    Hello on this Spreadsheet I am trying to get the following – I am using outlook 2010


    · I need an option button added to generate a Status report email coping and pasting to an email the header row 1 column A thru L, and any row (A thru L) that has a container number showing in Column A. It does not need to be in the same format, but easily readable would be ideal.

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    I can look at this. I should be able to complete it by tomorrow.


    Do you mean a command button, rather than an option button?

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    Quote from John_w;786380

    There is text in A3373:A3378, which isn't a container number. Should that text be there?


    No, I may have been messing around and forgot to delete. Thank you.

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    The workbook with code is ready. I will send you a PM with my payment details and post the workbook here once payment is received.

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    Quote from John_w;786391

    The workbook with code is ready. I will send you a PM with my payment details and post the workbook here once payment is received.


    Hello, Just PM'd you the confirmation number.

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    That's great, Thank you very much for the quick work! I will let you know if any changes are needed. Have a nice weekend

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    Hello John, Is it easily doable to have the spreadsheet save a copy to my desktop at a certain time everyday, and overwrite the previous days save? I will open a new request if needed. Please let me know.

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    Yes, this is easily doable. I think you are allowed to add your request to this thread, so if you post the details here (e.g. time when to save, file name to save as, etc.) I will post the code.


    Note there are two possible solutions:


    1. Use VBA Application.OnTime to schedule the workbook save at the required time. This requires the workbook to be opened and remain open (or Excel to be running) before the required time.
    2. Use Windows Scheduler to run a .bat script file which uses a DOS Copy command to copy the workbook file to your desktop.

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    Hello John, Thank you - the file would not be open, the 2nd open would be better for us. I would like it to save at 10pm. And it can be named "Containers at FTN Developer Copy"

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    Create this in Notepad, changing the folder paths and file names as required:


    Code
    copy "C:\folder\path\to\Containers at FTN Developer.xlsm" "C:\Users\username\Desktop\Containers at FTN Developer Copy.xlsm"

    and save in a folder as "Copy Workbook.bat", e.g. "C:\folder\Copy Workbook.bat".


    Then create a basic task in Windows Task Scheduler which runs "C:\folder\Copy Workbook.bat" at 10pm every day.

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    Quote from John_w;786603

    Create this in Notepad, changing the folder paths and file names as required:


    Code
    copy "C:\folder\path\to\Containers at FTN Developer.xlsm" "C:\Users\username\Desktop\Containers at FTN Developer Copy.xlsm"

    and save in a folder as "Copy Workbook.bat", e.g. "C:\folder\Copy Workbook.bat".


    Then create a basic task in Windows Task Scheduler which runs "C:\folder\Copy Workbook.bat" at 10pm every day.


    Hello John, Thanks for the quick reply - I am sorry but I have never used the windows notepad, or the task scheduler, before. Any way you can provide a few more instructions? Here is the location of the current file -
    X:\SEA Shares\warehouse\container dock doors and is named INBOUND CONTAINER REPORT NEW FORM. and my user desktop name is 400243

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    To open Notepad:
    Press Windows key+R. In the Run Open box type Notepad and press enter.


    To open Task Scheduler:
    Press Windows key+R. In the Run Open box type Taskschd.msc and press enter.


    (Please Google "Windows key" if you don't know what that is :))


    Change the copy command to:


    Code
    Copy "X:\SEA Shares\warehouse\container dock doors\INBOUND CONTAINER REPORT NEW FORM.xlsm" "C:\Users\400243\Desktop\Containers at FTN Developer Copy.xlsm"

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    Hello, OK I got the Notepad, and the task scheduler set up, if I go in and try to run it manually, it just opens the file but does not copy to the desktop? I'm sure I am missing something easy??

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    I don't know why it is opening the file - everything I have posted is about copying the workbook file. By 'the file' do you mean the "INBOUND CONTAINER REPORT NEW FORM.xlsm" workbook?


    Check all folder paths and file names on the copy command are exactly correct. For example, I assumed your Desktop folder is in "C:\Users" - is that correct? If not, change it to the correct path.


    Try running the .bat file directly by double-clicking "Copy workbook.bat". If the folder paths and file names are correct then it should work and copy the workbook to your Desktop.

    Re: USD$30 - auto generated email with specific fields, outlook 2010


    Just got it, I had the Path wrong, just a typo on my part :) Thank you very much for the Help, and the explaining of how to get to the task scheduler.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login