Over 1 million tech questions and answers.

ODBC Connection doesn't update when trying to mailmerge.

Q: ODBC Connection doesn't update when trying to mailmerge.

I have recently updated my ODBC connection settings to my sql database, however when I open a word 2003 document to mailmerge it still tries to connect to the old database settings.
Is there a way to refresh the settings in the word document so that it acknowledges the changes?
Any help is much appreciated

Preferred Solution: ODBC Connection doesn't update when trying to mailmerge.

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: ODBC Connection doesn't update when trying to mailmerge.

Hi Gortini. Welcome to the TSG Forums

I suggest that you ask a Moderator to move your post to "Software & Hardware, Business Applications" as you are more likely to get a reply there than in the Windows XP Forum.

Please do NOT post again. You must ask a Moderator to move the post.


Read other 2 answers

I am trying to create a mailmerge using Word 2003. My database is SQLServer 2000. I have created the main merge document but my problem is setting up the ODBC Connection. I use: ie Techprod - ODBC DSN; datasource to connect to - wilbur. I am getting no data. any help is greatly appreciated.


A:Problem with ODBC DSN in Word 2003 MailMerge

Read other 7 answers

I have developed a problem on notebook regarding doing a mail merge with an Excel file. It says that it cannot establish a DDE Link (or something very similiar to that) and then it defaults out of the pages. I have tried to re-install MS Office 2000 twice now, and it still has not corrected itself. Can one of you Office gurus give me a hand here on this one. This is a feature that I constantly need for work.

Thanks so much in advance...


[Edited by Dreamboat on 04-06-2001 at 12:04 AM]

A:Office 2000: Mailmerge w/Excel gives DDE Error. ODBC anyone?

Open your file and hit the Get data button. At the bottom of that dialog box should be a "select method" button. Click on that before picking your Excel file and then pick the Excel file.

If that does not help, you may have been on the right track reinstalling. I'm sure it's something with ODBC, but I don't know anybody who knows about this stuff (I'm going to reword your topic) and by the time we find out, you might as well have reinstalled it. So, if you don't want to wait, read on...

Also, never reinstall Office without first using Eraser. It's here:


Read other 3 answers

I have connected to a Access DataBase through AutoCAD for 3 years. Recently I get a error SQL client unable to establish SQL connection.
Microsoft ODBC Microsoft Access Driver System Resource exceeded.

Database record is small.
Have looked at other postings on this problem and none seems to be relative. Also most I do not understand how to do what is recommened.
Windows XP
AutoCAD 2013
Access 2007 database.
All help would be appreciated but include steps for trouble shooting.
Thank you in advance

Read other answers

I am trying to connect to access 2007 but in my odbc there is only a driver for SQL I have 64 bit. I have read some fixes here but still have figured it out can anyone help.

Read other answers

I've developed a site www.kitkrazy.com using PHP, Access and an ODBC connection. It works very well ... most of the time.

Every now and again -- say every three months -- the site crashes, and I get the error message ...

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.,

