jkimzlg
asked on
MS Word invalid mail merge
I've been trying to do fix this problem for awhile! Basically this morning somehow when i try to generate docs those filed will no longer merge! Can someone please help me base on the screenshot below?
error.JPG
error.JPG
Last Comment
ASKER
are you referring to the law_co.txt? sorry i'm not sure which txt file
The one listed in the first error message:
Z:\Abacus\LawTemp\Law_CO.T
That's the one Word is trying to open as the data source, and that's the one that triggers the ensuing error messages.
Z:\Abacus\LawTemp\Law_CO.T
That's the one Word is trying to open as the data source, and that's the one that triggers the ensuing error messages.
ASKER
is it possible if i can get your email and send it to u via email?
The first message isn't an error. It is a routine security message which could be removed with a registry patch.
It isn't clear what you did what you encountered the second 'error'. It looks as if the file is not tab-separated, but comma-separated, though not in a rigorous format with the fields in quotes: "File_(a) Preparing", "File_(b) Recording", "File_(c) Filing", ...
Note that teylyn and I both have email addresses in our respective profiles, though hers is easier to read.
It isn't clear what you did what you encountered the second 'error'. It looks as if the file is not tab-separated, but comma-separated, though not in a rigorous format with the fields in quotes: "File_(a) Preparing", "File_(b) Recording", "File_(c) Filing", ...
Note that teylyn and I both have email addresses in our respective profiles, though hers is easier to read.
ASKER
Any solution? someone please help i am really stressed about this and don't know what to do.
Without seeing the file, it's hard to suggest a solution.
I suggested that you upload a sample of the text file for inspection. GrahamSkan has pointed you to our respective email addresses.
cheers, teylyn
I suggested that you upload a sample of the text file for inspection. GrahamSkan has pointed you to our respective email addresses.
cheers, teylyn
ASKER
i've send a sample of the text file for inspection to your email address, can you please enlighten me!
The first record of this file, i.e. up to the first carriage return and line feed, which would be treated as the header has 709 fields. The others have 269, 1, 396,34,1, though I may have missed some. The 709 seems an enormous number. Even if this is legal, the other following records should have the same number of fields.
ASKER
How should i carry on from here? Please enlighten me
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Oops! Pressed submit too early
I have used your text file as a basis for a twenty-field example with a header and two data records (no names in the files)
I have used your text file as a basis for a twenty-field example with a header and two data records (no names in the files)
Microsoft Applications
Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.
45K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
it seems that the source file for the mail merge does not have the correct delimiters for either the fields or the records. There should be a comma between fields of the same record, and an Enter character at the end of each record. Can you post the first dozen or so rows of the TXT file for inspection? Please do not post confidential data.
cheers, teylyn