OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Merging data from PB with a OpenOffice Template

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
dhruv_chhajed
Newbie
Newbie


Joined: 05 Mar 2003
Posts: 3
Location: India

PostPosted: Thu Mar 06, 2003 12:04 am    Post subject: Merging data from PB with a OpenOffice Template Reply with quote

I was wondering if you have some ideas of how I would do the following.

I have...
1. A PB application which contains a data window with multiple rows of data.
2. A Word template that has template fields that match the data fields on
the data window.

I want to..
1. Take records from my data window, one by one, and merge with this
OpenOffice Template.
2. User is able to modification in template and template fields.

i am working with PB 7.0 and MS Sqlserver 7.0

How would I accomplish this.
Dhurv
Back to top
View user's profile Send private message Yahoo Messenger
draude
Administrator
Administrator


Joined: 10 Dec 2002
Posts: 353
Location: San Francisco

PostPosted: Thu Mar 06, 2003 1:06 pm    Post subject: Reply with quote

Isn't this standard mail merge (form letter) functionality or am I missing something?

Have you tried to setup SQL server as a data source in your OOo template? You don't need to have PowerBuilder come between OOo and the actual data source.
Back to top
View user's profile Send private message Visit poster's website
Guest






PostPosted: Thu Mar 06, 2003 2:41 pm    Post subject: Reply with quote

Try this to see if I understand what you want to do.

Open a new Writer document and press F4 to show your registered databases. Open up the Bibliograghy database until you can click on the biblio table. The data will appear to the right.

Drag & drop a few field names (not actual data) into the document. Click the gray box to the left of one of the records so the record is highlighted. Then click the Data to Fields icon, which is next to the envelopes. The data should replace the field names.

If this is what you want then you simply need to set up your database as a data source and you're on your way. You will most likely have to read the help to get your database registered but I managed so it can't be too hard.

JohnV
Back to top
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group