Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update a word form from Excel - tips?
Hello everyone, firstly I have a Word document for employee details, I get
the employee details from a database using Excel as a front end and wish to put various fields into the word document. Not done much on Excel to Word so I was wondering if anyone could throw some tips my way, especially if those tips were to do with placing information on certain lines? EG I have at the moment on the form Name: ___________ now the underscores are simply that, underscores is there something I can add after "Name:" to make insertion easier? Perhaps some type of placeholder that I can simply then go (in some form) wordDocument.PlaceHolders(2).value = rs.getField("fldName").value (that rs.etc might be wrong as just writing this up without looking). Cheers! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update a word form from Excel - tips?
I think you're looking for mail merge
http://word.mvps.org/faqs/MailMerge/...AMailMerge.htm -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "NateBuckley" wrote: Hello everyone, firstly I have a Word document for employee details, I get the employee details from a database using Excel as a front end and wish to put various fields into the word document. Not done much on Excel to Word so I was wondering if anyone could throw some tips my way, especially if those tips were to do with placing information on certain lines? EG I have at the moment on the form Name: ___________ now the underscores are simply that, underscores is there something I can add after "Name:" to make insertion easier? Perhaps some type of placeholder that I can simply then go (in some form) wordDocument.PlaceHolders(2).value = rs.getField("fldName").value (that rs.etc might be wrong as just writing this up without looking). Cheers! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update a word form from Excel - tips?
I like usijng the Macro Recorder when I have problems figuring out how to
write code that I haven't done before. try recording the instructions using the Macro Recorder in Word. Also If you have problems with Word instructions ask the Word Discussion Group. "NateBuckley" wrote: Hello everyone, firstly I have a Word document for employee details, I get the employee details from a database using Excel as a front end and wish to put various fields into the word document. Not done much on Excel to Word so I was wondering if anyone could throw some tips my way, especially if those tips were to do with placing information on certain lines? EG I have at the moment on the form Name: ___________ now the underscores are simply that, underscores is there something I can add after "Name:" to make insertion easier? Perhaps some type of placeholder that I can simply then go (in some form) wordDocument.PlaceHolders(2).value = rs.getField("fldName").value (that rs.etc might be wrong as just writing this up without looking). Cheers! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update a word form from Excel - tips?
Thank you so much. :)
Take care. "Barb Reinhardt" wrote: I think you're looking for mail merge http://word.mvps.org/faqs/MailMerge/...AMailMerge.htm -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "NateBuckley" wrote: Hello everyone, firstly I have a Word document for employee details, I get the employee details from a database using Excel as a front end and wish to put various fields into the word document. Not done much on Excel to Word so I was wondering if anyone could throw some tips my way, especially if those tips were to do with placing information on certain lines? EG I have at the moment on the form Name: ___________ now the underscores are simply that, underscores is there something I can add after "Name:" to make insertion easier? Perhaps some type of placeholder that I can simply then go (in some form) wordDocument.PlaceHolders(2).value = rs.getField("fldName").value (that rs.etc might be wrong as just writing this up without looking). Cheers! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel from Word | Excel Discussion (Misc queries) | |||
How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
Update Adobe form from Excel | Excel Programming | |||
Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) | |||
Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) |