Copy column from subtable to paste into email program?

Creating and using forms

Copy column from subtable to paste into email program?

Postby ezylstra » Sat Jul 29, 2017 8:47 pm

I have a base form with a subtable that pulls together records that have an email address field. I would like to be able to select the email address column, hit ctl-c, go to Outlook, hit ctl-v in the bcc field and have the list of email addresses show up. Currently, I only get one email address.

Is there some way to get close to this behavior?

Thanks,

EZ
OpenOffice 4.1.3
ezylstra
 
Posts: 5
Joined: Fri Jul 14, 2017 12:18 am

Re: Copy column from subtable to paste into email program?

Postby Villeroy » Sat Jul 29, 2017 10:23 pm

Open a new spreadsheet
Click the subform and then the last button of the navigarion tool bar ("Data source as table").
Now you have a additional grid view
Drag the top-left grey corner of that view into the spreadsheet.
When you copy these data from a spreadsheet into plain text context, the columns are tab separated.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24398
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Forms

Who is online

Users browsing this forum: No registered users and 4 guests