Most recently I got ...

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded., SQL state S1001 in SQLExecDirect in E:\home\Default\kitkrazy.com\htdocs\include\topthree.php on line 15
[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.

When I challenge the hosting company on this they always advise me to use a DSN-less connection. Well, it's got to the point where I'm thinking to myself, why don't I just go DSN-less and the hell with it.

So I took a look. And it seems that I'm going to have to rewrite all my SQL queries and database calls. Unless you know different ...

Is there a simple way to convert all my code from ODBC to DSN-less?


A:PHP: Converting from ODBC to DSN-less connection

You should probably convert to MySQL or a real database if you are having trouble with too many users accessing the database. You may also want to check all of your code to see that it is clean and you are closing all open object when the program is done with them. You will have the exact same problem with with a DSN-less connection and it will actually slow your site down. Rewriting the connection string is the only change you will need to make and if you use an include file for the DB connection string all you need to do is change one file.

Read other 2 answers


I'm not sure if i'm posting this in the correct area, but please let me know and I will move to appropriate forum.

I have a application I use that connects to a default ODBC connection "Connection1" which is the production enviroment. I want to create a shortcut on my desktop to point to the TEST enviroment so I don't have to go through and change odbc settings all the time. I added a SQL Server connection under System DSN "Connection2" which point to test database. In the shortcut properties I added to the end of the Target location "-oConnection2" so it looks like this:

C:\programfiles\app\app.exe -o"Connection2"

I saw this setup at another location and trying to set it up on my workstation. I know it's something simple i'm missing. Any help or direction would be great.

Read other answers

I'm running 2005 SQL server on Windows 2008 server. I have both Windows 7 and XP ODBC connections to the server. Everything was working fine but the server was running slow so I tried a windows update. The update made my ODBC connection go flakey, but only on Windows 7. Testing the connection would be successful, for several tests, then fail and you would have to reboot the workstation. I have both SQL server and Native Client. Now I am unable to create a connection with either. I've uninstalled the updates which hasn't helped. It seems like the update changed a security setting somewhere. Creating a new connection now fails with SQL state 08001 and server error 10060

Regards Hakit

I have the system working now with both Win 7 and XP Pro but not really happy with the fix. The SQL passwords seem to be stored in a different encryption for these 2 OS's If I change the password on the SQL server then let Win 7 rebuild it the system works ,, but you can't use that login on XP Pro without doing the same thing over again.

A:ODBC connection problem

Hakit, does your workaround work for users with windows authentication?
IF so can you step me through your method for resetting ?

Read other 3 answers

how I can create a ODBC Connection in windows 8.1 
I am use SQl server Express 2008

Read other answers

I have created a ODBC connection between MS Acceess 2003 and Excel 2003 in Windows 7 32bit enviroment . The Macro ( code ) is as follows :
ActiveSheet.QueryTables.Add(Connection:=Array(Array( _
"ODBC;DSN=MS Access Database;DBQ=D:\Acces7dat\STOCKS.mdb;DefaultDir=D:\Acces7dat;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTim" _
), Array("eout=5;")), Destination:=Range("A1")) ... etc , transferring data from MS Access file stocks.mdb to an Excel spreadsheet for proccessing etc . All this works fine for the last three years until I have installed Windows 7 64 bit . Googling the problem found that I have to run the Windows/SysWOW64/obdcad32.exe file . Doing this appears the ODBC Data Source Admiinstrator with the tabs :
User DSN , System DSN , File DSN , Drivers , Tracing , Connection Pooling and About , and I can't configure all this in order to create a ODBC connection . First , is this the correct way to solve the problem and second how to setup the ODBC Data Source Admiinstrator under all these tabs ? Any help ? thanks in advance.
PS : I have reinstall Ms office 2003 in order to add missing items etc but no luck .

A:how to establish a ODBC connection in Windows 7 64 bit ?

the problem was solved by ODBC Data Source Admiinstrator , pressing the button " Add " and afterwards writing " MS Access 2003 " just right the DSN ( = Data Source Name ) label and OK , no matter should understand all of this .

thanks anyway

Read other 1 answers


We are moving an old Access project from XP too Windows 7 32 and .Net.

However there is something wrong with Windows 7! When I try and create an ODBC link via ODBC Administrator to allow the software to access data tables on SQL Server on the Windows 2003 Server it just keeps producing a message saying the TCP/IP port does not exist or access is denied.

Having tried the same experiment with an XP computer it worked fine, no issues, but Windows 7 strangely doesn't???

The SQL Server is on standard port 1433, I tried turning the firewall off in Windows 7 but that made no difference, when installing Windows 7 and connecting it too the network it complained it needed a DNS address so I put one on the server and set that in the Windows 7 client.

The XP client never needed one, could that be linked to this odd issue?

My first experience of Windows 7 this is and it seems like Microsoft have struck again by taking something that works and making it unnecessarily difficult...

Of course I could be wrong

Read other answers

" the setup routines for the oracle odbc driver could not be loaded due to system error code 998"

Trying to create ODBC connection and then get this error message

also getting same error when trying to remove or edit connection ..

please advice ..URGENT

A:Cant create ODBC connection data resources

You may have the wrong driver as the error suggests.

Try Informix:


Read other 2 answers

Hello everyone
Ok, So here is the deal. I have a My SQL database that is being used with a Access 2003 front end. Its using the MY SQL ODBC driver and a User DSN. I have to deploy this front end to about 200 people and don't want to visit each computer to do so. I need to install the drive which i have built a script to do, and i need to create a DSN. How do i create a User DSN or a system DSN with a batch file with a script. I tried to use a File DSN,Which would have made my life easy as i could just have copied that file to all the computers, But it promoted the user to log into the database when a form is open. Which is no good. Can anyone help me?

A:Solved: Create a ODBC connection with a script

I found a code that will work, Thanks

Const HKEY_LOCAL_MACHINE = &H80000002

strComputer = "."

Set objReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _
strComputer & "\root\default:StdRegProv")

strKeyPath = "SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources"
strValueName = "Script Repository"
strValue = "SQL Server"
objReg.SetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

strKeyPath = "SOFTWARE\ODBC\ODBC.INI\Script Repository"

objReg.CreateKey HKEY_LOCAL_MACHINE,strKeyPath

strKeyPath = "SOFTWARE\ODBC\ODBC.INI\Script Repository"

strValueName = "Database"
strValue = "Script Center"
objReg.SetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

strValueName = "Driver"
strValue = "C:\WINDOWS\System32\SQLSRV32.dll"
objReg.SetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

