Outlook 2007 Contact in a Task

Status
Not open for further replies.

LMS

Senior Member
Outlook version
Email Account
Exchange Server
Here is the code of a UserForm that when I select one or more contacts, I run this Userform, it open up the drop list of dates and I select what date to add to the user defined field named "Status Date" of the contacts and it changes a specific field named "Status Date"in the contact.I can also add more fields with there names as an additional case to use....so is there a way to add to this or adjust it, so i recognizes the fields of the contacts that come from the objTask.Links(1) of each task i select, and then makes the changes to those contacts? Thanks very very much:

Private Sub btnRun_Click()
Dim Field As String
Dim value As String
Field = Me.ddlFields.Text
value = Me.ddlValues.Text


UpdateContactField Field, value

Me.Hide


End Sub

Private Sub ddlFields_Change()


Dim fld As String
fld = Me.ddlFields.Text
'Add your field related values here.

Select Case fld



Case "Status Date"



Me.ddlValues.addItem "Jan-01-2014"
Me.ddlValues.addItem "Jan-02-2014"
Me.ddlValues.addItem "Jan-03-2014"
Me.ddlValues.addItem "Jan-04-2014"
Me.ddlValues.addItem "Jan-05-2014"
Me.ddlValues.addItem "Jan-06-2014"
Me.ddlValues.addItem "Jan-07-2014"
Me.ddlValues.addItem "Jan-08-2014"
Me.ddlValues.addItem "Jan-09-2014"
Me.ddlValues.addItem "Jan-10-2014"
Me.ddlValues.addItem "Jan-11-2014"
Me.ddlValues.addItem "Jan-12-2014"
Me.ddlValues.addItem "Jan-13-2014"
Me.ddlValues.addItem "Jan-14-2014"
Me.ddlValues.addItem "Jan-15-2014"
Me.ddlValues.addItem "Jan-16-2014"
Me.ddlValues.addItem "Jan-17-2014"
Me.ddlValues.addItem "Jan-18-2014"
Me.ddlValues.addItem "Jan-19-2014"
Me.ddlValues.addItem "Jan-20-2014"
Me.ddlValues.addItem "Jan-21-2014"
Me.ddlValues.addItem "Jan-22-2014"
Me.ddlValues.addItem "Jan-23-2014"
Me.ddlValues.addItem "Jan-24-2014"
Me.ddlValues.addItem "Jan-25-2014"
Me.ddlValues.addItem "Jan-26-2014"
Me.ddlValues.addItem "Jan-27-2014"
Me.ddlValues.addItem "Jan-28-2014"
Me.ddlValues.addItem "Jan-29-2014"
Me.ddlValues.addItem "Jan-30-2014"




Private Sub UserForm_Initialize()
'Add your field names here.

Me.ddlFields.addItem "Status Date"

End Sub
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
The date picker is the little calendars that come up when you click in some date fields. I'd use that method instead of hard coding dates, but I'm not sure if a date picker control is available in Outlook 2007. I'm not in my office tonight so I don't have access to outlook 2007 to check for the control.
 

LMS

Senior Member
Outlook version
Email Account
Exchange Server
This is not just oriented to dates. Just to the fields in the contact that is the contact of the task. Anything to put in the code so i select the task just like selecting a contact.
 

LMS

Senior Member
Outlook version
Email Account
Exchange Server
Please explain what I need to do with that macro and how I use my macro with it. Thank you very much.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Test it and see what it does and if that is what you want to do, then you can merge it with your macro.
 

LMS

