Calc - Button clic saves and sends email

users
#1

Hello !

I have a calc document and wish to create a button which does the following:

- Saves the spreadsheet in PDF in a predetermined path using a cell content
as filename
- Sends an email containing the PDF

I don't care if the program uses python code, libroffice basic, java... as
long as the code is inside the spreadsheet and that anyone who has the file
can execute the button click without installing additional software except
libreoffice.

I don't have enough knowledge to program this :-/ hope you can help me on
this.

Thanks for your help :slight_smile:

#2

Hi :slight_smile:
There is a single button in the default tool-bar that converts to Pdf.
it's beside the printer cons. It doesn't put it straight into an
email though.

Alternatively there is a menu option;
File - Send - As Pdf
but that is 3 clicks.

Regards from
Tom :slight_smile:

#3

Hi :slight_smile:
Please use "Reply to all" when replying to mails from this mailing
list. That way everyone gets to see what is going on so far and might
be able to add the next bit to build up the complete answer or provide
a different approach.

Does anyone know how to make a button and give it the functionality
that exists within the menus? Does anyone know how to take that
further and modify the button's functionality?

Is this something to do with macros? If so then these guides might be
useful. Ch12 of the "Getting Started" guide"
https://wiki.documentfoundation.org/Documentation/Publications
and Andrew Pitonyak's book
https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers

Regards from
Tom :slight_smile:

#4

[snip]

That runs directly counter to what I'd wish. If people "Reply to
all" to this post, I'll get two copies. I don't need two copies,
being as I actually read the mailing list.

In fact: Because some people, for some reason, feel the need to set
"Reply-to" to their own email address: I've a procmail rule that
resets those to the mailing list.

In general terms, on this mailing list or any other, I almost *never*
"Reply to all."

Regards,
Jim

#5

Hi :slight_smile:
Please use "Reply to all" when replying to mails from this mailing
list. That way everyone gets to see what is going on so far and might
be able to add the next bit to build up the complete answer or provide
a different approach.

Does anyone know how to make a button and give it the functionality
that exists within the menus?

Tools/Customize
Choose tab 'Toolbars'
Click 'Add'
Under 'Category' choose 'Documents',
under 'Commands' choose 'E-mail as PDF'
Click 'Add'

Does anyone know how to take that further and modify the button's functionality?

It should be possible to add your own macro to a toolbar (see steps above, but slightly different.... :wink:

Therefore it is not a needed functionality to modify the button's functionality.

One should change the macro-code to change the functionality.

#6

Hi :slight_smile:
Not everyone has that level of technical skill nor that level of
control over their emailing systems. For the rest of us we have to
use "Reply to all" otherwise the mailing list doesn't see the
responses at all.

It does mean some people get 2 copies of the same email but when that
happens to me i just press the delete key a 2nd time and i find that
quite quick and easy to do.

It's always possible to write to the postmaster for this mailing list
and request that the default behaviour for the mailing list gets
changed but a few of us tried that a long old time ago and i can't
really imagine it ever getting changed now.
Regards from
Tom :slight_smile:

#7

I'm sorry, if that was me. I'm new to the list, and using Gmail. I just now
realized what I had done this morning. From now on I will hit Reply-All and
then edit out individuals email addresses.

[?]

#8

<sigh> Please do NOT do that blindly.

Why? Many reasons, but one of the best examples can be found here:

http://www.computerworld.com/s/article/9040878/DHS_e_mail_snafu_reveals_info_on_thousands_of_security_pros?taxonomyId=17&pageNumber=2

or (for those with broken mail clients)

http://tinyurl.com/levk73s

Please use YOUR BRAIN when replying to emails from ALL mailing lists...

1. Use the 'Reply-List' button/feature. Don't have one? Change to a mail client that isn't broken, like Thunderbird, which actually has a single 'Smart Reply' button that automatically switches from 'Reply' to 'Reply List' when it detects the List Headers (which virtually all lists have - except for the brain dead Yahoo lists) when replying to email list emails that only need to go to the list (99% of the time),

2. Use 'Reply-All' *only* when the sender specifically says they are not a list member (I still don't understand why this - or *any* - list allows posts from non-subscribers), and

3. If you have a broken mail client that doesn't have proper Reply-List functionality (<cough>Outlook<cough>) and are unwilling to change to one that does, then use 'Reply-All' but PLEASE remove the senders email address (leaving only the list address) before sending (having to do that is your punishment for not using a decent mail client).

I *hate* getting duplicate emails when someone does that with one of my posts. I'm on the list dammit, I don't need two separate copies of your replies.

#9

That is rude and arrogant and you should *never* do that.

Some people may *prefer* that any replies to one of their posts to a public mail list do not go to the list. Who are you to dictate to them otherwise?

You should *always* honor an *explicitly* set Reply-To.

That said, what people on mail lists *should* be using is a sane mail client that has proper Reply-List capability.

Again - the *cause* of this problem on this list is the stupid decision to allow posts from non-subscribers.

If someone cannot or will not take the time to subscribe to a list, they don't deserve to get any help from it. Period.

#10

[snip]

That is your opinion and you're welcome to it. Mine is that
conversations begun on a mailing list by default should stay on the
mailing list.

Years of experience on a wide variety of mailing lists has taught me
there is a subset of participants that, for whatever reason, set their
default Reply-to to themselves, then expect respondents to "Reply
All." I rarely use "Reply All," and *never* on a mailing list. Too
many times, in the past, I've replied, only to have to copy-and-paste
my reply into a new reply and manually set the reply to the mailing
list.

How Reply-to should be handled, or whether it's handled at all, is a
fairly frequent, and often contentious subject on mailing lists. I've
figured out what works for me. I leave others to their own devices.

As for the mailing list's policies: If they wish to allow un-subscribed
individuals to post, don't wish to set Reply-to or whatever: That's the
list's business, IMO. I'll happily work within the framework they so
graciously provide me :wink:

Regards,
Jim

#11

In fact: Because some people, for some reason, feel the need to set
"Reply-to" to their own email address: I've a procmail rule that
resets those to the mailing list.

That is rude and arrogant and you should *never* do that.

[snip]

That is your opinion and you're welcome to it. Mine is that
conversations begun on a mailing list by default should stay on the
mailing list.

By default, I absolutely agree, but that is not what you said that I replied to.

You said you intentionally set up a promail rule to OVERRIDE A USERS EXPLICITLY SET REPLY-TO.

Not even in the same universe.

Years of experience on a wide variety of mailing lists has taught me
there is a subset of participants that, for whatever reason, set their
default Reply-to to themselves, then expect respondents to "Reply
All."

That is *their* problem, why make it yours?

I rarely use "Reply All," and *never* on a mailing list.

The only time I do is on broken mail lists that:

a) don't have List headers, and

b) are configured to reply to the sender instead of the list.

