Over 1 million tech questions and answers.

Solved: Word 2010 e-mail Mail Merge Problem

Q: Solved: Word 2010 e-mail Mail Merge Problem

I'm using Word 2010 on a Win 7 machine. I'm having problems with mail merge in that when the merge is complete and I click on "OK" once the mail dialog has been completed, nothing happens. My e-mail client does not open up, nor do I see any messages in the outbox. This used to work just fine with Windows Live Mail and Word 2007. I then installed Word 2010 and it does not work now. Any suggestions from anybody? Any assistance would be MUCH appreciated. Microsoft is no help - impossible to contact.

RELEVANCY SCORE 200
Preferred Solution: Solved: Word 2010 e-mail Mail Merge Problem

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: Solved: Word 2010 e-mail Mail Merge Problem

Word and Outlook have to be same version.

Read other 1 answers
RELEVANCY SCORE 120.4

Hi all,
I'm attempting to create a mail merge in 2010 with multiple records merging into a table on one page. I've tried a couple of options:
Use the "Next Record" rule. This works in the first row, but the merge reads left to right so when it gets to the next row, it's screwed up. I can't find a way to tell it to read down the column and then move to the next record instead of reading across the row.
Merge to a directory. I can create a table with one column, but when I merge to the directory, it stacks the columns on top of each other. There will only be three records for each page, so even if I use a three column layout, there's enough room to stack the columns instead of showing them side by side. Also, since there's so much other data on the page, there's no good way to fit the merge to a directory information within it.

Anyone have any ideas? I'm attaching a sample document and the cells in yellow are the ones I need to merge. Thanks.
 

A:Solved: Mail Merge Nightmare (Word 2010)

Nevermind, I see what you are trying to do. I am not sure how you would approach this since it is not your typical mail merge.
 

Read other 3 answers
RELEVANCY SCORE 113.2

Hello,

I have a new issue that has come up since we converted an Access database to 2007 file format.
Here is the history.

We have an access database that was created in the old file format. In that database there is a button that opens up word and a mail merge file. Word's mail merge then uses a query from the access database to populate the mail merge document.

We recently converted the Access database to the Office 2007 file format and now the merge process will not work.
I have tried to relink the files and have done some research and it appears that the DDE way of connecting is no longer used in Office 2007. I did finally get to the point where I could see the queries i needed but once I try to open that data source Word give me a general error that it can not open the data source.

How can I get these merge files working again?

PS. We are running Windows XP if that is needed.

We are quickly moving to office 2010 also but that uses the same file format as 2007 so I assume it won't be an issue. Any help you can give me would be GREAT!.
 

Read other answers
RELEVANCY SCORE 112.8

