 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2007Unable to use "enter" key
I'm working with a data application which uses MS Word and mail merge for letters. My database is Microsoft SQL server. If I open Word directly (just normal word-processing), everything works fine. When I type information into my database, the mail merge function works excellent as long as I do not use the “enter” key. If I use the enter key when imputing data, I receive the following 2 messages: 1. Header Record Delimters Data fields must be separated from each other by a character called a field delimeter. Similarly, data records must be separated by a record delimeter. 2. Word was unable to open the data source. The mail merge works perfect if I do not use the “enter” key. Any ideas?? Thanks,  SignatureMike Try using Shift+Enter instead. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > I'm working with a data application which uses MS Word and mail merge for > letters. My database is Microsoft SQL server. [quoted text clipped - 19 lines] > > Thanks, I continue to have the same problem when I use Shift + enter. any other suggestions? SignatureMike > Try using Shift+Enter instead. > [quoted text clipped - 21 lines] > > > > Thanks, Which version of Word? Peter Jamieson > I'm working with a data application which uses MS Word and mail merge for > letters. My database is Microsoft SQL server. [quoted text clipped - 19 lines] > > Thanks, Word 2003 Small Business Edition SignatureMike > Which version of Word? > [quoted text clipped - 22 lines] > > > > Thanks, It's unusual that you get a message about "header" delimiters these days. Are you using a prepackaged Word applicaiton of some kind? If you start with a completely blank document in Word 2003 and try to connect to the same data source (you'll probably need to use a .odc file), do you still see the same message? Peter Jamieson > Word 2003 Small Business Edition > [quoted text clipped - 26 lines] >> > >> > Thanks, To clarify the above: I can enter 100 characters into my database without prolbems, and the mail merge works wonderful. But, If I enter 50 characters "enter" and another 50 characters, than I encounter this error. I appreciate your assistance SignatureMike > I'm working with a data application which uses MS Word and mail merge for > letters. My database is Microsoft SQL server. [quoted text clipped - 16 lines] > > Thanks, Going back to your original post, as you say you are getting these error messages when you are entering data and one of them is that "Word cannot open the datasource", it sounds like you are trying to update the information in the datasource when that is attached to the mail merge main document in Word. Is that correct? It seems to me that it is quite likely a problem with the field definition in the SQL Server database, but sorry, I am getting out of my depth here. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > To clarify the above: > I can enter 100 characters into my database without prolbems, and the mail [quoted text clipped - 29 lines] >> >> Thanks,
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.