| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to edit outlook contacts from cell entry
does anyone know the code for copying cell entries to outlook contacts list i.e set ws = sheets("Personal Details") contact name = range("E1") Mobile phone number = range("C10") and email address = range("C11") upon deactivation of worksheet send all these details to ms outlook coincidable ranges thanks in advance -- short_n_curly ------------------------------------------------------------------------ short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576 View this thread: http://www.excelforum.com/showthread...hreadid=384090 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba to edit outlook contacts from cell entry
anybody? i know that it is possible to code cell entries to programme emails to be automatically sent from outlook but what is the code to open outlook, open contacts, open new contacts and take the entry in cell a1 to contact name, cell c2 to mobile phone number and cell c3 to email address, save data close outlook and return back to workbook please please help thanks -- short_n_curly ------------------------------------------------------------------------ short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576 View this thread: http://www.excelforum.com/showthread...hreadid=384090 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba to edit outlook contacts from cell entry
http://tinyurl.com/do9xu
might be a start. -- Regards, Tom Ogilvy "short_n_curly" wrote in message news:short_n_curly.1rlbub_1120388702.9577@excelfor um-nospam.com... anybody? i know that it is possible to code cell entries to programme emails to be automatically sent from outlook but what is the code to open outlook, open contacts, open new contacts and take the entry in cell a1 to contact name, cell c2 to mobile phone number and cell c3 to email address, save data close outlook and return back to workbook please please help thanks -- short_n_curly ------------------------------------------------------------------------ short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576 View this thread: http://www.excelforum.com/showthread...hreadid=384090 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba to edit outlook contacts from cell entry
surely someone knows the code for this the cells are exactly as listed, i foolowed the link but could not put the specific cells above into the code (i only dabble with vba and my knowledge is limited) it would be really helpful is someone could list the code to do this from above thanks all who read -- short_n_curly ------------------------------------------------------------------------ short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576 View this thread: http://www.excelforum.com/showthread...hreadid=384090 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Contacts from Excel to Outlook | Excel Discussion (Misc queries) | |||
| How do I export contacts from Excel back to Outlook Contacts? | Excel Discussion (Misc queries) | |||
| Import contacts from outlook | Excel Discussion (Misc queries) | |||
| outlook contacts | Excel Discussion (Misc queries) | |||
| I could really need your help on importing contacts into Outlook (Please?) | Excel Programming | |||
![short_n_curly[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