I have a word document set up with fields that I want to create a mail merge from a Query. When I go through the steps to add my query as the source then click on edit recipients there are no recipients. I have tried the same steps with other queries that I have and it works. I'm not sure why the query I want to use isn't working. The query I have set up does have a lot of expressions. Here is an example IIf([fie dt] Between #8/1/2010# And #7/31/2011#,[fie dt]+1096,Null) I have tried to change the expression and it still doesn't work. Any ideas? Thanks!
 

A:mail merge issue with Word 2010 and Access 2010

Read other 10 answers
RELEVANCY SCORE 112.4

Hi I am just trying to learn how to mail merge with word 2010

I start Word then click on Mailings, then click on start mail merge, then click on envelopes, then select the size of envelope, then select recipients, and all works ok except the address block is almost at the bottom of the envelope no matter what setting I use.

I know I can grab this address block and move it anywhere.

But is there not a way to make the default position higher on the envelope please

Also I see using this method it prints the City County and post code on the same line

Is there a better way to select addresses and print without having to alter every ones position please

A:Mail merge with Word 2010

Have a look at these MS website to see if there is anything that helps you. In the second one which is applicable to Word 2007 there is a section on printing envelopes which may help you.

https://support.office.microsoft.com...rs=en-AU&ad=AU

https://support.office.microsoft.com...9-b462cc40c73a

Read other 5 answers
RELEVANCY SCORE 112.4

I am working in Microsoft Office Word 2010 on a 64 Bit Windows 7 OS. I am using Mail Merge. I am trying to make it so that if Field24 is not blank, that field will just populate. Otherwise, I need the system to look at the date the document is generated, i.e. today's date. If the date is 1/1 to 12/24, I need it to print "{ DATE \@ "yy" }-CH-". Otherwise (12/25 - 12/31), I need a prompt to pull up.

I have tried:
{ IF { MERGEFIELD Field24 } = "" "{IF {DATE \@ "MMdd" } < "1225" "{FILLIN "Case No.:" \o \d "13-CH" }" "{ MERGEFIELD Field24 }" }

And as a test:
{ IF { MERGEFIELD Field24 } = "" "{IF {DATE \@ "yyyyMMdd" } < "20121225" "{FILLIN "Case No.:" \o \d "13-CH" }" "{ MERGEFIELD Field24 }" }

I am having no issues if Field24 is populated. However, if Field24 is blank, nothing is pulling through with either of the above coding. Now, I am sure this is something I am doing, but there are several instances where what prints will be based on a date. Is it possible to do this, without delving into Macros (an area where I am completely clueless...)?
 

A:Word 2010 Mail Merge

Update:

I found a little more information here: http://www.gmayor.com/formatting_word_fields.htm
Below is what the site has to say on the matter. It seems to agree with what I've done. I even tried to change my DATE field to a regular MERGEFIELD populated with a date and that did not work either. I do not understand what I am doing wrong here.
Testing for events that occur before or after a certain date

When running a mail merge, you may want to test for events that happen before or after a certain date. Mail merge does not convert dates to numbers, so if you cannot automatically derive a date number from the date in the data file, as you could in (say) Excel, a different plan is called for.
Let's say the date comes into Word in the format d/MM/yyyy or 1/10/2002 (1st October 2002) from a MERGEFIELD called Start_Date. In this example, we are looking to identify records with Start_Date entries before 1st October 2002.

The above would appear the logical check, but the check treats the date as a number and identifies that number as 1, which is the first part of the number before the slash '/'. All dates other than the first of the month will be greater than 1, so all will produce the result "False".
We therefore need to display the date in numbers that represent the date in a unique way by using the date mask yyyyMMdd which displays the date as a series of digits for year month and finally day, without any breaks. This is a number that the condi... Read more

Read other 1 answers
RELEVANCY SCORE 111.6

I have Office 2010. I am trying to do a Mail Merge with 650 addresses on an envelope. All the fields merge fine except one. The field is Street Type (Dr, St, Ave, etc.). The field returns a value of time. 12:00:00 AM. The field settings on the excel spreadsheet are for Text.

There are no leading or trailing spaces in the field.

All other fields merge just fine and have the same settings.

Any advice?
 

A:Solved: Office 2010 Mail Merge Problem

Read other 8 answers
RELEVANCY SCORE 111.2

Running Windows 7 machine with Office 2010 Professional. Just discovered that from Word I can send out mass emails (I am the email blaster for our organization) that show up in email as JUST addressed to the recipient without using bcc. Word 2010 BOMBS 75-90% of the time when I click on MAILINGS, Start Mail Merge, Email messages. If I do happen to get past there, when I click on Select Recipients Word bombs, then reboots. Very frustrating since each message I send out must be sent 3 times to get all of our people (more than 50 messages at a time are forbidden by my ISP).

Obviously Word and Outlook are both 2010.

Any fixes or suggestions are GREATLY appreciated!
 

Read other answers
RELEVANCY SCORE 111.2

Microsoft no longer providing online forums for support (as far as I can tell), I'll ask here because I can't think of anywhere else.  I have a Win7 Pro 64 bit desktop running Office 2010 Professional.  Today I needed to do a mail merge, letters and envelopes, in Word 2010.  This was the first time I ever tried that.  My data was in an Excel 2010 spreadsheet.
 
The letters printed beautifully.  When I tried to print the envelopes, the first thing it gave me was a little printer configuration window.  In the window, I had to change the way the printer handles envelopes, because my elderly HP Photosmart C7280 printer doesn't handle them the way Word thinks envelopes should be handled.  Having changed that, I clicked on the OK and immediately got this error:

In order to apply the selected envelope options, Word must delete the current contents of "<filename>."  Any unsaved changes to this document will be lost.
I couldn't get away from that, so I clicked "OK" and my mail merge document vanished, leaving only headers and footers.  There was nothing to print envelopes from.  I could not make it work. Does anyone have a solution for this??  Has anyone ever seen it?
 

A:Word 2010 Mail merge issue

Mail merge in Word can be a bit fiddly and the details keep changing between versions but it generally works - eventually.
 
The only suggestion I can think of is, when you come to the 'create new document' bit in the merge, you go into 'File - Page set-up' and set the template envelope to match the printer's settings rather than leaving it until you press 'Merge' or 'Print'.
 
Chris Cosgrove

Read other 4 answers
RELEVANCY SCORE 111.2

I just upgraded to Microsoft Office 2010 and when I try to use mail merge for Christmas card labels, I get clear down to the final formating and get an error message that says "not enough memory." This is very discouraging because of all the time and effort to download the addresses from Outlook. What gives with Word 2010? It seems to crash a lot, produce many "not responding" messages, and many of the windows within Word are funky and hard to read.

A:Word 2010 Mail Merge not working

Welcome
Lets not overlook the obvious, it may indeed be memory.
Bring up task scheduler to determine how much memory you actually do have.
Press alt+cntrl+delete and then click on performance tab to check remaining memory.
Crashes can, also, be caused by memory.

Read other 16 answers
RELEVANCY SCORE 110

Hi,
When trying to import an excel list into mail merge.
I get the errror "document locked for editing" and I cant continue. Does anyone know what is happening. Im not using it elsewhere and it used to work!

Thanking you for you help

Mikee
 

A:Solved: Word Mail Merge Problem

did you tried to do it in safe mode and checked.
try saving the excel file with a different name and then try mail merge
 

Read other 2 answers
RELEVANCY SCORE 108.8

Hi all,

I have never had this problem before. I have an Excel file with a number of worksheets in it, all running a macro (thanks XLGuru) that prevents the entering of duplicate data in an area of each sheet (it is a seating chart for a number of days). Not too fancy. I have the print areas set and a correct worksheet is set first to have the data taken from.
BUT, when I try to run a mail merge to word in order to print tickets, I get the following message: "Word could not re-establish a DDE connection to Microsoft Excel to complete the task."
I have tried just copyng the data to another Word document and using that for the data info, and that worked fine, so...?
Help!

Thanks again, in advance (what a great site)!
 

A:Solved: Word 97/Excel 97 mail merge problem

Read other 7 answers
RELEVANCY SCORE 108.8

I have recently upgraded to Office 2010 (from 07) and I perform a lot a mail merges. I have come across a few issues with this feature within 2010 and wondered if anyone has a solution. I am obviously running Windows 7.

Issue 1 - When performing the mail merge to emails (HTML), Word 2010 doesn't seem to recognise my IMAP email account, which is set as default in Outlook 10 it uses one of my other pop email accounts.
Is there any way to set my IMAP account as the default for mail merging?

Issue 2 - Once I have completed the email merge I then need to create them as a PDF, which in 2007 worked fine but the Acrobat addin in Word 10 doesn't do anything. (I do have Acrobat 8 prof installed as well) I have done a little research and can see that this is a problem but I need a solution to fix.
Otherwise I'll be reduced to uninstalling and re-install 2007!

Anyone with solutions please let me know.
 

A:Email Mail Merge Issue - Word & Outlook 2010

Hi welcome to the forum,
Have you tried the macro to save As pdf file of print to the adobe pdf printer?
 

Read other 1 answers
RELEVANCY SCORE 103.2

Windows XP Professional Service Pack 1 with office 2002 plus Outlook 2003 installed, Exchange 2003 is being used as the e-mail server.

When I do a mail merge from Word 2002 to e-mail for a mass e-mailing in Outlook 2003. The process completes but there are no e-mails sent from Outlook 2003. The e-mails that were merged are never recieved by the recipents that are being set to. Help.
 

Read other answers
RELEVANCY SCORE 102.4

I would like to use Word 2007 Mail Merge to compose and send email messages. My email client is Windows Live Mail. I do not have Outlook. I do not need to access my WLM Contacts list. The email addresses I want to send messages to are in a column of the Word table that I am using as the Mail Merge data source. I have gone through all of the steps of a Mail Merge, including writing the email message, inserting data fields into it, and selecting recipients. The last step is to finish, merge, and send messages. I click on that step and nothing happens - no error message appears but no messages are sent. Any advice? It's possible this can't be done, but I am hoping it can.

--Jim--

Read other answers
RELEVANCY SCORE 102.4

Hi
I used Word 2007 for mail merge to send about 1000 mails to my prospects
After I click the Merge and Complete button, for every email it sends, outlook pops a warning
"Some program is trying to access to send email. If it is not ok, click deny and check your virus settings ..."

I am forced to click "Allow" for every mail, this is too much to take for the number of mails I am sending
Is there a way to disable this warning system when I am doing a mail merge

Kindly help

Thanks and regards
Sasi Sekar K
 

A:Word 2007 - Outlook Mail Merge Warning for every mail

Read other 6 answers
RELEVANCY SCORE 102.4

Hi All,

I am trying to do an e-mail merge from a database that is saved on my hard drive.

According to the help files in WORD 2000, I should be able to do this, similar to sending form letters, only e-mail instead.

I can get everything set up and working, right up to the Merge dialog box, but all I have to select for Merge To, is 'New Document,' or 'Printer.' According to the WORD 2000 help files, there should be an option called 'Electronic Mail.' There is not, and I don't know why. I am apparently missing something, but I can't figure it out.

Any help or ideas will be appreciated. Any thoughts as to what else I may run into--difficulty wise--would be appreciated also.

Thank you.

Clayton
 

A:WORD 2000, e-mail merge, missing 'Electronic Mail'

Read other 9 answers
RELEVANCY SCORE 101.6

I have email addresses stored for a Windows Mail Merge docx. and now want to use the email addresses for each entry.How can this email data be exported for use in Windows Live Mail as a Folder in my 'Contacts'?All assistance gratefully accepted in advance. Many thanks
Using OS: 64 bit MS7
 

A:Word Mail Merge emails to Live Mail

Read other 13 answers
RELEVANCY SCORE 101.6

Can anyone advise me if there are limits anywhere to the number of e-mails I can send out simultaneously when using a mail merge to e-mail? I have set up and tested the mail merge and it all works fine, but I don't want to launch the real one only to get problems. I have a mailing list with 1,600 addresses, I'm using Outlook and Word 2011 for Mac to do this.
 

A:Mail merge to e-mail using Word / Outlook 2011 for Mac

One of the problems your going to face is getting labeled as a spammer. If your sending these internally it may not be a problem. The standard answer for this is to Outsource this if your sending over 100. Good decision not to launch the real one yet.

A detailed response to similar question in StackOverFlow
 

Read other 3 answers
RELEVANCY SCORE 101.2

Have just upgraded to Microsoft 2010, where before I could email mail merges from Outlook and choose my sender email address I cant now. Email mail merges have to be created and sent in word but it is defaulting to my pop email address and will not let me choose my imap address? my Imap is set to be the default
 

A:Email Mail Merge 2010 Problem with IMAP

Do you have the IMAP account showing in Outlook?
 

Read other 3 answers
RELEVANCY SCORE 100.8

One of my colleagues at Work has discovered that following an upgrade from Word 97 to Word XP, the Data Source fields within Mail Merge no longer show the field's contents in full. Instead only half of the sentence is visible in the right hand pane. Then, when she selects the source to add it to the document, it is still only showing half of it. This did not used to happen with Word 97.

Question:

Is there a way of increasing a fields character length, so that the full intended sentence or data to be merged shows up after adding it to the document ? If so please advise on how this can be done.

Many Thanks

Anton
 

A:Mail Merge Problem In Word XP

See if this article will help you:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q292101
 

Read other 1 answers
RELEVANCY SCORE 100.8

Hi folks

I'm doing a merge.

The address block is fine and I;ve used the <<company>> filed in the body copy of the letter to and that works fine.

I want to use another filed called <<Page>>. When I preview the merge, the <<Page>> field shows 0 rather than the field content which is "lower than page 4".

The data is in Excel.

Can anyone help please?

Thanks
 

A:Word mail merge problem please

Read other 9 answers
RELEVANCY SCORE 99.6

Hi again guys. Not being a database specialist can anyone help with an Access/Word problem?

I have a database application which performs a query and outputs the result to Word for mail merging. The query works perfectly and gets the results I would expect. Word opens correctly on request from Access. The Word merge document is a simple test case so should have no faults in it. The data is passed across as a .txt file and can be seen saved where it should be, and correctly formatted by simple inspection in Notepad. However Word cannot recognise this .txt file as its database for the merge procedure and point blank refuses to let me merge. The .txt file has its first line as the data fieldnames and then has tab delimited fields and "End of Line" delimited records after.

It seems to me as if the problem is within Word rather than Access but I am no expert. Is there some simple Word option I have set incorrectly, or is it something within Access after all?

Any suggestions appreciated.
 

A:Word/Access mail merge problem

What version of office are you using first of all?

Also, there are two ways to merge access/Word. One way is from Word and one way is from access. I'm assuming from your description that you are merging from Access.

This is where you kind of lost me. I've done thousands both ways, but I've never seen anything about the data saved as text fields.

You might try starting over. If you are merging from Access:
Open the query you want to use.
On the toolbar choose Tools, office links, then merge with word.
A dialogue box will pop up and ask you if it new or existing document. Choose the correct one.
When the document opens, it will prompt you for more responses. However, at this point the mail merge options and appearances are different on different versions of office.
Good luck!!!
 

Read other 3 answers
RELEVANCY SCORE 99.6

We have Word 2002 and excel 2002 applications we are trying to merge an excel file to Word and we are having problems getting getting the format correct. we have 4 decimal places on excel file, when we merge it to word it changes the format and puts a lot of zeroes on the file.
I also got this window message when we open the word file "Opening this Doc will run the following SQL on Select * From 'Sheet1$' Data from your...Base wil be placed in the Document. Do you wan to continue?"
We always click yes.
I looked at MS KB online the only thing I see is 97,98 older versions of Word and Excel. Has anybody experienced this problem already?
Please help. Thank you
 

A:Word-Excel Mail merge problem

Read other 8 answers
RELEVANCY SCORE 99.6

Can anyone tell me why I am getting the below message when I try to access my Outlook contacts while selecting recipients using Mail Merge in Word 2007?

Unable to obtain list of tables from the data source.

I could do this no problem from Office 2003. A couple of users here can do it in 2007 and a few of us can't. Must be a setting of some sort but I can't find it.

Thank you!
 

A:Word 2007 Mail Merge problem

Read other 6 answers
RELEVANCY SCORE 99.6

Hi

We have just moved from Word 2003 to Word 2007 and I am having a slight problem with mail merge. Whereas with 2003 when selecting the source data (Excel 2003) I was able to bring it in as DDE, now the only option I have when bring in the data (Excel 2007) is to select OLE Database file. Whilst this does work, the merged fields especially currency amounts, do not retain their formatting, but when I used to bring them in as DDE they did. I know I can go in and amend the field codes to put it back, but I would rather not have to.

Is there some setting somewhere I need to change to get the DDE option back?

Thanks for your help

Peter
UK
 

A:Word 2007 - Mail Merge Problem

Read other 6 answers
RELEVANCY SCORE 99.6

I am trying to pull a mail merge off between Excel and Word. When I pull Interest Rates off of my excel sheet into word, instead of coming out as "5.00%" they come out "5.0000000000000003E-2)" instead. And then another interest rate "17.00%" gets pulled like "0.17000000000000001." Its really weird. Also my dollar values lose the dollar sign during the merge. Am I doing something wrong? I have setup mail merges before its just these arent working. Any help would be huge!
 

A:Problem with Excel-Word Mail Merge

Read other 6 answers
RELEVANCY SCORE 99.6

I have an access database that I use a word mail merge with. In the database I have several yes/no combo fields. In the mail merged document the fields show up as either '0' or '-1' based on the yes/no value. I need to change this to a yes/no answer in the document. In access I'd just set up a check using vba but I've never used any vba in word and I'm not sure how to error check the data in a merged document like this.

Any ideas?
Thanks
 

A:mail merge with access and word problem

Read other 7 answers
RELEVANCY SCORE 99.6

I set up a mail merge document in Word 2000 and then merge the results to a new document, then save the new document. I can open this new document fine. But, if I move the document to a different computer it won't open and crashes Word. Don't know why it does this as it shouldn't still be linked to the source mail merge database. It's just a completed mail-merged document.

Any ideas on this one? The only way it works is if the two computers are networked together, then it opens fine on the second computer, which suggests that it's looking for something on the orginal computer which it needs before opening the document on the second computer.

This has me baffled. Weird and frustrating.

If anyone would like a sample document I could attach one.

Thanks
 

Read other answers
RELEVANCY SCORE 99.6

Maybe the Office 2002 gurus out there can direct me to a solution to this pesky problem...
When I try a mail merge to make mailing labels with Word 2002, I always use my Outlook contacts for the data.

However, Word always gives me an error message that says that Outlook is not configured as the defualt mail client. It instructs me to make the changes in Outlook and to try again.

I've been in Outlooks Tools menu, as the help files tell me, and have checked the settings, and made sure the box is checked to configure Outlook as the defualt email program, but Word behaves the same.

Any suggestion?

Thanks,
Ken C.
Chino Hills, CA
 

A:Problem getting Word to use Outlook for Mail Merge

Try this, go to contol panel, click on internet options and on the program tab set Outlook as the default email program.
 

Read other 2 answers
RELEVANCY SCORE 99.6

I'm attempting to use the mail merge wizard to merge envelopes using and Excel file. Everything works fine until I come to an envelope that goes outside the US. I have a field set up for Country and when I go through the Match Fields box under Optional Information, that field is selected. However, it never prints the country. The country does add a sixth line to the address. Is this the problem and, if so, is there any way to get it to recognize more than five lines in an address?

Another problem that is not major but bothersome. I have over 300 names on the Excel list but am printing envelopes only for the first 190. Is there any way other than selecting Clear All and going in and selecting each envelope ONE BY ONE to get it to print only the first portion of the list?

Any help greatly appreciated.
 

Read other answers
RELEVANCY SCORE 99.2

Hi All,

I have a Word document that pulls data from an Excel spreadsheet...everything was working fine in Word 2003, but we have changed the system and it has Office 2007 on it and the problem that I am getting is this box that pops up as soon as I open the Word document...

*****************************************************************

Microsoft Word

Opening this document will run the following SQL command....

Data from your database will be placed in the document. Do you want to continue?
*****************************************************************

I click "Yes", but that warning keeps popping up everytime I open the document? is there a setting in 2007 that I can set so it doesn't prompt me all the time? I have added the location of the documents in the "trusted zone", but not sure where else to look?

thanks!
 

A:Solved: Word 2007 and mail merge..

The reasons for the warning and the workaround to disable it (which is a security risk) are here:
http://support.microsoft.com/kb/825765
 

Read other 3 answers
RELEVANCY SCORE 99.2

I have an excel spreadsheet with names in one column and street and city address in another. I want to make a simple mail merge so I can make labels but I can not figure it out. Any ideas? I am using the mail merge wizard, but when I merge it is all blank.
 

A:Solved: Word and Excel Mail Merge

You merely have to name the Excel spreadsheet as the source of the data for the mailmerge (I think it is about the 3rd step) where you can select browse to use an existing list (MS calls it a database on this step, even though a spreadsheet isn't really a database).
Have you done all that?
Also, you might want to consider splitting the street and city into two separate columns, just to make it a bit more flexible in arranging your data.
 

Read other 2 answers
RELEVANCY SCORE 98.8

When I create a mail merge to merge number into a letter, the numbers show up with 14 decimal places. I am not trying to input money or any other number format into my letter, just simple two digit number. The number should look like 4.16., but looks like this: 4.1699999999999999.

I've tried changing the format in Excel, but no luck.

Any suggestions?
 

Read other answers
RELEVANCY SCORE 98.8

I have done mail merges for years, but for some reason, the word merge document can not find any excel data folders.

I have a fairly new Dell laptop running windows 7. My Excel program seems to run OK and Word seems to run OK as well.

After I browse for the data file and select it, I get "OLE DB Database Files". I hit "OK" and then I get another box that says

"Word was unable to open the data source".

What am I doing wrong?
 

A:2007 word-excel mail merge problem

The Word document you're using is that based on a previous word version?
There may be a problem with the docuemnt reference files or something like that since it uses a kind of ODBC link to read the data and probably cannot find the expected reference and throws the error.
I don't know the solution to this but it's meant as a tip to try and point you in the right direction.
Office versiosn are nat all the dwonward compatible as they like us to think
 

Read other 3 answers
RELEVANCY SCORE 98

Using the wizard in Word 2002 I have created a mail merge document, by default it seems to have created the data source as an Access format file. I now want to go back and add some more names to the data file but can't seem to do so. Word will only let me select or exclude names for the merge list but not add, I don't have Access installed so can't edit it directly.

Can anybody tell me how I can add names, surely I don't have to construct a completly new file ?

Ian
 

A:Solved: Word - mail merge data source

Found it ! If anybody is interested you have to open the merge list, select an entry and click on EDIT, this opens the entry form where you can select a 'NEW ENTRY' typical Microsoft to hide it away !
 

Read other 1 answers
RELEVANCY SCORE 98

Is it possible to create an e mail merge? It would be so helpful, but I haven't yet figured out how to do it.

Thanks
 

A:{SOLVED} Word: Mail Merge to Email Address

Read other 9 answers
RELEVANCY SCORE 98

I would like to create a mailmerge document with "consecutive" data (ie: first name, last name, gift amount) that I want to keep in the SAME page from one record to the next until I get to the real bottom of the page. I cannot find a way to make the merged document NOT put a page break between each record (word 2007). Where can I find such a command?

Also when I tab between each field, the fields line up for the FIRST record, but then they are out of wack for subsequent records. How can I assure that the data in the records will line up throughout the whole merged document? ie:
first name1 last name1 amount1
first name2 last name2 amount2
first name3 last name3 amount3
etc, etc., etc.

Thanks for any help you can provide.
 

A:Solved: word mail merge page break

I've used the merge feature quite often in the past, using the Mail Merge wizard, which is still included in Word 2007. But I've never had occasion to do the type of merge you are wanting. But I have heard (in which forum I don't remember) that there is such a thing as a "directory" merge in Word, which prints a continuous listing of the data fields, laid out as you specified them in your post.

For my own curiosity, I just tried using Word 2007's Help feature to find information on a directory merge; sadly, it seems to be lacking, or missing entirely, from what I can see. But I just tried this, and it seems to work: Start the merge wizard, and when it asks you what type of document you are working on, choose Directory. This will allow you to choose to specify which fields, one by one, you want on each line of your printed listing. To take care of the column alignment problem, I would suggest that you create a one-row table (with or without borders, and with or without any before/after spacing you want) to hold the fields you want on each record of your listing. When I chose to complete the merge, using one of my own data files, Word produced a continous listing, one line for each record in my data file, filling each page until all data records were printed. Of course, you can specify which records you want included, if you don't want all of them, during the merge process.

Hope this will help.
 

Read other 3 answers
RELEVANCY SCORE 98

Hope you can help.
Our office has recently upgraded to MS Office XP. We can't install SP3 for Office XP - it breaks our other apps.
We have about 200 or so form letters we use to send to clients using many "If" statements to send them the information they need. We will also use "includetext" strings to another Word document to bring in that information.
Sometimes, in that "external" document, there is an "if" statement that references to one of the mergefields (ie FirstName, LastName), on which we also put formatting switches ( \* Caps).
What we are finding is that in the main document, when the includetext brings over the name, it's in all UPPER case, just the way it is brought over from our database.
The flow of what it is doing may look like this:
main document w/includetext > external document > "if" statement with mergefield \*Caps.
Word is not completing all the commands we have given it by not putting the name in First Initial in Caps with the rest lower case.
Have any of you heard of this? If so, does anybody know a solution?
Thanks.
Stacy
 

A:Solved: MS Word XP Mail merge switches & includetext

I just thought I'd give you the solution I found out of the blue.
Instead of using \*Caps,
use \* lower \*FirstCap
Both of them apparently need to be used
Thank you to anybody who may have read this post.
 

Read other 2 answers
RELEVANCY SCORE 97.6

I'm trying to print out a christmas card list using mail merge in Word. I've entered the names and addresses and the list is fine but when I try to print the addresses on the envelopes, they don't align properly on the envelopes.
I've tried different size envelopes from the list provided by Word but the only two that print properly are the size 6 3/4 and the size 9.
Unfortunately, I cannot find christmas cards that size. I also tried the custom option on the envelope list to size an envelope but that doesn't work either.
On the menu, I've tried manually adjusting the position of the address block instead of using the auto choice but that doesn't work either.
I use an H P C 4700 series printer and I am inserting the envelope properly (along the left side of the paper feed)
I've also downloaded lotus symphony and open office in the hope that the printing would work in their wps but there was a file recognition problem.
I have used Word 2002 and the Microsoft Word Starter 2010 and my printer works fine.
As far as I can see, there isn't an option that I've missed but I could be wrong.
Can someone help?
Thank you,
John Tysz

A:Problem printing envelope addresses in Word Mail Merge

Hi John.

I know this doesn't answer your problem directly, but I just use address labels, which means it makes absolutely no difference which Xmas cards I use.

Read other 3 answers
RELEVANCY SCORE 97.6

There is a problem with Lotus Notes and Word 2007.
Mail merge is not working with Word 2007 and Lotus Notes 8.5.
It is working well in Windows 7, but it is not working in Windows 7.
It says that you don?t have mail program installed, although Lotus Notes is a default mail client.
Do you know how to fix this problem.
Thanks in advance.
 

Read other answers
RELEVANCY SCORE 97.6

I've used Word's mail merge feature for many years to update phone lists, address lists, mailing labels, etc. from an excel spreadsheet that has all of the contact information for my department. Since upgrading to Word 2003, I'm consistently experiencing this problem: Every time I open an existing mail merge document in Word 2003, I get these two messages:

"Opening this document will run the following SQL command ..." and then it references the filters that I have set up in Word for the mail merge.

It then says "data from your database will be placed in the document, do you want to continue?" If I reply No, it opens the mail merge document, but does not link to the excel spreadsheet - which is what you would expect it to do.

But when I reply Yes (which is the correct answer) it takes me to the screen where it asks me to "select data source" (which in effect is the same as replying No)

Prior to upgrading to Word 2003 (SP2 on XP platform), Word would remember where the Excel file was located. Is there a workaround to eliminate this extra step? I use these files on a regular basis, the excel file name never changes nor does its location change. I don't understand what is prompting Word to ask me to find the excel file each time I open the Word merge document.

Can anyone help me figure this one out?

Thanks in advance,
Sharon
 

A:Mail merge problem - Word consistently cannot find file

Read other 7 answers
RELEVANCY SCORE 97.6

I am using Windows XP, Excel and Word. My address list is in Excel. I start out in Word, selecting the mail merge option and go through the sequence to mail merge labels, when I select PREVIEW the labels, they are completely blank. At the step that shows the labels in which I select which names are going to be used, everything seems normal. But the next step of PREVIEW reveals that the labels are blank. My excel list is in the same format of every other list I have every used to print labels, ie it has Last Name, First Name, Street number, Street name, City, State, Zip. All on one line. I don't know what is wrong. Help!
 

A:Mail Merge problem with labels Excel to Word in Windows XP

In step 4 of 6, "Arrange your labels," you should be able to type an X (or any other character for that matter) in the first label, click the "Update all labels" button, then see the X in each label at step 5 of 6, "Preview your labels." If you can't do that, then perhaps something in Word 2003 is broken. Visit this site for instructions on how to do a repair:
http://support.microsoft.com/kb/821593
 

Read other 3 answers
RELEVANCY SCORE 97.6

Hi,

There is a problem with Lotus Notes and Word 2007.

Mail merge is not working with Word 2007 and Lotus Notes 8.5.

It is working well in Windows XP, but it is not working in Windows 7.

It says that you don?t have mail program installed, although Lotus Notes is a default mail client.

Do you know how to fix this problem.

Thanks in advance.

A:Lotus Notes and Word 2007 mail merge problem

Wow it's been a while since I've used Lotus Notes. Under default programs, does it show Lotus Notes as the default mail program? Is there a setting in Lotus Notes itself you might check to see if it can set itself as default?

Read other 5 answers
RELEVANCY SCORE 97.6

Hi all,

I am trying to send multiple emails to different people with slightly different links to a survey page, so I can monitor who takes the survey (e.g. http://forums.techguy.org&c=90001, http://forums.techguy.org&c=90002....)
I have no trouble setting up Word to do a mail merge using an Excel file as the data source, and in the Excel file the links are all different and they are live.
However, when an email shows up on my pc, the link is dead - can't click on it to go to the survey, only can cut and paste into the browser, which I don't want to have happen to the client's customers.

(Edit) Note: I installed Microsoft's FixIt
http://support.microsoft.com/kb/823301
and continue to have the problem.
Any ideas? Thanks in advance!
 

A:Word mail-merge email inserted link problem

Read other 12 answers
RELEVANCY SCORE 96.8

I've been trying for an hour to make labels to print out and stick on envelopes. I tried to use Mail Merge in Word 2000 for the very first time, but I'm doing something wrong. I really don't understand how it works. I've got a normal Word document with addresses, one address underneath the other with an empty line separating them. When I try to create the labels, a box pops up saying something about a field delimiter and record delimiter. Can anyone help me and tell me how to create my labels properly? Thank you in advance for your time.
 

A:Solved: Creating labels with mail merge in MS Word 2000:help, I don't get it!

Read other 16 answers