Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
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
There is text in A3373:A3378, which isn't a container number. Should that text be there?
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
Thank you for the quick payment.
Here is the workbook with macro, run by clicking the command button on the sheet.
forum.ozgrid.com/index.php?attachment/71500/
Let me know if you want any changes.
Re: USD$30 - auto generated email with specific fields, outlook 2010
Excellent! I'm glad you like it.
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
Create this in Notepad, changing the folder paths and file names as required:
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
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:
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
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.
Don’t have an account yet? Register yourself now and be a part of our community!