strValueName = "Server"
strValue = "atl-sql-01"
objReg.SetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

strValueName = "Trusted_Connection"
strValue = "Yes"
objReg.SetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

Read other 1 answers

Create a batch script for Oracle ODBC connection

Read other answers

I have two laptops at my company that have Windows 7 Home - thus cannot login to AD/Domain as a specific user. They in-turn use a local administrative account setup on those laptops. We have a database setup with linked connections to our SQL Server 2005.

Whenever we're trying to access those linked tables we get the following error message:
We can bypass this issue by manually typing in the Login/Password within this error prompt.
What's strange is that we have ODBC setup to use the SQL Server Authentication:
That SHOULD allow us to not use Windows Authentication (as you can see it's trying to use the 'Guest' account on Windows 7. I've tried making this change through both x32 and x64 versions of ODBC (located in wow64). I've searched all over the internet concerning this issue but no one seems to have anything similar. This used to work a few weeks ago and I don't know of anything we changed other than a few system updates.

The SQL Server's Security is setup to use both authentication methods:
Our SQL Server gives us an Error: 18456, Severity: 14, State: 11
A quick Google search explains that State 11 means, "Valid login but server access failure".

Any help please? The only solution I have right now is to install W7 Pro...

A:Access & ODBC connection issue on W7 Home, State 11

Sound like a Windows permissions issue to see the SQL server.

You could also map a network drive using other credentials. This will authenticate the computer onto the domain.

Read other 4 answers

Mac OS X 10.6.1
perl 5.8
mysql 5.1
Installed ODBC connector: http://dev.mysql.com/downloads/connector/odbc/5.1.html#macosx-dmg
I am trying to connect to a mysql DB using the perl API.

The connect command looks like this:
$dbHandle = DBI->connect("DBI:ODBC:gfr:localhost", "gfr", "gfr");

It produces the error:
DBI connect('gfr:localhost','gfr',...) failed: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (SQL-IM002) at x.pl line 30
error = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (SQL-IM002)

I'v done hours of rummaging around the web to find a solution but to now avail.

In desperation I executed the following "find" command:
cd /
sudo find . -name "*odbc*" -print

It produced the following output (only relevant part shown):
./usr/local/li... Read more

A:Solved: mysql connection using ODBC fails with error SQL_IM002

By using a combination of the information at
and the link within that page under "these simple instructions" (http://www.truerwords.net/articles/osx/install_dbd_mysql.html)
I managed to get DBD working instead of ODBC. That is sufficient for me.
I did the above with one difference. I used a later version of the latest non-beta DBD module.

Read other 1 answers

Hi techguy forums!
I have several problems with my computer, which is brand new and worked for about two weeks before developing these problems:
clicking on the firefox shortcuts or executable doens't load firefox, the hourglass shows for a second and nothing happens
i am getting endless popups on internet explorer (which i have been forced to use)
I cannot access certain websites on IE, it seems to be ones related to antivirus e.g. grisoft.com which redirects to windows live search (possible a phishing version)
and finally, avg, adaware and spybot S&D refuse to update over the internet connection

below is my HijackThis Log, Hope someone can help me!

Logfile of HijackThis v1.99.1
Scan saved at 9:09:03 PM, on 7/15/2008
Platform: Windows XP SP3 (WinNT 5.01.2600)
MSIE: Internet Explorer v7.00 (7.00.6000.16674)

Running processes:
C:\Program Files\Lavasoft\Ad-Aware\aawservice.exe
C:\Program Files\Common Files\Apple\Mobile Device Support\bin\AppleMobileDeviceService.exe
C:\Program Files\Common Files\Microsoft Shared\VS7DEBUG\mdm.exe
C:\WI... Read more

Read other answers

Windows XP Service Pack 3Connection: ADSLAV - Eset, NodIf I'm supposed to write something else as well, please do say so.For 6 months it has been working fine. Desktop computer connected to router via LAN (or ethernet, I don't know which expression is the right one), laptop connected wirelessly to that same router, and IPTV connected via LAN. Then all of a sudden a few nights ago, no internet connection on desktop comp with notification about 'no connectivity or low connectivity'. All indication lamps on the router show as before.We have so far tried (and nothing worked): (we have good working computer knowledge, but not troubleshooting and stuff)- restarted router many times- restarted computer many times- did a system restore- unplugged the router's power - disconnected laptop from the network - changed the LAN cable for a new one- changed the IP address from automatically to manually and typed some other addresses (as advised by our ISP who in the end said that we need to reinstall the drivers for network card) - following our ISP's advice, we tried to find the the driver in device manager, there was a driver named network controller, we thought that was the one and uninstalled it, rebooted the computer and tried to install the driver back from the disk that came with the computer (supposedly all drivers on one disk), but the disk said all drivers are installed. Now we don't have that network controller installed. Device manager isn't showi... Read more

A:Laptop wireless int. connection and IPTV work, desktop computer int. connection doesn't (LAN)

Start/Run...type devmgmt.msc and hit Enter.

Click plus sign by Networ Adapters group.

What do you see?

System manufacturer and model?


Read other 5 answers

Please help! I have been trying to "fix" this issue on my laptop for the past month, on and off. I have been using other sources to access the internet reading up on resolutions on this issue and all kinds of forums. I am knowledgeable, but not able to understand some of the fixes and terms that I have come across. I feel like I've tried everything and still I cannot access the internet on my PC wired or wireless.

I have a Toshiba Satellite L505-GS5038. I tried to release & renew my ipconig. Please see below for ipconfig.
Please help!!!


Windows IP Configuration

No operation can be performed on Local Area Connection while it has its media disconnected.

Wireless LAN adapter Wireless Network Connection:

Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::99c7:7719:23ee:4b4d%11
Default Gateway . . . . . . . . . :

Ethernet adapter Local Area Connection:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

Tunnel adapter isatap.hsd1.nj.comcast.net.:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

Tunnel adapter isatap.{94D24E85-E5CD-4F09-9936-AE48393A2683}:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

Tunnel adapter Teredo Tunneling Pseudo-Interface:

Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :

C:\windows\syst... Read more

A:Solved: Local Area Connection/Wireless Network Connection Doesn't Have a Valid IP Con

Read other 14 answers

Cant get it to updateand when i use thr troubleshooternit doesnt work either
Farbar Service Scanner Version: 21-07-2014
Ran by Administrator (administrator) on 03-01-2015 at 16:34:05
Running from "D:\Users\Administrator\Downloads"
Microsoft Windows 7 Ultimate  Service Pack 1 (X86)
Boot Mode: Normal
Internet Services:
Connection Status:
Localhost is accessible.
LAN connected.
Google IP is accessible.
Google.com is accessible.
Yahoo.com is accessible.
Windows Firewall:
mpsdrv Service is not running. Checking service configuration:
The start type of mpsdrv service is OK.
The ImagePath of mpsdrv service is OK.
MpsSvc Service is not running. Checking service configuration:
The start type of MpsSvc service is set to Disabled. The default start type is Auto.
The ImagePath of MpsSvc service is OK.
The ServiceDll of MpsSvc service is OK.
Firewall Disabled Policy:
System Restore:
SDRSVC Service is not running. Checking service configuration:
Checking Start type: ATTENTION!=====> Unable to open SDRSVC registry key. The service key does not exist.
Checking ImagePath: ATTENTION!=====> Unable to open SDRSVC registry key. The service key does not exist.
Checking ServiceDll: ATTENTION!=====> Unable to open SDRSVC registry key. The service key does not exist.
System Restore Disabled Policy:
Action Center:
=====... Read more

A:Windows 7 doesn't update and troubleshooter doesn't work

Please follow the instructions Here to run the System Update Readiness Tool. When the SURT finishes installing, copy (Ctrl + C) and paste (Ctrl + V) the contents of the SURT log into your next post please:C:\Windows\Logs\CBS\CheckSUR.logC:\Windows\Logs\CBS\CheckSUR.persist.log

Read other 1 answers

I have a internet connection through a cable modem.
The modem is a Scientific Atlanta webstar 2100 and also using a wireless router that's a Linksys WRT54GS.
I connect it to my computer and everything. The wireless works fine (i'm using a laptop to create this post). However, it is not a secure network so I wanted to add a password. The problem is that the host computer that is connected to the router has no internet connection. When I open internet explorer or try to find a connection through the troubleshoot, it says it can't find one. Can anybody figure out why this would happen and how to fix it? I think I have the modem's drivers and stuff updated to the host computer and stuff.
Therefore, I have no wait getting to the ip address and/or setting up a secure network.

Please help me,

A:Wireless connection works, but Host computer's connection doesn't

would explain how all connected - all PC should be connected to the router - so there should not be a HOST PC

Read other 2 answers

I am trying to set up a new Thinkpad laptop to work on my HOME workgroup and on a new OFFICE workgroup. I have used the HOME workgroup for many years, with many computers, without a problem, but this is the first time I have needed to set up two networks, and a laptop that works on both (I got a new Thinkpad, and rented a new office at the same time - big mistake).

- I am trying to configure the laptop to belong to the OFFICE workgroup, but have access to computers/shared devices from the HOME workgroup when I am on the home network, and of course share the Internet connection on both networks.

- Both networks have a Wireless Router with firewall - the one at HOME is a Linksys - the one at the OFFICE is a Netgear.

- Because of the firewall in the router, I have turned off Windows Firewall (although interestingly, it seems to turn on by itself quite often on the Thinkpad - another issue i need to get to the bottom of).

- HOME network is cable/cable modem, OFFICE is a T-1.

- I am trying to use IBM's "Access Connections" tool to create two network profiles, so that I can easily switch from OFFICE to HOME. The HOME wifi is unsecured, while the office is WEP.

Both the wired (ethernet) and wireless connections work fine at the office, but at home, the wired connection cannot renew the IP address, and so IBM Access Connections automatically fires up the wireless radio, and is only able to connect that way.

The Local Connection (at home) shows in the system tray... Read more

A:Wireless Connection Works, Ethernet Connection Doesn't

Check the cable, that's the most likely suspect.

Read other 3 answers

Hi,any ideas why System Update offers me an update (Intel Graphics), but then refuses to install it due to "minimum requirements"? Screenshot: Thanks,Aleq

Read other answers

Hi all,
I have been t/s'ing this issue for a couple days now and have tried everything, including utilizing various restore points, short of reinstalling Windows with no success. The original problem started when I was prompted to restart to finish installing updates and it has continued to do so for at least a week now. Here is a list of what I have done:Boot into clean mode
Ran System Update Readiness Tool (CBS logs attached)
Ran sfc /scannow (screenshot attached)
Verified BITS and WU service running
Ran WU diagnostic tool, which gave me the 8007005 error (attached)
Updated the WU agent (v7.6)
Ran MS Fixit 50123 and 50202
Installed KB947821-v34 (Hotfix)
Ran SubInACL to verify registry permissions
Cleared Catroot2 folder
Cleared C:\Windows\SoftwareDistribution\DataStore and \Download
Toggled update option to never check for updates and back to let me choose. This seemed to be the only thing that actually did anything. Windows started to check for updates but did not actually download/install any.

I have also attached the specs of my pc to include currently installed patches for your review. Thanks in advance for your assistance.

Read other answers

First, excuse my english, I'm trying my best.

I get error C80003FA whenever I do a Windows Update run.

I did the Windows Update Posting instructions. When I did the SURT installation, it didn't finish and I had to reboot the PC. Then it work.

I've tried sfc /scannow several times before with different results: sometimes finished with no errors, sometimes finish with unfixable errors and sometimes didn't finish at all.

I uploaded the CBS.zip

Hope you can help me, thanks.

A:Windows Update doesn't update. Error code C80003FA

There are no errors in any of the posted logs
Please post the C:\WIndows\windowsupdate.log file.

Please also post the event logs...

Open Event Viewer
click on the Windows logs entry in the left pane to expand it.
Now click on the Application entry - wait while it loads.
Click on 'File' in the menu bar and select Save...

Save the file as Appevt.evtx

Repeat for the System log

then zip both, and upload them.

Read other 9 answers

I need to fax a slew of documents that I create with MS Word's Mailmerge function. Although I read the instructions in the Word help file, I just can't make this work. Does someone have some experience here that might help?

Here's what I am doing:

1. In MS Word, set up a)Mailmerge Main Document and b)Mailmerge Data Source
2. Click on Inbox to activate MS Exchange. The MS Exchange screen flashes up for a split second, but I get no icon in the lower right.
3. With no internet connection running, I click on Tools, Mailmerge, Merge to Electronic Fax (using data field with fax address), Merge.
4. Nothing happens.

