Over 1 million tech questions and answers.

Solved: Mail Merge problem

Q: Solved: Mail Merge problem

The data file contains two columns labelled as Day and date respectively.

The Date column contains sequential dates in the format " 26th September 2008".
The main word document contains the <<Day>> and <<Date>> mergefields.

However when the word document is merged with data file the date is displayed as 26/09/2008 and not as 26th September 2008.

The day is displayed correctly.

How do I rectify this problem ?

RELEVANCY SCORE 200
Preferred Solution: Solved: 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: Mail Merge problem

Read other 6 answers
RELEVANCY SCORE 74.8

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.
 

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

Word and Outlook have to be same version.
 

Read other 1 answers
RELEVANCY SCORE 71.6

I have an excel spreadsheet with about 156 addresses, I am using word to try and merge them into labels so they will print. I am able to merge but it only takes 30 of them and prints them, somehow I am missing the other 120 or so. What am I doing wrong and why is it only printing one page?
 

A:Solved: Mail Merge Problem

Read other 8 answers
RELEVANCY SCORE 70.8

This is the first time I've tried to use the mail merge function in Office XP (I have been using Office 2000). I got the letter and envelope to both work, finally. However, whenever I try to merge an Excel list to make labels, it insists on printing only ONE label per page, not the 30 that are actually on the page. I'm using Avery 5160 labels, 3 across, 10 down. The proper template comes up when I choose the label. I insert the address block in the first label. <<Next Record>> automatically appears in all other labels on the page. When I click on Preview your labels, an address appears only in the first box. When I click backward for forward on the preview button, all of the names appear--but only in the first box. I did try to print thinking that, when printed, they would appear as 30 different labels on each page. But it prints out only ONE label per page. Quite a problem when I have almost 600 labels to print. PLEASE HELP!! I HAVE TO PRINT THESE 600 LABELS BY WEDNESDAY EVENING!
 

A:[SOLVED] Office XP Mail Merge Problem

Read other 7 answers
RELEVANCY SCORE 70.8

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 70.8

i have created a mail merge, ready to finish and print, when i choose print, a ms office box comes up that i can type text in then when i click ok, it comes up again, the docs print, after i click ok on each box, i can't do that for all the merge because some of then are 300 pages! so frustrating, tried troubleshooting for hours with no luck, seems to be with the printing, the merge seems fine and has no errors, data source is a simple spreadsheet into the word doc...
 

A:Solved: mail merge printing problem

Read other 6 answers
RELEVANCY SCORE 70

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 70

My Excel document of addresses includes a column labeled “Zip” which contains some zip codes with leading zeros.

My Word document includes a merge field titled “Zip” in the appropriate location in the address block.

The problem is with these leading zeros. I’ve tried both including and omitting an apostrophe before the zero in the Excel document; neither gives the desired result. One way gives just a zero and the other gives the Zip Code without the leading zero.

Could you please let me know what I should do differently to make this work? Your help is very much appreciated! Thanks!

Working in Window XP, Word 2002 and Excel 2002
 

A:Solved: Problem with retaining leading zero in mail merge.

Read other 12 answers
RELEVANCY SCORE 70

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 69.2

hello,
we are running office 2003. when doing a mail merge in outlook from our contacts list
word is inserting a blank line into some of the contacts between the address line and the city line.
eg:
name
address line 1
address line2

city
county
postcode

has anyone else come across this annoying glitch and have any ideas how to fix it???
if you can your a star!
thanks
Iain
 

A:Solved: Microsoft Outlook 2003 mail merge problem please help!!

Read other 7 answers
RELEVANCY SCORE 69.2

Using Excel 2003, I have names and addresses and some other information across 5 different workbooks. I'd like to be able merge these tables into a single table, preserving unique records and avoiding duplicate records. The format varies across the workbooks, but we can make it the same if needed. Tools/"compare and merge workbooks" is currently grayed out. Can you tell us how to do this?
 

A:Solved: help with excel merge (not mail merge)

