[Solved] Macro To Open Email within different section

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
SEHA
Posts: 6
Joined: Tue Mar 08, 2016 12:09 pm

[Solved] Macro To Open Email within different section

Post 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
Last edited by Hagar Delest on Sun Mar 13, 2016 8:40 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4.1.2 on Windows 8
SEHA
Posts: 6
Joined: Tue Mar 08, 2016 12:09 pm

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

Post by SEHA »

Please help me.....
OpenOffice 4.1.2 on Windows 8
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Post 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?)
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
SEHA
Posts: 6
Joined: Tue Mar 08, 2016 12:09 pm

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

Post 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...
OpenOffice 4.1.2 on Windows 8
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Post by Zizi64 »

You can find many threads related to your problem. Here is one:

viewtopic.php?f=20&t=82067&p=379788
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
SEHA
Posts: 6
Joined: Tue Mar 08, 2016 12:09 pm

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

Post 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.
OpenOffice 4.1.2 on Windows 8
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Post 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.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
SEHA
Posts: 6
Joined: Tue Mar 08, 2016 12:09 pm

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

Post by SEHA »

Thanks for your help.
OpenOffice 4.1.2 on Windows 8
SEHA
Posts: 6
Joined: Tue Mar 08, 2016 12:09 pm

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

Post by SEHA »

Solved
OpenOffice 4.1.2 on Windows 8
Post Reply