In Control Panel, Add/Remove Programs, Windows Messaging and MS Fax are installed. However, when I click on Mail & Fax on the Control Panel, it tells me that I don't have enough memory or system resources, try to close some windows and try again. Well, I have 96MB of RAM, and closing all windows except MS Word doesn't help.

Does anyone know how to make this work?


[email protected]

A:MS Word:Mailmerge=>Fax

Read other 8 answers

I'm using Windows Vista and Microsoft Office 2007. i want to do a Mail Merge with an Access file to send out letters.

2007 has a "Rules" command that opens up an idiot-proof window for the If - Then - Else command. Unfortunately, I'm more of an idiot than they bargained for.

I want to set up a salutation line that will read either

Dear Mr. Smith,


Dear Mr. Smith and Ms. Jones,

So I type in Dear and then select the Title and LastName fields in the box. I select

If Last_Name_2 is not blank

then I go down to the box that asks you to insert text. I insert


After that, I try to insert the two new fields that I want

Title2 and Last_Name_2

but there's no way to select the fields to insert, and if I just type in << followed by Title2 >> , etc., that doesn't work.

What do I do?

Also, on my other computer I use Windows XP and Office 2003, which doesn't have the handy wizard that I can't figure out. How would I simply enter the code I need in Office 2003?

Read other answers