Read other 9 answers
RELEVANCY SCORE 66.4

I have created a form in word that has several pages within it. It is mainly all text that will be filled into the form and a few that will be filled in with amounts. There are blanks in the form for date, name, address, etc... that are in several places throughout the document.

I am wanting to merge some of the text fields so that when they type the date in one it puts it in all the other date fields as well. I have searched all over the internet and Microsoft site but still can't find anything merging just the text fields. Does anyone know if this can be done?

I attached one of the smaller forms for an example...I need all fill-in boxes that have the same name to merge. Some words are missing due to taking out business info, etc...
 

A:Solved: Merge without Mail Merge?

After searching all over this forum I finally found my answer in another post! The person was asking the same question as me but had worded differently.

The post was How do I make a form repeat in Word? started by mperilloux on 10/28/2007.

The answer that was posted to that thread by Administrator Anne Troy on 10/29/2007 contained this link

http://www.officearticles.com/word/create_a_reference_to_a_bookmark_in_microsoft_word.htm

It was exactly what I needed...Thank You Anne!
 

Read other 1 answers
RELEVANCY SCORE 61.6

Suddenly my computer (and everyone elses) is unable to mail merge an excel document into word. I'm using windows 98 but other operating systems are having problems too. It just says - word was unable to open the data source.

I have tried saving as something else and on other drives (it is currently on a shared drive) but to no avail.

Any ideas greatly received

Thanks
 

A:mail merge problem

Does this only happen with one specific Excel file? Could be that the file is corrupt. If possible, try opening the file and copying and pasting the data into a new Excel document (rather than using the save as function). Let us know if that doesn't help.
 

Read other 3 answers
RELEVANCY SCORE 61.6

Hi-
I'm trying to print envelopes using mail merge. The addresses merge correctly on screen, but on "Print Preview" the pages are blank and in the bottom corner says "Page 0". Any suggestions?
Thanks!

Read other answers
RELEVANCY SCORE 61.6

I did a search in the forums, but didn't see the same problem we're having

We're running Windows XP, Word and Excel 2003. We set up a mail merge with information from Excel, about 1300 addresses, to print mailing labels, Avery 5160/8160. When we printed it out, though, the first page prints fine. Then, the second page prints, but only the first column changes.

Thank you in advance for any help!
 

A:Mail Merge Problem

By the first column, do you mean the name - and that the addresses are remaining the same?
 

Read other 2 answers
RELEVANCY SCORE 60.8

Hello

I am having dome issues printing labels using mail merge.

Everything is fine exept when i try to print it, it does not print inside the labels. Some addresses are inside and some are outside the lables. Who can help me please.

Thank you

A:Mail merge rinting problem

hello

Can someone help please

Read other 1 answers
RELEVANCY SCORE 60.8

I am having a problem creating labels using mail merge in Word Xp . I am using the wizard and have about 120 or so contacts that I want to make mailing labels for but after I click Update I only get the first page of 60 labels.

 

A:Having a problem with WordXp mail merge

Read other 6 answers
RELEVANCY SCORE 60.8

Hi

I have this problem using mail merge. We cant fix it at all.

We are using office 2007. We have a huge list that we created in excell. Now when we merge that list in word the are box shapes in the address. Either in the address between the words or after the last word in that row. How the hell do you get rid of this. No one else has this problem i have searched high and low on google and other search engines and no one has put an article up on it. CAN ANYONE HELP ME!!!!
 

A:Mail Merge in 2007 problem

Read other 11 answers
RELEVANCY SCORE 60.8

I have a problem with mail merge and an Access database. I did not set up any of this so I don't know too much details or where to start. The user just told me that she would just open the Word document and a pop up window would show up, she'd update some data and then the mail merge would be created with the entries she updated. These files were stored in a network drive and were moved from one server to another. Since then, the Word document tries to open the Access database using the old network path, this of course doesn't work, so it prompts for a location. Once the location is given I am presented with a list of tables, no matter which one I pick, the pop up window from Access never shows and a mail merge with just the names of the fields repeated many times is created.

