MS SQL and MailMerge help..

Started by
0 comments, last by Mykre 19 years, 3 months ago
I have a mailmerge form that has two fields: 1. <<FieldOne>> $ <<FieldTwo>> is how it looks like. What I have to do is emulate a table build by calling a User Defined Function from my Stored Procedure. In my User Defined Function I need to loop through the entire table and get all the data for these two fields and make output look like this: 1. Bob $ 5030.40 2. Allen $ 4500.98 3. Steve $ 2345.75 4. Mary $ 234.75 Until EOF This needs to print on one form with the 2 mergefields. It wants to print a new page per row, but I dont want it too. I searched google and could not find anything like this on how to loop output for two mergefields. Can anyone help me? Thanks for your time,
Advertisement
If you can post some more information on the problem it will help.

Can you post the table information that you are trying to merge, and some sample data (Say 5 rows of data).
Mykre - BlogVirtual Realm :- XNA News and Resources from Down Under** For those Interested in an Australian XNA User Group Contact me though my site.

This topic is closed to new replies.

Advertisement