Using Word 2000 and Excel 2000. The worksheet has 300 names, addresses, city state & zip, several mergefields and a miscellaneous field that contains either a "60", "120", or "180". 3 separate Word documents. These are letters going out to people whose auto leases expire either in 60 days, 120, etc. The worksheet is sorted in zip code order and needs to remain that way. I need to print the appropriate letter to the appropriate lease customer. How can this be done, maintaining the zip order throughout the 300 ? These cannot be run as 3 batches, due to the fact that the bulk mailing must contain at least 200 pieces.

A:Using Word for mailmerge

Read other 8 answers

Our entire office has changed to Office XP. I have several Access 2000 databases that I need to merge with this new program. We are having much difficulty. Is there somewhere I can go for help.
Will all the 2000 files have to be converted?
If I use an old Word 2000 file, I can merge. However, if I create a new main document, the system cannot find my database?
Thanks for the help.

Read other answers

I am trying to merge a few addresses onto a full sheet of avery labels (33)? I have done this before, yet now I can only get the database to print once. I have windows office 2000 and windows XP home edition.

A:MS Word Mailmerge

What exactly do you mean that you can only get the database to print once? If you mean that the document has lost the link to the database with the names and addresses (something that it retained in Office '97), well, that feature was removed by MS for some reason, so you will have to find the data for the labels document every time. If the 33 names remain the same, I would just merge the data to a new document, rather than to the printer, and that new document will be a sheet of those labels ready for use every time you need it.

Read other 3 answers

I have a template which is using font Times New Roman size 14. I have checked all the mail merge fields and they are all correct in the template. However, when I complete the mail merge a number of the fields are merging in a different font and larger or smaller font size.

I am using an Access database to merge from and none of the properties or settings have been changed since setting it up.

Can any one explain why it is doing this and what I can do to sort the problem?

Many thanks


Read other answers

Hi, i've got the problem, that I can't do updates of AntiVir or Windows. When I go to the Windows update site, it redirects me to google.

So I need your help, please.

HijackThis logfile:
Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 21:09:20, on 24.01.2009
Platform: Windows Vista SP1 (WinNT 6.00.1905)
MSIE: Internet Explorer v7.00 (7.00.6001.18000)
Boot mode: Normal

Running processes:
C:\Program Files\Windows Defender\MSASCui.exe
C:\Program Files\Intel\Intel Matrix Storage Manager\IAAnotif.exe
C:\Program Files\HomeCinema\TV Enhance\TVEService.exe
C:\Program Files\Google\Google EULA\GoogleEULALauncher.exe
C:\Program Files\Avira\AntiVir PersonalEdition Classic\avgnt.exe
C:\Program Files\Microsoft Xbox 360 Accessories\XBoxStat.exe
C:\Program Files\iTunes\iTunesHelper.exe
C:\Program Files\Lavasoft\Ad-Aware\AAWTray.exe
C:\Program Files\Windows Media Player\wmpnscfg.exe
C:\Program Files\Spybot - Search & Destroy\TeaTimer.exe
C:\Program Files\Secunia\PSI\psi.exe
C:\Program Files\Mozilla Firefox\firefox.exe
C:\Program Files\Trend Micro\HijackThis\HijackThis.exe

R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://www.aldi.com/
R0 - HKCU\Software\Microsoft\Internet E... Read more

A:Windows update and AntiVir update doesn't work

Read other 9 answers


I have a MailMerge from Access to word. I'm trying to display the date in my word document as Ex. September 11, 2005. I can't seem to get the syntax correct to do this. Can someone lend me a hand? Here's my code:

Private Sub cmdMailMerge_Click()

Set objWordApp = CreateObject("Word.Application")
Set objWord = objWordApp.Documents.Add

' Make Word visible.
objWord.Application.Visible = True
objWord.MailMerge.OpenDataSource _
Name:="C:\Documents and Settings\....", _
LinkToSource:=True, _
Connection:="TABLE tblVendorInfo", _
SQLStatement:="Select * from [tblVendorInfo]"

'Add fields
With objWord.MailMerge.Fields
Set oSel = objWord.Application.Selection

'.Add oSel.Range, "Date"
'I want to add the DATE HERE!!!

oSel.TypeText "To: "
'.Add oSel.Range, "First"
oSel.TypeText " "
'.Add oSel.Range, "Last"

End With
' Execute the mail merge.
objWord.Close (0)

Set objWord = Nothing
End Sub

Thank you for your help!

A:Getting Date when doing a Mailmerge into Word

What format does it come out in and what format is iit stored in your database?

Read other 3 answers

Not sure if this is the right place for this, but, here goes.............

I am trying to find how to mail merge email addresses from excel to Outlook.com. Is it even possible? There doesn't appear to be anything on the web at all that I can find.

Any ideas?

A:Mailmerge from excel to Outlook.com?

What you're supposed to do is write your message using MS Word then use mailmerge in Word to send to recipients whose email addresses you've collected in an Excel spreadheet. If you also add details to separate fields in the spreadsheet like Name, Surname or anything else you need you can insert those fields into your Word document to personalize each message.

Note: Give each field in the Excel spreadsheet headings and define the first row as containing headings.

Sorry but I only use Outlook on my work based machine and don't have it on my home based machine so I cannot post screenshots or go through the whole process step by step but there is a guide here (sort of)

Word Mail Merge: It's not Just for Letters

Read other 3 answers

I'm doing form letters off a database of names. The letter is formatted to be folded and fitted into window envelopes. Why does the first line of text drop on some letters, come back OK and drop again?

A:MS Word MailMerge problem

Hate to ask so quickly, but I'd really have to see the main doc to figure that out . . .

Read other 1 answers

I'm running into 2 problems with merging documents in Office 2007. Both have to do with headers and footers:

1) Each merged document is a separate section. Headers automatically link to previous sections, Footers do not. To update footer information in a merged file, each footer must be selected and either the info pasted in, or the footer linked to the previous section...1 section at a time.

