473,395 Members | 1,677 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Datafile for mailmerge in word

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
Nov 20 '05 #1
3 1404
guy
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 wordmailmerge? This example (below) tries to fill the data manually, a row at atime which is too time consuming and also user sees the data filled onefield 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
.

Nov 20 '05 #2
No. Just the windows app.

"guy" <eg*************@wanadoo.fr> wrote in message
news:11****************************@phx.gbl...
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
.

Nov 20 '05 #3
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

Nov 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Shannon Rotz | last post by:
I have a function in a Microsoft Access module (below) which creates a Word XP Mailmerge document, drawing the data from Access XP. I can get the connection to work fine. However, when I create...
4
by: Ray Todd Jr | last post by:
I can't get ths code to correctly execute. After I have clicked on a Access Form, I want the code to open the word document, merge the data, print the forms and then close the two windows that...
2
by: Mikey | last post by:
Sample VB .NET source code to create mailing labels or customized letters using MS Word MailMerge This VB .NET source code will start MS Word and call methods and set properties in MS Word to...
0
by: Anne Richmond | last post by:
I have a Word(2000) mailmerge routine (code below) which works OK but always names the merged document "Forml Letters1". How do I change this to something else? Also how do I automatically save...
0
by: Bob Smith | last post by:
I have existing word documents that we need to have the data document reflect whether we're running in development, test or production. The data header is longer than 255 characters, so I cannot...
9
by: Chubbly Geezer | last post by:
Hope you can help. I have created a mail merge word doc which seems to work fine. When I close and reload it asks if I wish to pull in the data. Great. However, I want to print the results of...
0
by: bobh | last post by:
Hi All, I have this older code(see below) that I used for a mailmerge in another application, I'm looking to do something similar but a little different in that, this time I have a single record...
0
by: dbsog7777 | last post by:
I was trying to use the sample code below, but I encountered two errors: Application.DoEvents() and AutoText(entry). I am not sure how to correct the errors. I trying to use the sample code to...
3
by: brat33 | last post by:
I am trying to use a command button to automate a process for creating mailing labels from a query in Access 2007, going into word 2007. Current code looks like the following: 'Start MS Word Dim...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.