Senior Member
Outlook version
Email Account
Exchange Server
I already copied it to a module, selected a task, ran the macro and nothing happened showing me anything
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I won't be able to test it until tomorrow afternoon at the earliest - it won't work on my version because the links collection was removed from 2013.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Between doing 1099's and have some dental work done today, probably not. :)
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Outlook 2007 Macro to Contact From a Field Using Outlook 3
C in outlook 2007-Contact Group-One name have 3 mail id-its possible? Using Outlook 3
L Outlook 2007 Contact Form Code Not Working Using Outlook 20
Z Outlook 2007, clicking email addresses fails to open Contact Using Outlook 0
L Outlook 2007 Macro Save Contact Using Outlook 10
L Outlook 2007 Open Folder From a Contact Using Outlook 22
L Outlook 2007 Contact Form Webpage Using Outlook 23
L Outlook 2007 Macro Open Contact Folder Using Outlook 7
Z outlook 2007 - opening a contact from the search results doesn't use the custom form Using Outlook 10
L Outlook 2007 Macro to Run a Script From a Contact Form Using Outlook 41
L Outlook 2007 Macro to Add Text to a Contact Field Using Outlook 10
L Outlook 2007 Contact Form - Note Fields Using Outlook 25
M suddenly cannot set outlook 2007 contact reminders Using Outlook 2
R Ingest contact PST from exchange 2007 thru client's Outlook via PRF Exchange Server Administration 2
L Opening up Contact from an Email - Outlook 2007 Using Outlook 15
L Outlook 2007 Contact Review Using Outlook 4
C Outlook 2007 Contact Card opens in margin of screen where I can't see it Using Outlook 3
E Double clicking on from email address does no longer open corresponding contact in Outlook 2007 Using Outlook 7
S Upgrade Outlook 2007 to outlook with Buisiness Contact m|Manger BCM (Business Contact Manager) 2
R Outlook 2007 w/ Business Contact Manager compatible w/ Cardscan? BCM (Business Contact Manager) 1
M Business contact manager 2003 on outlook 2007 BCM (Business Contact Manager) 1
J how to add Business Contact Manager to existing Outlook 2007? BCM (Business Contact Manager) 2
M How do I install Outlook 2007 Business Contact Manager on Win7x64 BCM (Business Contact Manager) 1
M 2007 Outlook - no Business Contact Manager BCM (Business Contact Manager) 7
P Setup failed to install Business Contact Manager for Outlook 2007 BCM (Business Contact Manager) 2
C Business Contact Manager and Outlook 2007 "not enough free memory BCM (Business Contact Manager) 5
L outlook 2007 attach multiple journals to same contact Outlook VBA and Custom Forms 2
K Accessing contact's custom properties in a Outlook 2007 form region Outlook VBA and Custom Forms 1
C Outlook 2007 Removing then adding account restores junk email processing Using Outlook 0
S Outlook 2007 crash linked to gdiplus.dll Using Outlook 0
S Outlook 2007 - Automatic purge fail Using Outlook 0
J outlook 2007 doesn't let me choose which .pst to search Using Outlook 2
D Outlook 2007 vs. Outlook 2010 -- ToDo Bar Using Outlook 0
D Outlook 2007 on 365 Using Outlook.com accounts in Outlook 2
S Macro for other actions - Outlook 2007 Outlook VBA and Custom Forms 23
S Verwendung von Outlook 2007 Using Outlook 0
A Arthur needs help with 2007 Outlook e-mail Using Outlook.com accounts in Outlook 3
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
S outlook 2007 calendar search Using Outlook 6
B Migrate Outlook 2007 to Office 365 Using Outlook 3
X I have met my waterloo trying to resolve embedded graphics problem with outlook 2007 and now 2016 Using Outlook 1
R Outlook 2007 only loads some appointments Using Outlook 0
C Move Outlook 2007 to new PC with Outlook 365 Using Outlook 3
J Outlook 2007 Hide Messages Option not Available Using Outlook 2
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 0
B Server errors Outlook 2007 Using Outlook 1
S Reboot of frozen windows7 results in changed outlook 2007 settings Using Outlook 1
S Outlook 2007 printing wrong email address at top of page Using Outlook 8
M Configure outlook 2007 to accept digital signatures Using Outlook 2

Similar threads

Top