[Solved] Macro To Open Email within different section

The Application Programming Interface and the OASIS Open Document Format

[Solved] Macro To Open Email within different section

Postby SEHA » Tue Mar 08, 2016 12:23 pm

Code: Select all   Expand viewCollapse view
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

Postby SEHA » Wed Mar 09, 2016 9:18 am

Please help me.....
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

Postby Zizi64 » Wed Mar 09, 2016 10:52 am

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; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.3 and AOO4.1.4
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6082
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby SEHA » Thu Mar 10, 2016 4:24 am

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
SEHA
 
Posts: 6
Joined: Tue Mar 08, 2016 12:09 pm

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

Postby Zizi64 » Thu Mar 10, 2016 8:14 am

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

https://forum.openoffice.org/en/forum/v ... 7&p=379788
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.3 and AOO4.1.4
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6082
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby SEHA » Fri Mar 11, 2016 9:03 am

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
SEHA
 
Posts: 6
Joined: Tue Mar 08, 2016 12:09 pm

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

Postby Zizi64 » Fri Mar 11, 2016 9:26 am

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; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.3 and AOO4.1.4
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6082
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby SEHA » Fri Mar 11, 2016 9:29 am

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

Postby SEHA » Fri Mar 11, 2016 9:32 am

Solved
OpenOffice 4.1.2 on Windows 8
SEHA
 
Posts: 6
Joined: Tue Mar 08, 2016 12:09 pm


Return to UNO API and ODF

Who is online

Users browsing this forum: No registered users and 1 guest