hi all.
I was initially trying to create a macro in outlook.. but outlook for mac doesn't support macros, so here we are back in excel, trying to integrate with Outlook..
I get about 25 'sales lead' emails daily, and i'm wanting the details to automatically create contacts in my outlook.
I can do the manual part of the task - copy and paste to an excel sheet, and it copies;
Name: abc xyz
Email: abc@domain.com
Phone: 0400 000 000 / /
i know the very basics of VBA, and have googled, however i'm having connectivity troubles with outlook
it seems to be erroring;
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000 ; background-color: #ffffff}span.s1 {color: #011993}</style>
Dim objOutlook As New Outlook.Application
Thanks
I was initially trying to create a macro in outlook.. but outlook for mac doesn't support macros, so here we are back in excel, trying to integrate with Outlook..
I get about 25 'sales lead' emails daily, and i'm wanting the details to automatically create contacts in my outlook.
I can do the manual part of the task - copy and paste to an excel sheet, and it copies;
Name: abc xyz
Email: abc@domain.com
Phone: 0400 000 000 / /
i know the very basics of VBA, and have googled, however i'm having connectivity troubles with outlook
it seems to be erroring;
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000 ; background-color: #ffffff}span.s1 {color: #011993}</style>
Dim objOutlook As New Outlook.Application
Thanks