Then I Reply all and delete the Senders address - but I generally tend to avoid such lists like the plague.

How Reply-to should be handled, or whether it's handled at all, is a
fairly frequent, and often contentious subject on mailing lists.

There is a huge difference between the reply-to-list munging argument, and what you are doing (explicitly overriding a senders explicitly set reply-to).

If you cannot see the difference then I guess we have nothing more to discuss, because I don't (try to) discuss things with stupid people.

As for the mailing list's policies: If they wish to allow un-subscribed
individuals to post, don't wish to set Reply-to or whatever: That's the
list's business, IMO. I'll happily work within the framework they so
graciously provide me :wink:

Agreed... assuming I really want the content of the list in question.

#12

[snip]

If you cannot see the difference then I guess we have nothing more to
discuss, because I don't (try to) discuss things with stupid people.

[snip]

Then you need reply to me no further. On any subject. Here or
elsewhere. Ever. I (try to) avoid people like you.

Jim

#13

Wow... well, at least you *admit* that you are too stupid to see the difference.

Bye now...

#14

Hi :slight_smile:
+1
to the point that conversations begun on the mailing list should stay on-list.

I really liked that i could just "reply to" this post and it went
straight to the list without also going to a selection of other
people. That is the way this mailing list used to work all the time
and it prevented all sorts of problems. The only 1 we had to watch
out for was making sure unsubscribed people were included.
Regards from
Tom :slight_smile:

#15

tagliuzzo
egards,

Jim

dear jim, I'm using thunderbird, and I have the same problem, if I press

R the reply is to the sender non to the list, and I would like to

reply to the list not to the sender, so I have to use reply to list, It seems you are very skilled about, how can I set thunderbird to reply to the list when I press>R???
manythanks, :slight_smile: ciao :slight_smile: pier

#16

I'm not Jim, but probably know far more than he does about Thunderbird.

dear jim, I'm using thunderbird, and I have the same problem, if I press
>R the reply is to the sender non to the list, and I would like to
reply to the list not to the sender, so I have to use reply to list, It
seems you are very skilled about, how can I set thunderbird to reply to
the list when I press>R???

You can't - that is the whole point about keyboard shortcuts - they specifically invoke a specific command.

Computers cannot (yet) read minds.

What you can do is tell the computer what you want to do - in this case, to use the keyboard shortcut to Reply List, do:

CTRL-SHIFT-L

Or, you could use the 'Smart Reply' button, which automatically switches to 'Reply List' for messages that List Headers.

#17

Tanstaafl, where is the smart reply button? I'm running T-Bird 24.3.0 (latest update for me) and see no such button. I have either Reply or Reply to List, but no smart button and no preference or option for such a button that I can find. I'm on a Mac. Sure would be helpful.

Carl

#18

[snip]

>
dear jim, I'm using thunderbird, and I have the same problem, if I
press
>R the reply is to the sender non to the list, and I would like
>to
reply to the list not to the sender, so I have to use reply to list,
It seems you are very skilled about, how can I set thunderbird to
reply to the list when I press>R???

I'm not any kind of Thunderbird expert. While I administer a network
where Thunderbird is the corporate standard, and my wife uses it, I
don't use it, myself. My *guess* would be: "You can't do that." But I
could be wrong. Thunderbird is highly-configurable under the hood. What
you're seeking is a way to remap Ctrl-R to what you want.

However, I would add: I don't know as that's necessarily wise. I don't
know what Thunderbird will do if there is no list to which to
reply--just an individual one-on-one email.

I'm not a fan of the mouse, but this may be one of those times were
you're better-off using it--to click the "reply to list" button.

manythanks, :slight_smile: ciao :slight_smile: pier

You're welcome. Sorry I could not be of more use.

FWIW: What I *am* using for an email client application is Claws-Mail.
For me: Claws-Mail has a number of advantages over Thunderbird, not the
least of which is a rich variety of per-folder preferences that can be
set. Amongst those are "Default to," "Default to for replies," and
"Default reply-to." So, with Claws-Mail, procmail fu is not
required :). (Note: The "default to for replies" overrides/disregards
any Reply-to header. Some people may feel that broken behaviour.)

Regards,
Jim

#19

It is only available in the EMail Header Toolbar (either in the Preview Pane or in individual email windows).

Also, you have to manually add it (right-click in the header > Customize), I always remove the normal Reply button and add the Smart Reply button.

#20

By this I meant that there is NOT a 'Smart Reply' button available for the Main/General Menu Toolbar.

If you'd like to see one, please feel free to vote for my feature request:

https://bugzilla.mozilla.org/show_bug.cgi?id=868961