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

Mailmerge - Need to restart entire system to see changes

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer
View previous topic :: View next topic  
Author Message
Dzeni
Guest





PostPosted: Sat Feb 21, 2004 12:08 am    Post subject: Mailmerge - Need to restart entire system to see changes Reply with quote

Help!! I have know how to mailmerge using OOo. I have the document template in writer and the data source in the spreadsheet. When I change something in my datasource, it does not show up when I try and complete the merge unless I restart my entire system first.

I tried saving the spreadsheet, changes did not show up in mail merge.
So I closed down the spreadsheet. Still no luck
So I closed down the writer and then opened it again and tried to merge. Still had the old (and now incorrect data showing)
Finally restarted my system, then tried opening writer and voila, it worked.

But my question is Why?? And is there an easier way of doing this? Hate that I have to restart my machine to see reflected changes. Is most annoying.

Any suggestions deeply appreciated.

Thanks

Dzeni Cool
Back to top
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Sat Feb 21, 2004 5:09 am    Post subject: Reply with quote

This is a known shortcoming of using a Spreadsheet as a data source. If you don't need formulas in your data source then open it in Calc and save to dBase format. Register the dBase file directory as your data source. This will automatically update if altered in Calc or directly from Writer's database explorer view.

If you need formulas then you will need to do all alterations in Calc then resave to dBAse. Here's a macro to do this automatically. http://www.oooforum.org/forum/viewtopic.php?t=3825


Last edited by JohnV on Sat Feb 21, 2004 3:08 pm; edited 1 time in total
Back to top
View user's profile Send private message
Dzeni
Guest





PostPosted: Sat Feb 21, 2004 2:00 pm    Post subject: Thanks Reply with quote

Thanks for that. Great to know that the solution is relatively simple Smile
Back to top
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer 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