Contact List / Email from Outlook

Yahoo Archive
1
Thank you so much Virginia - this worked perfectly!! :)


--- In vantage@yahoogroups.com, "Virginia Joseph" <vjoseph@...> wrote:
>
> I will preface this with the statement that I am not a programmer so I don't know if this will help you but one of our previous programmers added a button to the contacts sheet and when you click the button it launches a new message in outlook at puts the customer contact's email address in the To: box. Here is the code from the script editor. I do not know whether or not he had to set-up anything else besides the customization for this to work. We are on 8.03.408 so even if this does not work for you, you are not out of luck. It can be done in 8.03.xxx.
>
> Private Sub btnEpiCustom1_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnEpiCustom1.Click
> Dim edv As EpiDataView = CType(oTrans.EpiDataViews("Contact"), EpiDataView)
> Dim edvEmail As String = edv.dataview(edv.row)("EmailAddress")
> If Process.GetProcessesByName("OutLook").Length < 1 Then
> Process.Start("Outlook.exe", "mailto:" & CType(edvEmail,String))
> Else : Process.Start("mailto:" & CType(edvEmail,String))
> End If
> End Sub
>
> HTH,
> Virginia Joseph
> Deep Hole Specialists, LLC
> vjoseph@...
>
> --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> >
> > Only if you don't want to implement the linklabel idea that Jose gave us back on May 21st
> >
>
2
I know I've asked this before and have been working through the various posts / help that I've had but am still unable to get this to work, so here's my last post on the subhject (I promise!). We want to be able to click on an email address and a new message open in Outlook - I have tried:

Hyperlink / Email link but have code problems

Installing Interop - again a code problem as am not sure where to put the link for the email address, but although I get a message about obtaining access to Outlook a new message doesn't open


Does anyone have any other suggestions? Alternatively, our main concern is having a quick access contact list (that uses Outlook)... am I missing other options? Would using an asp 'dashboard' display the email address as a hyperlink? Is there a way to link the Contact file to a Public Address Book in Outlook? I know this is quite a minor thing but having a Commercial team that already have a bad impression of Vantage it would be nice to get something that they consider a big deal working! Thanks all.
3
Version of Vantage/Epicor?

I have made it work with the C# editor in E9 and up but have had no luck with the VB editor on V8

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tracy.tmat
Sent: Tuesday, June 26, 2012 10:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Contact List / Email from Outlook

I know I've asked this before and have been working through the various posts / help that I've had but am still unable to get this to work, so here's my last post on the subhject (I promise!). We want to be able to click on an email address and a new message open in Outlook - I have tried:

Hyperlink / Email link but have code problems

Installing Interop - again a code problem as am not sure where to put the link for the email address, but although I get a message about obtaining access to Outlook a new message doesn't open


Does anyone have any other suggestions? Alternatively, our main concern is having a quick access contact list (that uses Outlook)... am I missing other options? Would using an asp 'dashboard' display the email address as a hyperlink? Is there a way to link the Contact file to a Public Address Book in Outlook? I know this is quite a minor thing but having a Commercial team that already have a bad impression of Vantage it would be nice to get something that they consider a big deal working! Thanks all.



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
4
Sorry - we're on Vantage 8.03.409a. Guess we're out of luck?

--- In vantage@yahoogroups.com, Bernie Walker <bwalker@...> wrote:
>
> Version of Vantage/Epicor?
>
> I have made it work with the C# editor in E9 and up but have had no luck with the VB editor on V8
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tracy.tmat
> Sent: Tuesday, June 26, 2012 10:00 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Contact List / Email from Outlook
>
> I know I've asked this before and have been working through the various posts / help that I've had but am still unable to get this to work, so here's my last post on the subhject (I promise!). We want to be able to click on an email address and a new message open in Outlook - I have tried:
>
> Hyperlink / Email link but have code problems
>
> Installing Interop - again a code problem as am not sure where to put the link for the email address, but although I get a message about obtaining access to Outlook a new message doesn't open
>
>
> Does anyone have any other suggestions? Alternatively, our main concern is having a quick access contact list (that uses Outlook)... am I missing other options? Would using an asp 'dashboard' display the email address as a hyperlink? Is there a way to link the Contact file to a Public Address Book in Outlook? I know this is quite a minor thing but having a Commercial team that already have a bad impression of Vantage it would be nice to get something that they consider a big deal working! Thanks all.
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
5
Only if you don't want to implement the linklabel idea that Jose gave us back on May 21st

