WORD TO ACCESS

[gearhead03]

I have a contract that is three pages in Microsoft Word. I want to be able to take data from a table/query in Access and put it in the appropriate blocks. i.e. name, address, city, state, zip, fid#, and phone#. I am pretty good with access reports but i don't have any idea how to go about this situation. I am using Access97.

 

[sxschech]

How are the data formatted? Is the information in a Word Table, Delimited, Fixed Position? Is the data transfer a one time process or will this be ongoing?

 

[gearhead03]

The data I will be using will be coming from an Access table or query. What I would like to be able to do is have a table of customers name, address, etc... (Which I already have). Place a button on that form (which I know how to do) and have it print out this contract with that customers information on it. The format would be something like; given this ___day of ____ of the year_____ this contract entered into and between my company and _{your company here}___ located at ___{your co. address here}___,__{city}__,__{state}__,___{zip}___.blah blah blah blah your contract number from here until the expiration of this contract is___{your company id#}____.more blah blah blah.

I would just retype everything however access doesn't seem to like that much text.

 

[MakeItSo]

Access reports have no problem with such texts.
But: if you want to do it in Word, you need to create a mailmerge document.
-Select the respective table/query from your Access db as data source
-save the mailmerge as some contract.dot and then simply
-"Add mailmerge field" to your Document.
Put the cursor where you'd like the Company name to be pulled in and choose "company" (or whatever you field is called" from the mailmerge fields dropdown in Word.

Hope this helps,
Andy

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[gearhead03]

When I do the mail merge. My phone numbers display as 5555551212 instead of (555) 555-1212. I the original table the property for the number is set to text, size:10, with an input mask that doesn't save the ()and -. I changed that but it still displays with out the ()and -.
Also is there a way to import this file to make it a report in msaccess. I am using access97.