How can I fix this problem? I am not an Access expert so I would like to leave the database untouched as much as possible.

Thanks in advance for any help.
 

A:Access and mail merge problem

Read other 12 answers
RELEVANCY SCORE 60.8

Hello all, I'm having a problem using mail merge with Outlook. We usually send out a mass email once or twice a month, and have had no problems with it, up until a few days ago. The problem being that the option to mail merge has just disappeared from the tools tab, nor am I able to find it in the customize tab either. I'm fairly useless with outlook as it is, and am even worse when stuff goes wrong in short, help!

Read other answers
RELEVANCY SCORE 60.8

Hello,
Word Mail Merge function does not work. Word sends merged mails to Outlook (Connected to Microsoft Exchange) but outlook refuses to send them.

Hello M.F.Tolga Soyal,

To continue sending messages, please sign in and validate your Outlook.com account.

This helps us stop automated programs from sending junk email.

Thanks for your help and patience!

The Outlook.com Team


Although I had completes account validation nothing has changed.

I'm just trying to send app. 50 mails to my colleagues.

Thank youç

Read other answers
RELEVANCY SCORE 60.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 60.8

I am using Windows XP and Office 97 to mail merge. Data is stored in excel, converted to word for merge. When I go to print address labels (dot matrix sheets, printing roughly 30,000 at a time) it will print 12 labels, skip two, and continue printing. No data is lost, and the monitor shows data as complete. I did not have this problem with Windows 98 and Office 97, and have used Office 2000 with XP and still have the problem, so I assume it is an XP verses Office problem. How can I correct it?
 

A:XP mail merge printing problem

Brents,

Just a long shot, it you dot matrix set to continuous paper or single sheet?
 

Read other 2 answers
RELEVANCY SCORE 60.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 60.8

I solved my problem mail merge.
 

A:{solved Mail Merge}

Thanks for letting us know. In the future, please hit the 'Reply to Post' button at the bottom of your original question instead of starting a new thread. Closing duplicate... Original: http://www.helponthe.net/tsgbb/Forum11/HTML/000896.html
 

Read other 1 answers
RELEVANCY SCORE 60.8

I'm using 2003 word and 2003 excell. Theproblem is this. I have a file with 1629 names and addresses in it. In excell I am merging them into word and making mailing labels. I have done this in the past and it has worked fine. The only difference was the file was smaller. What is happening now is the file seems to merge the way it is supposed too accept when I review or print the file after the merge there seems to be random names and adresses missing from the file. I have tried this file on two different computers and the results are the same. Its alway the same names and addresses missing it cuts the file down to about 1350 names and addresses. Could someone please help me out? I'm at a total loss. Thanks

i'm useing windows xp pro.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: AMD Athlon(tm) II X2 250 Processor, x86 Family 16 Model 6 Stepping 2
Processor Count: 2
RAM: 2814 Mb
Graphics Card: NVIDIA GeForce 210, 1024 Mb
Hard Drives: C: Total - 95487 MB, Free - 19024 MB; D: Total - 97362 MB, Free - 81531 MB; E: Total - 94444 MB, Free - 73915 MB; F: Total - 94256 MB, Free - 68462 MB; I: Total - 953835 MB, Free - 953006 MB;
Motherboard: Gigabyte Technology Co., Ltd., GA-MA785GM-US2H
Antivirus: AVG Anti-Virus Free Edition 2012, Updated: Yes, On-Demand Scanner: Enabled
 

A:Solved: Mail Merge

Read other 6 answers
RELEVANCY SCORE 60.8

Hello all,
I have been put in charge of a task that involves a mail merge using 5160 labels. Where I have no problem doing the mail merge, I can't figure out how to get the whole thing done to make the lables. The mailing info is coming from and Excel file and there are over 450 entries. If I just do the mail merge I can only get a maximum of 30 names done.

