Mail Merge Macro

[Bill]

Hi Can someone help me with this programming problem or
point me to a resource.

I have an Alphabetic data base by "Year Grad'd" plus
address data.
What I'd like to do is answer the "Year Grad'd" question
and have mail merge create a directory of just the pople
from that year; or answer "All" and create an alphabetic
directory of everyone in the data base.

Look forward to the answer.
Thank you in advance,

Bill

 

[Cindy M -WordMVP-]

Hi Bill,

I have an Alphabetic data base by "Year Grad'd" plus
address data.
What I'd like to do is answer the "Year Grad'd" question
and have mail merge create a directory of just the pople
from that year; or answer "All" and create an alphabetic
directory of everyone in the data base.

Which version of word are we dealing with?

And is "Alphabetic" the name of the application in which
your data is stored? Or is this Access? Or something else?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Bill]

The Data Base is an Excel file.

-----Original Message-----
Hi Bill,

Which version of word are we dealing with?

And is "Alphabetic" the name of the application in which
your data is stored? Or is this Access? Or something else?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e- mail


.

 

[Bill]

I'm running Win Xp and Office Xp
The data base is on Excel.

 

[Cindy M -WordMVP-]

Hi Bill,

I'm running Win Xp and Office Xp
The data base is on Excel.

I have an Alphabetic data base by "Year Grad'd" plus
address data.
What I'd like to do is answer the "Year Grad'd" question
and have mail merge create a directory of just the pople
from that year; or answer "All" and create an alphabetic
directory of everyone in the data base.

And the functionality offered in the Recipient's dialog box
is inadequate for selecting these records?

So, if I understand you correctly, you're looking for help
on how to display a prompt for this information, and having
the user input applied to the data? IOW a macro?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail