User Profile
TTC-BlueHill1
Copper Contributor
Joined 8 months ago
User Widgets
Recent Discussions
How to Send a High Importance email through PowerShell Script
I am login through exchange server 'Web Outlook App' to send email out. The send email is working fine, but I want to know how to send a 'Priority' email. I've tried everything and the email send is not sending as 'Priority'. Please let me know the syntax for Power Shell script. These are the one that try so far and none of them are working. # Send High Performance Email #[System.Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 #$emailPriority = [System.Net.Mail.MailPriority]::High #$emailPriority = "2" #$email.Priority = [System.Net.Mail.MailPriority]::High #$emailHighPriority ="High" #$emailMessage.Priority = [System.Net.Mail.MailPriority]::High #$mailMessage.Priority = [System.Net.Mail.MailPriority]::High #`$emailMessage.Priority = [System.Net.Mail.MailPriority]::High` #$emailMessage = New-Object System.Net.Mail.MailMessage #$emailMessage.Priority = 2 #$email = New-Object System.Net.Mail.MailMessage #$email.Priority = [System.Net.Mail.MailPriority]::HighPowerShell - How to Download Email Attachments from Exchange Server
I have a big task and I don't know if this can be done through VBA. Let me explain what I need to be done. 1. I have several clients that I setup an email address through Exchange server (not my personal outlook inbox) with a user name and password. 2. Then I have several customers that sending email attachment for that particular client. Let say one of the client’s name Troy Corporation and the email will be email address removed for privacy reasons. The customer’s name is: Daybreak Fast, FedEx Freight, R&L Carriers, and TRN Logistics. All the customers are sending email attachment into Troy Corporation mailbox. Side Note: (sometimes I have different customer send the attached file. Let say this I have this week Mr. email address removed for privacy reasons and next week I have Mrs. email address removed for privacy reasons I need the program to check for both emails to see if one of them send me a file. What I need is to do is login to mailbox (Troy Corporation) retrieve each email with the attached file for each customer, then download them to my network folder. If I did not receive an attachment for any of the customer to send them a second request with a note on the body "we did not receive your file" something like that. 3. So, when I login for second time to retrieve the remaining attached file. But if I did receive the email attachment either on the first or the second attempt, the customer SHOULD NOT RECEIVE a second request because I did receive their file. I do have more after all the files are download to my network folder. But I want to know if this can be done through Power Shell.VBA - Retrieve emails Attachment & Download
Hi Everyone, I have a big task and I don't know if this can be done through VBA. Let me explain what I need to be done. 1. I have several clients that I setup an email address through Exchange server (not my personal outlook). with a password. 2. Then I have several customers that sending email attachment for that particular client. Let say one of the client’s name Troy Corporation and the email will be email address removed for privacy reasons. The customer’s name is: Daybreak Fast, FedEx Freight, R&L Carriers, and TRN Logistics. All the customers are sending email attachment into Troy Corporation mailbox. Side Note: (sometimes I have different customer send the attached file. Let say this I have this week Mr. email address removed for privacy reasons and next week I have Mrs. email address removed for privacy reasons I need the program to check for both emails to see if one of them send me a file. What I need is to do is login to mailbox (Troy Corporation) retrieve each email with the attached file for each customer, then download them to my network folder. If I did not receive an attachment for any of the customer to send them a second request with a note on the body "we did not receive your file" something like that. 3. So, when I login for second time to retrieve the remaining attached file. But if I did receive the email attachment either on the first or the second attempt, the customer SHOULD NOT RECEIVE a second request because I did receive their file. I do have more after all the files are download to my network folder. But I want to know if this can be done through VBA. OR if cannot be done through VBA, which program do you think is the best to be done with? Thank you an advanced!VBA copy data from another workbook into current workbook (specific tab)
Hello, I have my target workbook called "Troy Corporation Carrier Review March 2024.xlsx" and there's tab name call 'Detail". My target workbook is locate in the network folder which I am an admin and I have all rights and privilege I also have all my excel files are in the same folder, but in a different sub-folder. I need copy from the excel files mentioned above from column A to AA and from row 2 down and paste it to my target file "Troy Corporation Carrier Review March 2024.xlsx" to my "Detail" tab. So I want to paste the data start from column 'E' to column 'AE' and start in row 3. Then when the next file start I want to continue paste it to the last row of the first file. For example, if the first past ended with row 50, then next file will start on row 51 and so on... Thank you an advance!