In order to get more I have to select another 30 names and redo the merge every time. I did this with a smaller database of about 120 names or so. I had to do the merge 5 seperate times to get every one of them done, which I quickly copy/past into a single document so they could all be printed at the same time.

The computer I have is loaded with Windows XP 2002 Home edition and I have Office Professional. I also tried it at work (WinXP 03 Pro and Off Pro). I can't seem to figure it out, any help is appreciated. There has to be a better way to do this than 30 at a time.....

Hep me y'all.......
 

A:Solved: Need a little help with mail merge....

Read other 11 answers
RELEVANCY SCORE 60.8

Re-named a mail merge list of names & addresses, document was removed from "disk", now in My Documents as .wpd. How do I get all the info back to disk .dat?
 

A:Solved: Mail Merge

Read other 6 answers
RELEVANCY SCORE 60.4

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 60.4

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 60.4

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 60.4

I am trying to create mail merge address labels sheet containing 22 names and addresses in Word from an Excel spreadsheet. I get through the wizard OK, but in the end it only prints the first name and address out of a total of 22. I used the same spreadsheet to mail merge the same names and addresses onto a prepared letter in Word and that worked just fine for all 22. Please help save my sanity!
 

A:Mail Merge - Office 2007 problem.

Read other 7 answers
RELEVANCY SCORE 60.4

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 60.4

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 60.4

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 60.4

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 60.4

When trying to print a mail merge project that was just finished (250 letters with a client logo and company name at top) the following occurs:

