Page 1 of 1

[Solved] Macro To Open Email within different section

Posted: Tue Mar 08, 2016 12:23 pm
by SEHA

Code: Select all

REM*********Email*************
Sub on_record_change(oEv)
Dim Buttons() As String
    frm = oEv.Source
    cols = frm.getColumns()
    btn = frm.getByName("1")
    tag = btn.Tag
    field = cols.getByName(tag)
    btn.TargetURL = "mailto:"& field.getString()

End Sub

Re: How to use this Macro To Open Email within different sec

Posted: Wed Mar 09, 2016 9:18 am
by SEHA
Please help me.....

Re: How to use this Macro To Open Email within different sec

Posted: Wed Mar 09, 2016 10:52 am
by Zizi64
What do you want to achieve really? Do you want to launch the installed E-mail client, and do you want pass some things to the client? (Do you want to pass the Address, the Subject, the Attachment, or the Body text?)

Re: How to use this Macro To Open Email within different sec

Posted: Thu Mar 10, 2016 4:24 am
by SEHA
First of of all thanks for your post, yes i want to install the email client and want it to do different activities as mentioned by you.i will be waiting for your reply...

Re: How to use this Macro To Open Email within different sec

Posted: Thu Mar 10, 2016 8:14 am
by Zizi64
You can find many threads related to your problem. Here is one:

viewtopic.php?f=20&t=82067&p=379788

Re: How to use this Macro To Open Email within different sec

Posted: Fri Mar 11, 2016 9:03 am
by SEHA
Thanks for helping but now i have one more issue .
I searched for it but i could not able to find simple explanation.
We are 3 persons about to use the database but if it is open on my computer, It gives error on my friends computer.
Can you help me to fix it.
Please explain me in simple language.

Re: How to use this Macro To Open Email within different sec

Posted: Fri Mar 11, 2016 9:26 am
by Zizi64
We are 3 persons about to use the database but if it is open on my computer, It gives error on my friends computer.
It is an another problem, another task. Please create for this a new topic. (If that 'database' is a real database, then create a topic in the Base forum.

Just a tip:
We (a little ltd.) are using a Calc template file as Address book for create 'email attachment letters' to our clients. (I can not use the databases, because I do not know the technology of the databases.)
The template file will open on more than one network computer (as "Unnamed1" file) without any problem. Note: It is a workaround only, but not a professional solution.

Re: How to use this Macro To Open Email within different sec

Posted: Fri Mar 11, 2016 9:29 am
by SEHA
Thanks for your help.

Re: How to use this Macro To Open Email within different sec

Posted: Fri Mar 11, 2016 9:32 am
by SEHA
Solved