A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automatically sort merged fields in Word Table



 
 
Thread Tools Display Modes
  #1  
Old July 23rd, 2009, 04:14 PM posted to microsoft.public.word.tables
Kathy K[_2_]
external usenet poster
 
Posts: 1
Default Automatically sort merged fields in Word Table

I am trying to help a co-worker with a Word Table question.
She is merging information from a db into a .docx (she uses 2003 form but
converter has been installed) After the information has been merged into the
table, users have to sort the table on column 1. She wants this to be as
simple as possible for users - wants to sort on column automatically so the
users don't have to sort after merge.
Any way to do this without any extra steps for users?

Thanks for the help
  #2  
Old July 23rd, 2009, 10:54 PM posted to microsoft.public.word.tables
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Automatically sort merged fields in Word Table

It is really better to do the manipulation in the data source.

Is this a mail merge application or is the data being "merged" into the
document by some other method?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Kathy K" Kathy wrote in message
...
I am trying to help a co-worker with a Word Table question.
She is merging information from a db into a .docx (she uses 2003 form but
converter has been installed) After the information has been merged into
the
table, users have to sort the table on column 1. She wants this to be as
simple as possible for users - wants to sort on column automatically so
the
users don't have to sort after merge.
Any way to do this without any extra steps for users?

Thanks for the help


  #3  
Old July 24th, 2009, 03:22 PM posted to microsoft.public.word.tables
Kathy K[_3_]
external usenet poster
 
Posts: 1
Default Automatically sort merged fields in Word Table

The data is from a computer ERP system called CMIC. the information from
that program is "merged" into a document that is the predetermined form. My
co-worker just wasn't wanting the users that query or "merge" the infor into
her form to have to manipulate any data after the merge. She wants them just
to be able to print the reports generated from the db.

I didn't think there was a way to do this but I told her I would research.
Any futher info would be helpful! Thanks!
--
Kathleen


"Doug Robbins - Word MVP" wrote:

It is really better to do the manipulation in the data source.

Is this a mail merge application or is the data being "merged" into the
document by some other method?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Kathy K" Kathy wrote in message
...
I am trying to help a co-worker with a Word Table question.
She is merging information from a db into a .docx (she uses 2003 form but
converter has been installed) After the information has been merged into
the
table, users have to sort the table on column 1. She wants this to be as
simple as possible for users - wants to sort on column automatically so
the
users don't have to sort after merge.
Any way to do this without any extra steps for users?

Thanks for the help



  #4  
Old July 25th, 2009, 07:23 AM posted to microsoft.public.word.tables
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Automatically sort merged fields in Word Table

We really need a bit more information on the process to give you a
definitive response, but, depending upon how the data is being merged, you
could use a macro to execute the merge to a new document and also have code
in that macro to sort the table.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Kathy K" wrote in message
...
The data is from a computer ERP system called CMIC. the information from
that program is "merged" into a document that is the predetermined form.
My
co-worker just wasn't wanting the users that query or "merge" the infor
into
her form to have to manipulate any data after the merge. She wants them
just
to be able to print the reports generated from the db.

I didn't think there was a way to do this but I told her I would research.
Any futher info would be helpful! Thanks!
--
Kathleen


"Doug Robbins - Word MVP" wrote:

It is really better to do the manipulation in the data source.

Is this a mail merge application or is the data being "merged" into the
document by some other method?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Kathy K" Kathy wrote in message
...
I am trying to help a co-worker with a Word Table question.
She is merging information from a db into a .docx (she uses 2003 form
but
converter has been installed) After the information has been merged
into
the
table, users have to sort the table on column 1. She wants this to be
as
simple as possible for users - wants to sort on column automatically so
the
users don't have to sort after merge.
Any way to do this without any extra steps for users?

Thanks for the help




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.