1- (Printer #1) 1st page (test copy) prints fine, but the second, third . . . have white blocks on the black logo and company name.

2- (Printer #2) The same thing

3- (Printer #3) No white blocks (Yeah) but now there appears to be a border around the bottom and rights side of the logo/company name.

Printer 1=HP 4 Plus, Printer 2=HP 4si, Printer 3=HP LJ4500

Any ideas/assitance would be greatly appreciated.
 

A:Word97 mail merge printing problem

Read other 7 answers
RELEVANCY SCORE 60.4

Hi all:

We're having a problem with mail merge when importing information from Excel.

The error is as follows:

This task is taking longer than expected.
Do you want to continue waiting?
followed by:
Word could not re-establish a DDE connection to Microsoft Excel to complete the current task.

We have read the Microsoft help information and tried all that was recommended. (no check mark in 'ignore other applications' and the semi colon replacement issue). We also ran a repair on MS Office (v.2000).

Any suggestions would be greatly appreciated.

Thanks in advance.
Max
 

A:Mail Merge problem when importing from Excel

The ONLY thing I can think is to clean up the hard drive.
http://www.officearticles.com/misc/how_to_clean_up_your_hard_drive.htm

Then try again.
Otherwise, I'd have to see the doc and the xls files.
 

Read other 2 answers
RELEVANCY SCORE 60.4

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 60.4

I've run a search on this problem but nothing came up - hopefully someone can give me a hand.

The problem comes when I try to produce a mail merge from data in Access. I've got a query based on a table with a number of dates in it. In the table, I've formatted the dates as the long setting e.g. 9th December 2004.

Once I run a mail merge on the query, the dates come out in Word in the short form. However, they don't even follow the short date that's set in my regional settings (for English dates) instead coming out as the American version e.g. 12/9/04

I tried right-clicking on the merge field and selecting Edit field, but this only enables me to change the case of the field - as if Word is seeing it as a text-only field.

Is it possible to change a setting so the date will merge into Word in the format I specified in Access? I'm running Office 2003.

Thanks for any help
 

A:Access mail merge formatting problem

Doh! Don't worry, ignore this - it's sorted now. I did a bit more digging around and found out that what I didn't know was you can change the merge codes.

For anyone with a similar question, what I did was press Alt + F9 to display the merge codes, then add \@"dd MMMM yyyy" to the end of the merge code. This changes the format.
 

Read other 2 answers
RELEVANCY SCORE 60.4

Word 2000
Mail Merge
Table Calculation
Formula for the sum cell: =G3-H3
Number format for the sum cell: $0.00;($0.00);

I am attempting to find the sum of two cells and display that result in another cell. The data comes from the data source in a mail merge. I will populate G3 and H3 with data from the data source. But the cell I3 will have the result from the next record. So record 2 result sum will show in record 1, record 3 result sum will show in record 2, etc. I would appreciate ANY help. Thank you.
 

Read other answers
RELEVANCY SCORE 60.4

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 60.4

I have a need to Automate basically everything in regards to a Mailmerge.
I have successfully created a Main Document and even a datasource to grab the data from. I've done this several different ways. ( utilizing both the current wizard & adding the MailMergeHelper to my toolbar ).

The problems lie in trying to get this to work via macros.

If I try and load the main merge document, and then use a macro to 'Get The Data Source", it doesn't load properly. I get M, &M_1 as the only records.
I created the Macro by hitting RecordMacros and having the VBA record my steps. Obviously something is missing. Is there another command I need to add ?

If i allow the document to load the data upon startup
i get macros disabled... Any idea why that could be happening.

This should not be this difficult.

Any help is greatly appreciated.

Mindy Jeanne
 

A:Mail Merge 2003 - Macro Problem

Make the mail merge main doc and have it set up with the data source already. Save it as a document.

Record a macro that opens the file and creates the mail merge to a new document, and print it.

That macro code will, by default, appear in your normal.dot file. Hit Alt+F11, double-click "New Macros" under normal.dot Take everything out of the code after Sub Yourmacroname() and before End Sub. Delete the two remaining lines.

Double-click THISDocument under YOUR document on the left of the screen. Hit the General dropdown and choose Document. Make the other dropdown say Open. So you should now have the title and End Sub of a macro that runs when the document is open. Paste the code between the sub and end sub lines.

Save.
Close.
Open!

Oh, and set macro security to low. Many would say they don't recommend that, but the truth is, there are no WORD macro viruses running around anymore--people are having too much fun with email viruses to mess with Word anymore.
 

Read other 1 answers
RELEVANCY SCORE 60.4

Problem summary:
I'm creating a mail merge document in Word 97. I'm wanting to merge with data in an Excel 97 file. When I click on the Get Data part of the Mail Merge Helper, I keep getting the message:

'Word could not re-establish a DDE connection to Microsoft Excel to complete the current task.'

Any clues as to the possible cause??

Problem background:
1. I never usually have any problems with mail merging to Excel.
2. I am able to merge the Word document to data if the data is in a Word table (but this is inconvenient).
3. I am able to merge the Word document to data in some Excel files but not others.
4. Note that I haven't even got to the stage of entering merge fields in some cases before I get the message.

Any assistance gratefully received.

Regards,

spinningjennie
 

A:Mail merge problem:DDE connection to Excel

http://www.it-faq.pl/data/misc1/EN-US/196/952.htm
 

Read other 1 answers
RELEVANCY SCORE 60.4

Hey everyone long time no hear! Well here is my situation. In our main computer system we can run a report to print labels. Well the problem is that I don't send documents to everyone so I have to select. I have an option of exporting to Excel and selecting my recipients. Well when I select labels and export to Excel its putting the entire mailing address in one cell. Along with that its created blank columns and rows. So this isn't going to work to do a mail merge. They also give an option to put in an XML format. The problem with that is I don't know what an XML format is. Looking online is only giving me syntax examples and not the final output. Any suggestions?
 

A:Solved: Mail Merge situation

Read other 16 answers
RELEVANCY SCORE 60.4

Hi,

Is there any way to do e-mail mail merge with attachment? I have many files in a folder, then an excel sheet with file names and e-mail addresses. I need to send the each file to corresponding e-mail address in the list with a fixed text message. i.e file mmm.xls to [email protected], file sss.xls to [email protected] , etc..

My excel sheet looks like this..

File Name Name e-mail ID
1. mmm.xls Mathew [email protected]
2. sss.xls Sam [email protected]
 

A:Solved: Mail Merge with attachments

Read other 6 answers