Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.word.vba.general,microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default SELECT UNIQUE some_column FROM MAILMERGE.DATASOURCE


The MailMerge.Datasource for my MS-Word mailmerge is an Excel-Table,
and the first column in that table contains a group indicator. Rarely
all addresses in the table are to be processed, but they are to be
selected according to the group indicator, excluded or included.

Unfortunately the dialogs both of MS-Word as well as Excel do not
provide enough options to present all the group indicators.

So I would like to build a MS-Userform with a dynamically built
table of RadioButtons for each group indicator found in the Excel
table, but I am not sure how to approach a solution for that problem.
In pure SQL, I would submit a SELECT UNIQUE column_1 FROM the
MailMerge.Datasource, but I don't know if this can be done without
confusing MS-Word's Mailmerge process, and also I don't know if Excel
does not have some home-brew methods to achieve the same result, for
which I would call the Excel-Application to do the work for my MS-Word
VBA program.

Any hints on where to go from all thos most valued experts?


Yours,
L.W.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel function to select unique values... [email protected] Excel Discussion (Misc queries) 1 September 22nd 08 08:35 PM
How can I do amalgamate 3 select queries and then get unique entries from the result Astra[_2_] Excel Programming 2 March 7th 06 02:29 PM
Code for prompts for user to select datasource range for pivot tab Linda Excel Programming 0 January 27th 06 04:31 PM
how do I select unique dates from a database in Excel? pomalley Excel Worksheet Functions 3 March 9th 05 03:02 PM
select unique to make list Spunky Excel Worksheet Functions 2 November 23rd 04 08:19 PM


All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"