Change To address when it is sent to a specific address during specfic time.

Status
Not open for further replies.

densetax2

Member
Outlook version
Email Account
Exchange Server
Hi, As a new bee. I was wondering how to do in outlook vba:

1.An excel sheet template is available with "FromDate", "ToDate", "Time", "Name" column.

2.When email is sent to a specific Team , it should look the time.
-and if time lies in mentioned range or Time in excel sheet,
-it changes the "To address" to the address of the respective "Name" from the

excel sheet for the current Date.(it should find the email address for that name, as it will

be only name in excel.) .
-and put the previous mentioned Team address to CC
-and another address in CC aswell.

Thanks in advance
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Re: Change To address when it is sent to a specific address during specfic tim

This might be easier to do with an Excel macro - Start the macro in Excel, it checks the date, addresses the email, pops it up for you to complete and send. When it do it in Outlook on Send, it slows down the process because it needs to wait for Excel to open. CSV or TXT file with the information might be faster - build an array and check dates then use Case statements.

How many records are in the sheet?

How many choices for To addresses? Do these change often?

Oh, and to clarify, are you checking mail that you send or mail that you receive and need to forward on to someone else?
 

densetax2

Member
Outlook version
Email Account
Exchange Server
Re: Change To address when it is sent to a specific address during specfic tim

Thanks for the info.

Yes it should check mail when I send .

below is the screen shot of the excel sample.

The format can be changed. but then how it will fetch the data according.

I think you asked about records is rows. the excel will have one sheet and the rows may go for the dates till the end of the year.

The names are fixed as per the sheet.

when sending email it has to check "to address" and if its for a specific address (which is fixed). then it will have to change the "to address" and put the adress of the person from the sheet for the current date.

And put the orginal "to adress" as CC.

sample.JPG
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
whizzard Change FROM address based on TO or CC address Outlook VBA and Custom Forms 8
O What would be the recommended way to change an email address (family member)? Using Outlook 0
B Change from Address Outlook VBA and Custom Forms 0
S Example VBA Macro - To Conditionally Change the From Account and Add a BCC Address on Emails Outlook VBA and Custom Forms 11
B Do not change the From address in Outlook Templates Using Outlook 0
C Change From address while sending a new mail Outlook VBA and Custom Forms 5
B Change default email for address book Using Outlook 1
Maybear Sudden change in Outlook, no image display, email no longer offers suggestions for address Using Outlook 8
P Change the Outlook.com "from" address for calendar event invites Using Outlook 9
K Automatically Change "From" Address When Replying As An Alias? Using Outlook 5
R Change Outlook 2010 Exchange server address via registry or script Using Outlook 5
C Outlook Automatically Change "From" address based on "To" address Using Outlook 4
P Outlook 2016 Change Paste Special Default Format Using Outlook 8
S Outlook 365 Can I change the possible range of highlighting colours when writing an Outlook email? Using Outlook 1
V Can one change the formatting of email title blocks? Using Outlook 0
S Unable to change Message Class Outlook VBA and Custom Forms 0
S New Outlook Appointment - Select All Body Text and Change Font and Size Outlook VBA and Custom Forms 1
J VBA Cannot programmatically input or change Value for User Defined field Using Outlook 1
C Outlook 365 Can you change the follow up colour? Using Outlook 1
A Change settings Send/receive VBA Outlook VBA and Custom Forms 0
E Outlook VBA change GetDefaultFolder dynamically Outlook VBA and Custom Forms 6
S Change "This Week" flag start date behavior Using Outlook 1
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
D Change Microsoft Account password - what to do to update on all devices Using Outlook 4
S Outlook 2016 Change how Outlook shows me contacts in emails Using Outlook 0
witzker HowTo Change message Class of contact form Outlook VBA and Custom Forms 0
Z Outlook 365 delete reminder you can’t make change to contents of this-read only folder Using Outlook 4
witzker Pls help to change the code for inserting date in Ol contact body Outlook VBA and Custom Forms 5
R How to Change Margins In Google Docs...? Using Outlook 0
e_a_g_l_e_p_i Outlook 2010 How can I change the font size on right side appointment pane Using Outlook 12
diver864 vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply Outlook VBA and Custom Forms 1
B Change Font and Font size using VBA Outlook VBA and Custom Forms 9
D Change senders title Using Outlook 1
W Recurrence: delete older occurrences / change earliest start time Outlook VBA and Custom Forms 0
E Change sending account depending on Subjectline Outlook VBA and Custom Forms 0
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 10
B Change row background color of selected item Using Outlook 1
PGSystemTester VBA To Change AppointmentItem.BusyStatus From MeetingItem Before Send Using Outlook 0
X If you change expiration date of repeated task it dupplicates Using Outlook 1
E How to display "Change Folder" in Change Default Email Delivery Location in Exchange Outlook 2016 Using Outlook 1
Z See "Change View" Drop Down as a List? Using Outlook 1
V Change start time based on message duration Outlook VBA and Custom Forms 2
R Folder pane width change Using Outlook 89
S Change VBA script to send HTML email instead of text Outlook VBA and Custom Forms 3
S Outlook 2010 unable to change default font Using Outlook 7
P How can I change my calendar view back Using Outlook 3
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
T Change the selected Message in the Outlook window Outlook VBA and Custom Forms 2
geofferyh How to change the Attachment File Name? Outlook VBA and Custom Forms 1
W Appointment occurrences change the location property Using Outlook 0

Similar threads

Top