|
|
|
Submitted on: 9/30/1999
By: Tmess
Level: Not Given
User Rating:
By 6 Users
Compatibility:VB 5.0, VB 6.0
Users have accessed this code 38922 times.
| |
| | | Have you ever wanted to merge data from a database to Word when say one person has multiple records asscociated with them. Word doesn't allow this. For example, It allows one person record but what if you want to show multiple orders in the document for that person. Access allows you to do this with a subreport but not word. This code will allow you to create a new word document, add text to it, format the text, insert data from one or more databases into it, print it, save it, e-mail it using outlook, and/or then delete it if you want. Raised events allow you to know the current status of the class. The sample included shows you how to use it with the Northwind.mdb Perhaps if you want you can make it out of process activeX exe. Check it out. It really is a useful Tool if you need to work with word. Note: This does not use a DDE connection
| |
| |
|
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.
Virus note:All files are scanned once-a-day by Planet Source Code for viruses,but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1)Re-scan downloaded files using your personal virus checker before using it.
2)NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
3)Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
|
|
Other 3 submission(s) by this author
|
|
| |
 Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
 10/1/1999 6:37:00 AM: Ben
i am missing form1.frm
please send it to me. I am very interested in your code.
(If this comment was disrespectful, please report it.)
|
10/1/1999 7:09:00 AM: Tmess
I uploaded a new zip with form1. Sorry I forgot to include it.
(If this comment was disrespectful, please report it.)
|
10/4/1999 11:22:00 PM: jritchie
Still no form1.frm in the zip file. Is the new upload some where else????
(If this comment was disrespectful, please report it.)
|
10/5/1999 6:43:00 AM: Tmess
I just checked it out and downloaded it. It seems to be all there. I don't know why you can't see it. Hmmm.....?
(If this comment was disrespectful, please report it.)
|
10/7/1999 11:03:00 AM: alanl
you can get the form1 by first unzipping the file, opening the project, click 'yes' when asked to continue without form1, then after project has loaded, add the form manually.
(If this comment was disrespectful, please report it.)
|
11/3/1999 6:05:00 AM: shane
I could not get it to load because of an invalid key error. I am working on a project that does exactly this and would love to see how you worked the solutions. I am pretty much a newbie and so I can be st--id sometimes, but I love learning to do things with VB. Thanks a lot. :o)
(If this comment was disrespectful, please report it.)
|
1/24/2000 9:41:59 AM: VS
do you know of any code that I can use to get values from a Word document place them in an array and then place them in tables in Access. Please help me out with this code
(If this comment was disrespectful, please report it.)
|
4/19/2000 4:29:25 PM: Mike
Great Code!
Do you know how to delete the value of a table in word before inserting a new one? If you do, Please e-mail me.
Thanks.
(If this comment was disrespectful, please report it.)
|
5/4/2000 5:03:28 AM: Lars Iversen
Excellent Code ! I cot a lot of tips from it Tnx
(If this comment was disrespectful, please report it.)
|
9/22/2000 2:13:16 PM: Carlos Escobar
excellent code example!
Unfortunately when I closed the project I got run time error 462: The remote server machine does not exist or is unavailable. Maybe I closed the Word Document too soon? The code it errored on was wrdApp.Quit
(If this comment was disrespectful, please report it.)
|
1/20/2001 3:07:03 PM: sonja
This is some great code. I did notice if you are trying to do string functions utilizing left(str,int)or right(str,int)your alignment enums of right and left override these string functions. You may want to change the alignment enums to leftA and rightA.
(If this comment was disrespectful, please report it.)
|
12/8/2001 5:20:11 PM: Ian
Your program is just what i needed to complete my mail merge project but i am having difficulties understanding it, could you please put a copy of the database you used with the other files so i can run it and see how it works. Thank You
(If this comment was disrespectful, please report it.)
|
2/22/2002 8:23:25 AM: Adrian
Tried to download from the planet-source website but it kept giving page not found error. I'd really like this code, can someone e-mail it to me?
(If this comment was disrespectful, please report it.)
|
3/26/2003 1:24:34 AM:
Do you the same code in vb.net which i can use in my web application using vb.net?
(If this comment was disrespectful, please report it.)
|
5/16/2003 1:45:02 AM:
How to add item in db through COM??
(If this comment was disrespectful, please report it.)
|
6/8/2006 12:04:48 PM: AK
I am totally new to the extensions and codes. Could you please explain which files go where...I mean, which ones go my access database, and which ones for Word template etc.
(If this comment was disrespectful, please report it.)
|
7/13/2007 12:24:07 PM: Gok
It's my pleasure if you can forward me the Northwind.mdb as i need it to run the- Export from VB to Word
FYI, I don't really get how to modify the code base on my database.
Hopefully when i got the file, then i can modify it according to my database.
God Bless You
(If this comment was disrespectful, please report it.)
|
9/28/2007 4:54:24 AM: prsna515
this code is usefull for generating order form for me. but im using jmail.
Thanks
(If this comment was disrespectful, please report it.)
|
10/16/2007 12:54:12 PM: Peter Shaw
Including your own database with this would have been VERY useful indeed.
(If this comment was disrespectful, please report it.)
|
1/14/2009 12:19:53 AM: Masino Sinaga
Open the prjMergeWithWordDoc.vbp file by Notepad, edit or replace line:
Form=..\Form1.frm
with:
Form=Form1.frm
then save the file, and open or double-click again the prjMergeWithWordDoc.vbp file as usual.
(If this comment was disrespectful, please report it.)
|
|
|
Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author from the email account you registered on the site, so you can correspond directly.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
|
To post feedback, first please login.
|