2) Fields in the footer (such as page number, document name, etc.) are converted to text when the document merges.

In a particular exercise, students are required to merge a letter to a new file, then change the file name in the footer to the new file name. They can only do this by changing each footer separately, or by changing the filename before doing the mailmerge.

So, my question...Is there any way to have Word 2007 automatically link footers to previous sections like the headers do? Is there also a way to preserve the integrity of fields in footers (and I'd presume headers as well)?


Michael...who tortures convicts by teaching them Office 2007!

Read other answers

Hi everyone, I have recently "upgraded" to xp professional from win98, and after sorting out one problem after another with compatibility issues (mainly hardware) this one has got me stumped!

Mailmerge from excel sheet to word document, both documents created pre-upgrade, the print is exceedingly slow. when I go to "printers and faxes" and dble clk on default printer (hp laserjet 5l) it pulls the status box and displays the message of the doc title etc. it also shows the document size in kb's and the multible kb's of the entire merge e.g. if I print a mailmerge of 50 letters and each one is 100kb (actual document size is 128Kb) then it displays 100Kb/5Mb, which I assume is the reason it is so bloomin' slow!

Similarly another mailmerge to different document from a different source (still Word and Excel and pre-upgrade) prints no problems at all. Again I set up the print, hit mailmerge, OK'd print properties box, dashed over to "printers and faxes" etc and lo and behold, there was no information in the box, as if it had sent the whole merge straight to the printer. Is this what should happen?

This second O.K. mailmerge prints around every 12 seconds (guesstimate) whereas the one with the problem takes around 2 minutes per page( Similiar sized documents)

If it is of any further help, I finally managed to install the recommended driver for my 5l from the hp site which is a PCL driver written for NT 4.0 / Win 2000, at 3.30 a.m.... Read more

A:Mailmerge excel to word on xp.

Others will be along who are better than I at this kinda problem, but when you preview the mail merge, is it slow, too? (i.e. is this really a print problem...) My suspicion is that you've got an hp driver problem, as I've had some recently with win 2k, and they're quite a party.

Read other 3 answers

I have a word doc file with a datasource defined with it. I open the file in VBA with ...Document.Open("filename") and the file opens with out the datasource. Is there a way to have the doc file open with datasource attached?

Here's snippet of my code:

//Open document and merge new data and save

ls_document_name = "c:\database\test3.doc"





A:Word Mailmerge problem

Check this out. I don't know where you're programming from, but...


Read other 2 answers

There appears to be a problem with merging data from an Excel database into a word mailmerge document. I never had a problem with office97 and win98se.

When merging data using the mail merge helper to set query options to select the appropriate records, the first record in the overall data base is always selected and the first record that should be selected is missed. The rest of the records are selected correctly. This never happened with office97/win98se.

I uninstalled officeXP and installed office 97 and all is well.

Any insight would be appreciated.


A:mailmerge problem in WIN XP, Office XP

Read other 9 answers

Hi. I just started work for my dad company for a few months (I have some debts to pay off) and spent half the morning faxing an offer manually to customers. I'm felt sure that there was an easier way to do this, but it sounds complicated.

They used to have a computer database of customers and suppliers, but stopped using it because of compatability issues (it was in ACT). I don't have coding skills to make them a custom MySQL/PHP solution and I'm not sure if they'd use it, so I'd like to make them a database in Access 07.

I'd like them to be then able to mail merge it Word 07 and then from there somehow to the dedicated fax line (which currently has a HP all in one on it, but I'd like the computer to be able to send faxes on it too), so that it can mailmerge maybe hundreds of faxes and just go through them in the background on the computer without them needing to manually type in the number on the machine for every customer and wait while it scans and faxes it before doing the next one.

