PC Review


Reply
Thread Tools Rate Thread

Datafile for mailmerge in word

 
 
John
Guest
Posts: n/a
 
      1st Oct 2003
Hi

How can I turn an sql string in my vb app into datasource for a word
mailmerge? This example (below) tries to fill the data manually, a row at a
time which is too time consuming and also user sees the data filled one
field at a time which is not ideal.

http://support.microsoft.com/default...NoWebContent=1

Is there a better way to do this?

Thanks

Regards


 
Reply With Quote
 
 
 
 
guy
Guest
Posts: n/a
 
      1st Oct 2003
Hi,
Have you experienced this method in webform (AspNet)
instead of Windows App?
Best regards
>-----Original Message-----
>Hi
>
>How can I turn an sql string in my vb app into

datasource for a word
>mailmerge? This example (below) tries to fill the data

manually, a row at a
>time which is too time consuming and also user sees the

data filled one
>field at a time which is not ideal.
>
>http://support.microsoft.com/default.aspx

scid=http://support.microsoft.com:80/support/kb/articles/Q
301/6/56.ASP&NoWebContent=1
>
>Is there a better way to do this?
>
>Thanks
>
>Regards
>
>
>.
>

 
Reply With Quote
 
John
Guest
Posts: n/a
 
      2nd Oct 2003
No. Just the windows app.

"guy" <(E-Mail Removed)> wrote in message
news:111801c3886c$af453620$(E-Mail Removed)...
> Hi,
> Have you experienced this method in webform (AspNet)
> instead of Windows App?
> Best regards
> >-----Original Message-----
> >Hi
> >
> >How can I turn an sql string in my vb app into

> datasource for a word
> >mailmerge? This example (below) tries to fill the data

> manually, a row at a
> >time which is too time consuming and also user sees the

> data filled one
> >field at a time which is not ideal.
> >
> >http://support.microsoft.com/default.aspx?

> scid=http://support.microsoft.com:80/support/kb/articles/Q
> 301/6/56.ASP&NoWebContent=1
> >
> >Is there a better way to do this?
> >
> >Thanks
> >
> >Regards
> >
> >
> >.
> >



 
Reply With Quote
 
Cindy M -WordMVP-
Guest
Posts: n/a
 
      12th Oct 2003
Hi John,

It makes me feel ill everytime I see the code in one of these articles...

Certainly there's a better way!

1) You can simply create a delimited text string, save that to file and use it as a data source.

2) Since some versions of Word in certain configurations have issues with *.txt files, you mihgt want to dump the string into Word
and save it in Word document format

3) If you really WANT a Word table as the data source, then place the string into a Word RANGE, then use the ConvertToTable
method on the range

The last thing you ever want to do when automating Word is to create and fill in a table cell-by-cell.

> How can I turn an sql string in my vb app into datasource for a word
> mailmerge? This example (below) tries to fill the data manually, a row at a
> time which is too time consuming and also user sees the data filled one
> field at a time which is not ideal.
>
> http://support.microsoft.com/default...NoWebContent=1
>
> Is there a better way to do this?
>


-- Cindy

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access/Word 2003 Report OR Word mailmerge steward Microsoft Access 3 10th Jul 2008 12:34 AM
Mailmerge with word =?Utf-8?B?SmFuZXQ=?= Microsoft Outlook Installation 5 20th Feb 2004 11:29 PM
Mailmerge in Word with ASP.NET RH Microsoft ASP .NET 0 14th Nov 2003 03:24 PM
Word Mailmerge John Microsoft VB .NET 10 7th Oct 2003 01:32 AM
word mailmerge debbie Windows XP General 1 14th Jul 2003 01:16 PM


Features
 

Advertising
 

Newsgroups
 


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