Outlook 2007 Contact in a Task

Status
Not open for further replies.

LMS

Senior Member
Outlook version
Outlook 2007
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
Outlook 2007
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
Outlook 2007
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
Outlook 2007
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.
Thread starter Similar threads 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
1 I want to get rid of Outlook 2007. When I am in Craigslist & click the email link to contact the per Using Outlook 8
H Outlook 2007 contact group Using Outlook 2
C Sharing of a database in business contact manager in outlook 2007 Using Outlook 1
S Can not setup address book from my contact folder in Outlook 2007 Using Outlook 5
M I am running outlook 2007 on a hosted exchange server. When I try to send an email and click the To: box there are two contact options - how do I get Using Outlook 1
M Outlook 2007 - Contact detail won't open Using Outlook 2
R modifying outlook 2007 default contact template Using Outlook 1
R How do I send a letter (not an email) to a Contact in Outlook 2007? Using Outlook 2
B Outlook 2007 Business Contact Mgr and Word 2010 Using Outlook 1
B Restoring Business Contact Manager Database for Outlook 2007 Using Outlook 2
N Outlook 2007: Contacts Search - Contact shows up when typed, can't find manually. Using Outlook 2
A Cannot import Xp based outlook .pst file into Outlook 2007 with Bus Contact Manager. Using Outlook 1
T Installation help for Outlook 2007 with Business Contact Manager Using Outlook 2
T How do i synchronize my outlook 2007 contacts with the contact list in live? Using Outlook 5
D Outlook 2007 Business contact manager freezes up in office word Using Outlook 2
I Contact categories problem when upgrading from 2007 to 2010 Outlook Using Outlook 1
G Outlook 2007 - Contact phone number fields - changing names Using Outlook 2
O Outlook 2007 mail Address book showing too many contact fields per name.... Using Outlook 5
D Moving from Business Contact Manager for Outlook 2007 to BCM 2010 Using Outlook 1
S The form you are trying to access is unavailable contact your System Administrator message In Outlook 2007 Using Outlook 4
R adding contact BOOM: outlook 2007; connector; win 7 32 bit Using Outlook 7
H Outlook 2007 Business Contact Manager Using Outlook 5
A Outlook 2007, Using the shared contact folder feature, can't share a distribution list which exists Using Outlook 2
S Importing Contact from Outlook 2007 to oultlook 2010 Using Outlook 2
Q Copying Outlook 2003/XP contact list to Outlook 2007/Windows 7 Using Outlook 25
E Double clicking on from email address does no longer open corresponding contact in Outlook 2007 Using Outlook 7
E how do i export my contact list from yahoo to outlook 2007 Using Outlook 2
T I just configured Outlook 2007 with Business Contact Manager on my computer. Now all my emails from my Bellsouth have gone over to Outlook. Can I ge Using Outlook 1
R Is it possible to add a field to the default Contact form in Outlook 2007? Using Outlook 1
A Outlook 2007 email address book only shows contacts in main contact directory. Using Outlook 3
D Updating Outlook 2007 Contact list from another drive. Using Outlook 3
N Outlook 2007 -- Not responding when switching to Tasks, To Do lists // Business Contact Manager? Using Outlook 4
S Upgrade Outlook 2007 to outlook with Buisiness Contact m|Manger BCM (Business Contact Manager) 2
Similar threads


















































Top