I'd also like Access database to be accessable from more than one computer, but doesn't have to be simultaneously if this is too hard (like needing a MS SQL solution)

So my questions are as follows:

Can an access 07 database sit on a network place and be accessable and editable from all computers on network (even if only one at once)?

Can word 07 mailmerge to a fax software?

What fax software is available relatively cheaply (they seem to use ... Read more

A:Access DB > Word Mailmerge > Fax?

Yes you can have an access database that is used by multiple users. yes you can have a mail merged fax letter that will pull in information as well and there are a fair amount of relatively cheap fax packages out there. eFax, Winfax etc.

Read other 2 answers

I am using Word 2010 to mail merge letters. Data is in an Access query. When I select recipients and Finish & Merge, Edit Individual, Merge All only the last record is printed. All other selected records are skipped.

Read other answers

Hi All,

I am trying to do a mail merge on a mapped drive.

The location of the Mapped drive is a http:// address. When I go into the word document to merge the spreadsheet I get an error saying it can no find the address.

Through reading up on this issue, I have noticed that the mail merge does not like http:// addresses.

I have tried inserting the drive then the file name, but it still comes up with th error that it is looking for the http:// address.

Does anyone know how I can overcome this issue?

Any help would be appreciated.

A:Mapping and Mailmerge Issue

anyone know if this is possible?

Read other 1 answers

Hi Folks,

I am starting to get a few headaches from this issue hoping that someone can assist.

I am creating an invoice which I am getting data from an external source, all works fine no problem.

However, I need the header to be visible on any additional pages.

If an invoice is generated and generates 2 or more pages, the footer is displayed on the last page, and the others pages have a message along the lines of 'To be continued'.. etc.

Please let me know if this doesn't make sense..!

Many Thanks

A:Mailmerge Header & Footer

Hi jnaiu and welcome to TG

Does this link help at all

Read other 1 answers

Trying to mailmerge a document where it would have 1 or 2 signatories depending on the company, and since North Americans doesn't want the signatures dated in this instance, I want to make the field display "Date:" if the signatory field above it is not blank AND Regions is not "North America".

I can get each condition to work on its own but I must be doing something wrong when I combine it.....tried a few variations after doing some research but nothing worked. Here are couple of the options I've attempted:

{ IF {MERGEFIELD REGION} <> "North America" "Date:" "" { IF {MERGEFIELD SIGNATORY 1} <> "" "Date:" "" } }

{ IF {MERGEFIELD REGION} = "North America" "" "Date:" "{ IF {MERGEFIELD SIGNATORY 1} <> "" "Date:" "" }" }

Attached are the test .doc and test data in excel.

Any ideas?

Thanks in advance!

A:MSWord 2010 MailMerge with IF and AND

Just tried and used this:

{ IF { MERGEFIELD Signatory2 } <> "" { IF { MERGEFIELD Region } <> "North America" "Date" "" } }

The results are a bit weird.......

If it's North America with a signatory then this shows up: {
If it's North America without a signatory then this shows up: IF
If it's Asia Pacific with a signatory then this shows up: {
If it's Asia Pacific without a signatory then this shows up: IF

Also tried:
{ IF { MERGEFIELD Signatory2 } = "" "" { IF { MERGEFIELD Region } <> "North America" "Date" "" } }

The results are more promising as it blanks out when there's no signatory:

If it's North America with a signatory then this shows up: {
If it's North America without a signatory then it's blank
If it's Asia Pacific with a signatory then this shows up: {
If it's Asia Pacific without a signatory then it's blank

Read other 1 answers

i have searched the net and could not find anything usefull. problem is following. On my biz cvomputer I have entered some 900 contactpersons with full
adresses. For whatever reason I am not able to get the entered adresses exported?? Help

A:Mailmerge Ex Outlook 2003

Is this what you want to do fozzie.See pages 8-10..it's a .pdf format (700mb)http://www.learnit.com/manuals/Outlook%202...03_Module08.pdf

Read other 2 answers

I have a Word document that is bringing in merge fields from an Access db. Under the "Mailings" tab on the ribbon, I am selecting "Merge to Adobe PDF" and the Acrobat PDFMaker dialog box is opening to allow me to send the Word Document as a pdf to each recipient's specific email address. I am enabling the Email options to automatically send Adobe pdf files by email to Outlook.

The pdfs are being generated and sent to a folder of my choosing and also are supposed to be sent to the outbox in Outlook; however, I am getting an error message:

"Error: PDFMaker failed to add receipient's mail address to email message! at record#30"

I have read several forums extensively and have tried this with HTML, Rich Text, and Plain text formatting, but to no avail.

I am using Windows 7; Word 2007 with Acrobat PDFMaker Office COM Addin, Acrobat 9 Pro; and Outlook 2007.

I am using this procedure to send individual yearly Dues notices for my fraternity brothers.

I do not know VBA and would greatly appreciate any help.

zoom zoom

Read other answers