mail merge with User Defined Data

[horndog]

I have a client who is using a MySQL database and the front end i
written in Visual Basic 6. What the client would like is a documen
that outputs postcards and/or labels with:

Name
address
city, state, zip

Now, the tricky part is that it wants it to be called via a fiel
called: "Return Date" The "Return Date" will change from month t
month, but the client would like to be able to input a date range via
form or dialog box.

The goals for this would be:

1. Take a query and the user will be able to insert(user define via
form) a date range for the mail merge(if possible).

2. Have the option of creating a post card and /or labels.

3. Be able to access this from a template and through the application

4. Word template not to lose the data source.

Can this be done in word alone or should I have this created in th
application?

What methods should be used

 

[horndog]

anyone know if this can be done

 

[Cindy M -WordMVP-]

Hi Horndog,

anyone know if this can be done?

Did you see my response?

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

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

 

[horndog]

yes, thank you for the response. I am looking at functionality and
stability to do this.

So you say that I could just do the query at the application level and
have the output to a Word template with datafields on the Word
template?

Was this KB article on MSDN's website?

Thanks

 

[horndog]

I did some searching and finally found some useful articles with
Microsoft.. Microsoft's website is a pain in the you know where.

Anyways, I like the idea of automating it from the application itself
and can just pull data and dump it into word. I found about 4 articles
with code snippets.

I will have to create two new forms in the VB application and do the
merges. One form will do the date range and the other will do the zip
codes.

Thanks for the pointing, I guess its time to go write some code and see
all the pretty code colors!

 

[Cindy M -WordMVP-]

Hi Horndog,

I guess its time to go write some code and see
all the pretty code colors!

<G> Have fun! Do come back if you run into any snags along
the way. Or, if your questions are more generally about how
to automate Word and less about mail merge, one of the
word.vba groups would probably be better.

Cindy Meister