--- In vantage@yahoogroups.com, "tracy.tmat" <tracy.smith@...> wrote:
>
> Sorry - we're on Vantage 8.03.409a. Guess we're out of luck?
>
> --- In vantage@yahoogroups.com, Bernie Walker <bwalker@> wrote:
> >
> > Version of Vantage/Epicor?
> >
> > I have made it work with the C# editor in E9 and up but have had no luck with the VB editor on V8
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tracy.tmat
> > Sent: Tuesday, June 26, 2012 10:00 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Contact List / Email from Outlook
> >
> > I know I've asked this before and have been working through the various posts / help that I've had but am still unable to get this to work, so here's my last post on the subhject (I promise!). We want to be able to click on an email address and a new message open in Outlook - I have tried:
> >
> > Hyperlink / Email link but have code problems
> >
> > Installing Interop - again a code problem as am not sure where to put the link for the email address, but although I get a message about obtaining access to Outlook a new message doesn't open
> >
> >
> > Does anyone have any other suggestions? Alternatively, our main concern is having a quick access contact list (that uses Outlook)... am I missing other options? Would using an asp 'dashboard' display the email address as a hyperlink? Is there a way to link the Contact file to a Public Address Book in Outlook? I know this is quite a minor thing but having a Commercial team that already have a bad impression of Vantage it would be nice to get something that they consider a big deal working! Thanks all.
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
>
6
I will preface this with the statement that I am not a programmer so I don't know if this will help you but one of our previous programmers added a button to the contacts sheet and when you click the button it launches a new message in outlook at puts the customer contact's email address in the To: box. Here is the code from the script editor. I do not know whether or not he had to set-up anything else besides the customization for this to work. We are on 8.03.408 so even if this does not work for you, you are not out of luck. It can be done in 8.03.xxx.

Private Sub btnEpiCustom1_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnEpiCustom1.Click
Dim edv As EpiDataView = CType(oTrans.EpiDataViews("Contact"), EpiDataView)
Dim edvEmail As String = edv.dataview(edv.row)("EmailAddress")
If Process.GetProcessesByName("OutLook").Length < 1 Then
Process.Start("Outlook.exe", "mailto:" & CType(edvEmail,String))
Else : Process.Start("mailto:" & CType(edvEmail,String))
End If
End Sub

HTH,
Virginia Joseph
Deep Hole Specialists, LLC
vjoseph@...

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> Only if you don't want to implement the linklabel idea that Jose gave us back on May 21st
>
7
Thanks Virginia, I'll give it a go.

I have tried following the post from Jose but when I use code converter to VB I get compile error messages and am just not that good at programming to figure them out.

Did try asking Epicor as well but they said they would charge 4 hours just to look into the feasibility of it and not for actually making it work - does this sound correct?

Thanks for replys.


--- In vantage@yahoogroups.com, "Virginia Joseph" <vjoseph@...> wrote:
>
> I will preface this with the statement that I am not a programmer so I don't know if this will help you but one of our previous programmers added a button to the contacts sheet and when you click the button it launches a new message in outlook at puts the customer contact's email address in the To: box. Here is the code from the script editor. I do not know whether or not he had to set-up anything else besides the customization for this to work. We are on 8.03.408 so even if this does not work for you, you are not out of luck. It can be done in 8.03.xxx.
>
> Private Sub btnEpiCustom1_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnEpiCustom1.Click
> Dim edv As EpiDataView = CType(oTrans.EpiDataViews("Contact"), EpiDataView)
> Dim edvEmail As String = edv.dataview(edv.row)("EmailAddress")
> If Process.GetProcessesByName("OutLook").Length < 1 Then
> Process.Start("Outlook.exe", "mailto:" & CType(edvEmail,String))
> Else : Process.Start("mailto:" & CType(edvEmail,String))
> End If
> End Sub
>
> HTH,
> Virginia Joseph
> Deep Hole Specialists, LLC
> vjoseph@...
>
> --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> >
> > Only if you don't want to implement the linklabel idea that Jose gave us back on May 21st
> >
>