The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Office 2007 issue when running a mail merge?
Posted: 20 Sep 07 9:02 AM
|
Running SalesLogix 7.0 SP1.
Trying to do a mail merge from within SalesLogix into a Word document. We're using a very simple built-in document. On 2 new workstations we recently purchased (the only ones running Office 2007), we get an error message. They are clean PCs from Dell, brand new. They are running Windows XP Pro. The error says:
"The Mail Merge Engine encountered an error and cannot continue. Bad parameter."
As a test, we took a spare workstation here that was running Office 2003 and verified it ran the mail merge fine. We then simply upgraded Office 2003 to 2007, and re-ran the mail merge. We get the same error listed above.
We've contacted Sage Software, and they've been working on the issue for almost 2 months. They've been unable to help at all, and say they cannot duplicate the issue on their testbed.
I'm at a loss since the error seems obviously triggered by Office 2007. Other SalesLogix users MUST be running 2007 by now. I'm assuming there's something different about our install, but I have no idea what it could be.
Anyone have any suggestions?
Thanks! |
|
|
|
Re: Office 2007 issue when running a mail merge?
Posted: 20 Sep 07 11:14 AM
|
| Not that this will help you, but I run Office 2007 (also many other users at my company use Office 2007) and we've not seen that problem. So it's not specifically an Office 2007 issue. |
|
|
|
Re: Office 2007 issue when running a mail merge?
Posted: 20 Sep 07 11:28 AM
|
I have a customer with the same issue. Trying to reproduce, I installed Office 2007 in a test environment and had no issues.
A few questions-
What version of Office 2007? Was this preinstalled by the computer manufacturer, or did you install yourself? Anything weird about the templates you are using? |
|
|
|
Re: Office 2007 issue when running a mail merge?
Posted: 25 Sep 07 7:50 AM
|
Hey guys -
Thanks for the reply, and sorry for the delayed response.
The first time I noticed this was on 2 brand new Dell Latitude notebook PCs, the first we've ordered with Office 2007. They came with Office 2007 Professional loaded from the factory.
As a test, I took a 2-4 year old Dell Dimension desktop PC that was currently running Office 2003 Professional, and upgraded it to Office 2007 Professional via CD. The system was able to run the mail merge fine with Office 2003, but fails with the same error after upgrading to Office 2007.
Nothing funny that I know of regarding the template. It's called "Base E-Mail 05/26/2006", and I believe is a default template. Looking at it with a preview, it's basically just:
Dear [Contact_Firstname]
[OUTLOOK_SIGNATURE]
..and that's it. Of course we've tried creating a new basic template to test, and I get the same issue.
If I check the box in the preview to "Show Template with Merged Data" it gives me that same "Bad Parameter" error, but when I click OK says "The file name was not defined in OnMergePreview".
Not sure if that helps at all, but figured I'd pass it along.
If anyone has any suggestions, please let me know.
Thanks! |
|
|
|
Re: Office 2007 issue when running a mail merge?
Posted: 26 Sep 07 6:45 AM
|
Compare directory structures between the two machines. It could be that a factory install of Office 2007 is not creating the working directory that Mail merge is expecting to see.
That would explain why an upgraded 2003 system would work but the preload would not.
No guarantees on results, just something to check into....
ws |
|
|
| |
|
Re: Office 2007 issue when running a mail merge?
Posted: 26 Sep 07 11:13 PM
|
Hi Mike,
I just ran into this exact problem with one of my customers. The problem is some how tied to the User Profile.
If you rename thier profile, have them log back into the machine, windows will recreate thier profile. Problem should be gone.
Then copy needed files (Favorites, My Docs, Desktop, startup, etc....) into the new profile. There may be a better way to re-create the profile.
It would be nice if we could figure what in the profile was causing the problem. P.S. this method may not work if you are using roaming profiles.
Best,
Brian Segers
|
|
|
|
Re: Office 2007 issue when running a mail merge?
Posted: 27 Sep 07 12:21 PM
|
| JUst wanted to let you know we are having the same problem here with one of three PCs running Office 2007. It was upgraded from Office 2003 so the situation a little different than yours. I'm going to try the profile fix mentioned below. Please post back here if you find another solution. I'll do likewise. |
|
|
|
Re: Office 2007 issue when running a mail merge?
Posted: 01 Oct 07 2:23 PM
|
| That would explain why an upgraded 2003 system would work but the preload would not. |
|
Actually, if you re-read my post BOTH machines fail now that Office 2007 was installed over a good working Office 2003, so Office 2007 is definitely triggering the issue here.
I just ran into this exact problem with one of my customers. The problem is some how tied to the User Profile.
If you rename thier profile, have them log back into the machine, windows will recreate thier profile. Problem should be gone.
Then copy needed files (Favorites, My Docs, Desktop, startup, etc....) into the new profile. There may be a better way to re-create the profile.
It would be nice if we could figure what in the profile was causing the problem. P.S. this method may not work if you are using roaming profiles. |
|
Thanks for the suggestion. This didn't work for me, but maybe the result will shed some light. After creating a new profile and configuring Outlook, etc., I run SalesLogix and try to create the email, I get a different error:
The Mail Merge Engine encountered an error and cannot continue. There was an error in CreateDataSource(). Error: The specified module could not be found. ErrorCode: -2147024770.
Does this error mean anything to anyone??
| JUst wanted to let you know we are having the same problem here with one of three PCs running Office 2007. It was upgraded from Office 2003 so the situation a little different than yours. I'm going to try the profile fix mentioned below. Please post back here if you find another solution. I'll do likewise. |
|
How'd you make out?
Thanks guys!! |
|
|
| |
|
Re: Office 2007 issue when running a mail merge?
Posted: 01 Oct 07 10:49 PM
|
Originally posted by Mike B
Quote:
JUst wanted to let you know we are having the same problem here with one of three PCs running Office 2007. It was upgraded from Office 2003 so the situation a little different than yours. I'm going to try the profile fix mentioned below. Please post back here if you find another solution. I'll do likewise.
How'd you make out?
|
|
Have not tried anything yet. It's one of our PCs, not a client's, so is low priority (for me anyway, not for the user of that PC).
|
|
|
|
Re: Office 2007 issue when running a mail merge?
Posted: 02 Oct 07 8:56 AM
|
I had 2 users that had this very issue. We have 7.0 with SP1 and have Office 2007. I can have some users that it works for log into the same computer and it would work. These "new" people that were hired would have the the same issue no matter what computer they logged into. Eventualy, with many exports and imports of various keys, I was able to reproduce the bad parameters problem on our side and it was with the following registry key
[HKEY_CURRENT_USER\Software\Microsoft\Office\Common\UserInfo]
"UserName"="Username"
The user that had the problem had a SPACE as the Username key. I removed the space and put in the users username and the problem went away. You can also just remove the space so that there is just "" rather than " " and it would work. So it must have something to do with the usersname key starting with a whitespace.
Once again, if you were to export the above key of the user with the issue, it would look like the following. NOTE that there is a space between the quotes on the UserName key
[HKEY_CURRENT_USER\Software\Microsoft\Office\Common\UserInfo]
"UserName"=" "
"CompanyName"=" "
"Company"=""
"UserInitials"="MSOffice"
Another way that you can go about fixing this without messing around with the registry is the following:
1. Log on to the PC as the user with the problem.
2. Load Microsoft Word 2007
3. Click on the Office icon on the top left of the screen.
4. Click on Word Options
5. The bottom pane that comes up is where the username box is located, delete everything in there and make sure that the cursor is all the way to the left and then type the username in.
6. Do a mail merge in SLX to see if the issue is resolved.
 |
|
|
| |
| |
|
Re: Office 2007 issue when running a mail merge?
Posted: 14 Mar 09 6:21 AM
|
| BTW You don't need to edit registry ! You can just go into Word - Word Options - change the UserName there - if Office was installed as a package then, sometimes, the username is prefixed with a space - or is null. Adding the username fixes this issue "bad parameter". |
|
|
| |
|
Re: Office 2007 issue when running a mail merge?
Posted: 13 Oct 10 7:32 PM
|
| Thanks Brad and Mike! I've been searching for months for a solution to this cryptic error message. I used Mike's suggestion for making the change via Word rather than digging through the registry. My username was set to a single space. When I replaced it with my name and saved the changes, the SLX mail merge worked like a charm. What a bizarre stumbling block! |
|
|
|