Over 1 million tech questions and answers.

Word Mail Merge Crashes With Excel CSV file

Q: Word Mail Merge Crashes With Excel CSV file

I have Office 2003 with a Vista operating system. Everytime I try to do a mail merge to create label with a Excel csv file it forces me to close the application.

I can complete the mail merge using the same file on any other computer. The only why I can get the mail merge to work is to save a csv file as a regular excel file. It doesn't matter what csv file I try on, it just crashes word.

Tried unistall and re-install of Office and the problem is still occuring.

I don't know why word won't allow me to use th csv file type.

Please hlep

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Word Mail Merge Crashes With Excel CSV file

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.)

RELEVANCY SCORE 90

Using Windows 98, trying to do Excel to Word mail merge.
Workbook name
Main.xls
Worksheet names:
Board
CLEC_Affliates
ISP_Affliates
MCC

I have named cell ranges on each of the sheets, and would like to use that information selectively for a variety of mail merges in Word. When doing the merge though, my only choice for Data source, is entire spreadsheet...and my "named" ranges do not show up? Any advice...named ranges are named in following manner:
Board='Board'!$A1!Bx17 etc
Any help would be appreciated, please cc the email to
[email protected] as I will be working on this tonite at home too.
Thanks
Victoria
 

A:Excel/Word Mail Merge

Dear TSGF: No one ever answered my post, so I assume, as is always dangerous, that no one knew the answer. However, I figured it out even though it is not intuitively obvious from the MS standpoint! Here's the answer to my own question"

If you do not have Excel ODBC Drivers, Please install them in this way :

1) Click on Start --> Settings --> Control Panel

2) Select 'Data Sources (ODBC)' and press Enter key.

3) Goto 'System DSN' tab (3rd tab out of 7 tabs) in the "ODBC Data Source Administrator" dialog box.

4) Click on ADD.

5) Select 'Driver do Microsoft Excel (*.xls)' from select driver list box.

6) Click on Finish

Now you will see 'ODBC Microsoft Excel Setup' dialog box.

7) Type a name in 'Data Source Name' and click OK.

Now, Microsoft Excel ODBC Drivers are installed onto your system.

NOTE : You must install Excel ODBC Drivers prior to using mail merge facility.The Microsoft Excel ODBC driver must already be installed.

NOTE: In the Select Table dialog box, you will see all the tables in the workbook, not just the ones from the first sheet.

To connect to Excel using ODBC, follow these steps:

1) From the Get Data list, click Open Data Source.

2) Locate and select the Microsoft Excel file. In the Open Data Source dialog box, make sure that the Select Method check box is selected.

3) Click Open.

4) In the Confirm Data source dialog box, select "Excel Files via ODBC (*.xls)... Read more

Read other 1 answers
RELEVANCY SCORE 88.8

Hey all,

Using Words Mail Merge with Excel as the source, however when i merge to new document, it merges into one long document, as I want to email out the merged letter separately, how can I make the merge to new documents rather than document?

Multiple letters ready to be saved separately for each merged letter.
 

Read other answers
RELEVANCY SCORE 88.8

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 88.8

Okay, I've been working on this all day and feel like I'm trying to learn brain surgery. Here is my situation.

I have an EXCEL 2007 worksheet (name, address, city/state/zip as headings) saved with 85 records. I go to WORD 2007 and open a new document. Go MAIL>Start Merge, and choose "Label" and select my label (Avery 5160). I then SELECT RECIPIENTS, go to "Existing User" and find my worksheet and open it. The first label is blank and the other 29 labels have <<Next Record>>.

I then go to ADDRESS BLOCK and match my headings for the merge. All 85 of my records show up in the little preview box. <<Address Block>> shows up in the first label.

I then highlight the whole label sheet (clicking on the little corner icon in the top left corner) and change the font to Arial Narrow, 11 point, so the print will fit). Upon hitting "Preview Results", I have the correct address showing in the first label space.

Now I go to UPDATE LABELS and the <<Address Block>> shows up in the #2 and #3 label, and the #29 and #30 label for a total of five labels (1,2,3,29,30). When I preview, this is what I get:

85 pages of labels
Page 1 = Record 2,3,4 on the top row; Record 30,31 on the bottom row;
Page 2 = Record 3,4,5 on the top, Record 31,32 on the bottom;
Page 3 = Record 4,5,6 on the top, Record 32,33 on the bottom, etc. through page 85.

The rest of the labels are blank.

Any suggestions because you can stick a fork i... Read more

A:Excel 2007 Mail Merge with Word

On the Microsoft forums, a semi-fix was posted for the same problem. Go through the Mail Label Wizard and when you get to "Step Four", press "F6" and tab to the "Update Labels" and hit enter (don't use the mouse to "enter". For some reason, that propagates all the labels.

However, for 85 records, it created 85 pages of labels.

Page 1 = Record 1-30;
Page 2 = Record 2-31, etc.

So I printed pages 1, 31, 60 and got my 85 labels.

Is any of this sound familiar to anyone?

Thanks.

Mark
 

Read other 1 answers
RELEVANCY SCORE 88.8

Using a mail merge in Word 2007, importing the data from an Excel spreadsheet.

The problem occurs when there's empty data in the last field out of 4, which are all in one cell in a word table. If any of the first three fields are blank, Word leaves no gap, but if the last field is blank it displays as a blank line, which ruins the vertical alignment. Is there anything that can be done about this, or is it a limitation of the software?
 

A:Mail merge Excel+Word 2007

Read other 9 answers
RELEVANCY SCORE 88.8

I understand how to do a basic mail merge from excel into word.

I want to complicate it by merging data from two different sheets in the same workbook into one document.

I have one sheet with Math grades for my students and another sheet with ss grades.

I want to create a status report that will give the parents both Math and SS.

I have the same kids in each class.

Can I do it? I've searched and can only find the same info on how to do it from one sheet.

Thanks
 

Read other answers
RELEVANCY SCORE 88.8

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 88.8

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 88.8

I am trying to create an e-mail merge with a word document and data from an excel sheet. I used the Mail Merge wizard, everything seemed in place, previews were correct. I "finished" by putting in a subject name and hitting ok. The box closed, but no e-mails were sent. No error message. Any thoughts? I've tried several times.
 

Read other answers
RELEVANCY SCORE 88

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 88

I am trying to merge Excel spreadsheet data into multiple areas into a Word document. I cannot figure out on our 2003 Office version if I am missing a step or not...every time I "merge" it tells me it is merging hundreds of fields (we only have about 60 rows and 15 columns of data).

When the merge is done it inserts one row of data multiple times. I know there is a way to tell it to only pull from certain areas (like a data range) but the selection is "greyed out". I've tried the "if" statement to pull information by department and that didn't work either. I've included a PDF of the spreadsheet and the final document (no "real" data is inputted) just to give you a clue as to what I am trying to accomplish..which may be a pipe-dream at this point.

At this stage I'm about willing to let my staff hand-enter the information into Word, but there's got to be a way to do this. MS Office help, is no help - they only talk about merging if you are doing a mail/letter merge. Thanks for any assistance!
 

A:Using Excel NOT for Mail Merge but Merging Data into Word

Read other 16 answers
RELEVANCY SCORE 88

Hi there,

I'm trying to import data from an Excel spreadsheet into a Word document that already has the mail merge set up in it. Whenever I try to do this, I select the source after which it just sits there with a message in Word indicating 'Initiating DDE Link with Microsoft Excel.' I tried it with the same document on another machine and it worked... Is there another way other than reinstalling Word and Excel to fix an issue like this. I already tried /unregserver and /regserver and also tried creating another document with a mail merge.

Thanks a lot in advance!!
 

Read other answers
RELEVANCY SCORE 88

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 88

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 87.2

I have a Microsoft word mail merge with around 11 fields, I wish to export 2 specific fields into an excel spreadsheet, is this possible and how would I go about doing this?
I use Windows 7, Microsoft Word 2007 and Microsoft Excel 2007
Please assume I have very basic skills in relation to these programes, so may need to be spoon fed a lot of the information

Thanks in advance,
Thomas
 

A:Exporting specific field from word mail merge to excel

Read other 9 answers
RELEVANCY SCORE 87.2

I have been successfully using an excel database to create mail merge labels in word. I have now made that spreadsheet read only (as others will be accessing it) and now every time I try to export the information into word my labels only show #N/A in the fields where the name and address details should be.

Is there a way to get around this and make it work or will I have to remove the read only security?
 

A:Is it possible to create a mail merge in word when the excel data is read only

I think it does cause problems with the sheet in general, there are two things you can try.

1. create the mailmerge document when the spreadsheet is not read only and save the successful mail merge template. Then rather than exporting from excel open the word doc again and hopefully it has remembered the link and it will be able to pull to date.

2. Alternatively could you have a duplicate sheet hidden in the background of your excel file that literally copies every thing that has a value. and mail merge from that?

Does that make sense
 

Read other 2 answers
RELEVANCY SCORE 87.2

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 86

As part of a program i am working on data is transferred into an excel document with usually more than one worksheet. after that happens a mail merge is manually done to create labels. the problem i am having is that the first time i open the excel workbook i can choose a table and make labels fine but if i try to open the excel workbook again to change the table to make new labels an error pops up saying that word cannot open the data file because it is already open. i know for a fact that the only place it is open is in word because i already have labels open from it, and this operation works perfectly fine on another computer. i am concluding that this is a Microsoft office error however i cant find any other people having problems with this.
 

A:Error when changing excel data sheets in word mail merge?

Welocme tho TSG,
If word is open and linked to the spread sheet, opening the spreadsheet in exel would evoke the "in use" response. Closing word is the only option here.
 

Read other 3 answers
RELEVANCY SCORE 82.8

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 79.2

I am using the mail merge wizard in Word 2003 to create address mailing labels from a mailing list I saved in an Excel 2003 worksheet.

Everything is fine, I've tested is several times. But there's one very aggravating little problem.

The labels are all created with a space in front of the first line (name) on each and every label.

I want them to look like this:

John Smith
123 Main Street
Charlottesville, VA 22901

But instead they all look like this (the underscore I typed in is actually just a blank space):

_John Smith
123 Main Street
Charlottesville, VA 22901

I've tried everything I can think of.

The spreadsheet cells for names do not have an extra space in them before the names. I have one column in the spreadsheet called Name that has the entire name of the person I want to appear on the first line, so I'm not using separate values for first name and last name, it's just one: Name.

Please advise. Thanks so much!
 

A:Labels-Mail Merge,Word 2003 & Excel 2003-space at beg.of 1st line

Yup. It's a PITA. You need to NOT use the Address Block. Instead, insert the individual fields. See this article:
http://www.officearticles.com/word/insert_merge_fields_in_microsoft_word.htm
 

Read other 3 answers
RELEVANCY SCORE 78.8

Hi - just looking for some help as getting a bit annoyed cos it's not working

I've got a table which contains people's details.

What I'm trying to do is if the person has no date of birth on file (i.e. they are over 18 year of age) for the merge to put a tick into a column, but if the person has a date of birth on file (i.e. under 18 years of age) for the merge to leave the column blank.

The column after this will contain the date of birth (if any).

In the over 18 box I've put the following function:
{ IF { MERGEFIELD DATE_OF_BIRTH } = "" "CHECKED/TICKED BOX SYMBOL" "UNCHECKED BOX SYMBOL" }

As each form will contain anything from 1 to 8 records, the lines which wouln't contain any merged data (i.e. if only 4 names to merge into a form, the last 4 rows of the form would be blank) - but it keeps merging in a ticked box for all the rows, even if there is only one row of data.

Hope this makes sense.

Thanks in advance for any help/advice.
 

A:Mail Merge - Help with Word 2003 & Excel 2003 using IFstatements

This does not sound like a merge function, it sounds like you are just validating data in a cell and based on that cells content putting a check in a check box.
 

Read other 3 answers
RELEVANCY SCORE 78.8

This is a puzzle. I do a standard mail merge to create labels. In word with excel as the database. All goes well until the last step. Then, I get the first label only on each page. All others are blank. Any ideas?
 

Read other answers
RELEVANCY SCORE 78.8

Hi

help with this would be very appreciated.

We run windows xp, word 2003 and excel 2003

we have created a mail-merge between our database of patients in excel and word, but when we come to the section where we tick the boxes next to the people required for the mail-merge we can select only 1 or 2 or 100, but when the mail-merge goes to the next section it has reverted to selecting the whole database of patients, which when your trying the send a letter to only a few people and it instead tries to print 5000+ letters is annoying to say the least.

i have tried changing the database to running from access, and i have started fresh and re done the mail-merge letter but this is all to no avail as the same error occurs???

any ideas,
please help
 

A:Mail merge problem using excel 2003 and word 2003

There may be some bad data within the columns that may be causing your issue. Look to see if there something out of the ordinary within the dataset you are trying to use for the mail merge. I think one may be column headings with spaces in them and another may be where two or more rows may have meen merged in your spreadsheet.
 

Read other 1 answers
RELEVANCY SCORE 78

Hi Greeting for the day!

Am seeking for help do it? i have one excel and one word sheet. in excel i have created commend button if i click button merging should happen step by step in sample document. please help me for using vba code for this. Please find the reference documents in attachments. please let me know so i can provide more information.
Appreciate your assistance.
Many thanks,
Saleemu
 

Read other answers
RELEVANCY SCORE 77.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 73.6

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 73.2

Hi, I think I have a new one for you. I've seen this problem posted on other sites and no solutions ever addressed.

I'm mail merging a a mailing list onto sheets of ten labels, a different number of labels every day, anywhere from 30-200. I've used the wizard any number of times, always with the same result, never with an option or menu that provides a fix:
-- 1st sheet looks okay -- records 1-10 appear
-- 2nd sheet, records 2-11 appear
-- 3rd sheet, records 3-12 appear
-- etc, till there are as many sheets as there are records in the database. So for today's mailing list of 45 records, I had 45 sheets instead of 5.

The first label in my template has a header that says "Research Study" followed by the mail merge fields -- custom arranged, not using Address Block or anything preset. The propogated labels all say "<<Next Record>>" in front of "Research Study". I can provide an example if needed.

It also doesn't allow me to choose the order in which the emails propogate, i.e. I can go across but not down. I've done this many times in older versions of Word without these problems. I've used the Avery system, but I have to go thru the wizard each and every time when all I want to do is make a reusable template to copy and merge new records into each day.

Please help.
 

A:Labels-Mail Merge,Word 2003 & Excel 2003-labels repeating ad nauseum

Read other 11 answers
RELEVANCY SCORE 73.2

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 73.2

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 73.2

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 73.2

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 72.4

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 72.4

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 72.4

I have an Excel spreadsheet of contractors. For the majority of the contractors there is more than one email address listed for them. I am attempting to do a mail merge in Word with this data. I have found that if there are multiple e-mail addresses listed in the e-mail cell that word just ignores that row all together and that contractor does not receive any e-mails. Is there any way to make the mail merge send to all addresses, or I would settle to mail to just one at this point , without totally reformatting my excel sheet? I know that I can make multiple entries for the same contractor with each e-mail address listed on a separate row, but this then makes my spreadsheet unusable for other functions within the company. Please Help!
 

A:Mail Merge w/ Multiple e-mail Addresses in Excel

Read other 8 answers
RELEVANCY SCORE 70.4

i am trying to do a mail merge using the data in excel; i have done mail merge before and never had any problem until today ; but it's an odd problem tho; for some reason, word doesnt read the column for job title, and when i try to play around with the fields, it gives unpredictable and not logical result; i never had this problem before and dont know if anyone else has the same experience

the format should be

full name
job title
company
address 1, address 2
city, state zip

and for some reason it wouldnt pickup the job title field data, and when i try to put 2 job title fields , it omits the full name!!!,etc.... very weird
 

A:please help with mail merge in word

Read other 6 answers
RELEVANCY SCORE 70.4

I'm having some trouble printing a mail merge document from Word 97. Here are the details:

1. The document is formatted such that 3 form letters can fit on a single 8.5X11 piece of paper (each form letter is 3.6 inches tall, thus I want to print three on a single sheet of paper and will later cut it into thirds).

2. Each form letter has text and a graphic common to each letter (thus a "form" letter) and fields of unique data imported using the Mail Merge option on the TOOLS menu.

I am able to get the merge to occur, however it results with a single form letter per page, hence two-thirds of each printed page is wasted space. If I delete the page-break that appears on each page, I am able to get all three form letters on a single page, however I end up losing some of the formatting graphics.

Can anyone offer some suggestions of how to proceed?

Thanks
 

A:Using Mail Merge in Word

You must have the *doc* set up 3 times on the sheet. On the first you will have your first merge field.

On the 2nd, in FRONT of the first merge field, you must have a Word field "next record"

On the 3rd, same thing...

Suggestion: Right-click, Format picture and set text wrapping to INLINE WITH TEXT.

Hope this helps. If not, email data (change names if you like, and I only need four or five records) and merge doc as is to:

[email protected]
 

Read other 3 answers
RELEVANCY SCORE 70.4

I am currently using an older printer to merge 3.5" x 8.5" card stock from a FoxPro database. The older printer has a swinging door style manual feed and that's how I print the merge. I am interested in buying a newer printer, but most of them have small manual feed slots which only take one card at a time. I tried resizing the tray and changing the default paper source in Word and the printer settings, but the printer still wants the card from manual feed. Am I missing something? Thanks.
 

A:MS Word Mail Merge

swaters said:

I am currently using an older printer to merge 3.5" x 8.5" card stock from a FoxPro database. The older printer has a swinging door style manual feed and that's how I print the merge. I am interested in buying a newer printer, but most of them have small manual feed slots which only take one card at a time. I tried resizing the tray and changing the default paper source in Word and the printer settings, but the printer still wants the card from manual feed. Am I missing something? Thanks.Click to expand...

Just a little thing:
When creating mail merge, MSWord automatically puts option "Manual" in "Tray" (Don't ask me why!); change it to "Default Tray (Auto Select)". Only withdraw is that You'll have to create new main merge document.
 

Read other 1 answers
RELEVANCY SCORE 70.4

Hi,

I would like to set up a word mail merge the following:

If field OPTION1, OPTION2 and OPTION3 are al three empty, I would like to show the text "no options available" in any other case I would like to display these options.

I was thinking it would be something like this.
{IF<<OPTION1>>AND<<OPTION2>>AND<<OPTION3>>="" "No options available" <<OPTION1>><<OPTION2>><<OPTION3>>}

Unfortunately that doesn't work.
The problem is likely the AND selector. I haven't found any documentation of how to use AND selection in Word.

Any ideas? Help would be greatly appreciated.
 

A:Word Mail Merge with IF and AND

Read other 6 answers
RELEVANCY SCORE 70.4

What is the quickest way to create a mail merge in Word 97.
 

A:Word 97 Mail Merge

Some pointers:

I personally prefer using Excel as my data source (get data, change files of type to Excel). The mail merge helper will actually use a Word table as the data source (create data source) if you follow through the steps.

Regardless, your column headings in the data source need to be in row 1 and the first record of data must be in row 2.

Follow the steps in the mail merge helper. Generally, you'll use "active document" when prompted, except when performing the actual merge--use new document.

When you've put the codes into the letter, labels, etc., I suggest testing it (use the <<abc>> button on the mail merge toolbar), and then saving it as a template. Close it, hit file-new whenever you want to use that merged letter, label, etc.

Recognize that you're creating two files. The data source (put "data" into the name somewhere) and the coded file (put "merge" in the name somewhere).

Check here, if you can. 2000 and 97 are virtually the same when it comes to mail merge: http://support.microsoft.com/servicedesks/Webcasts/WC110200/wcblurb110200.asp?

Let me know if you run into problems or need more help.
 

Read other 2 answers
RELEVANCY SCORE 70.4

I develop an application that does mail merges with Word. It runs fine on Win2K and XP and with Office 97 up to 2003.

I am now running on Vista Business and Office 2K7. when I do a mail merge, I sometimes get an extra window like this:

Sometimes I can't even close this extra window. Any help appreciated!
 

A:Word 2K7 mail merge

Read other 8 answers
RELEVANCY SCORE 70.4

Hey Guys,

I have an end user who is needing to set up word 2007 mail merge. She is drawing her list of recipients from our SQL server database. She is needing to place up to nine names into a 3x3 table, with one name per cell. Our problem is that some of the schools she is doing this for don't have nine people. So not all nine cells are filled. Now the problem this causes is that when one page doesn't fill all of the cells word starts grabbing names that are supposed to be on the next page (school) and using them to fill the partially filled chart. This is a huge problem because each page is a different school with different Board members. So I need to figure out a way to separate the charts so that each page's chart is filled according to the School name that is pulled from the database. She is currently having to do a separate merge for each school, we have 56 different schools. And it is an extreme hassle for her. If you have any suggestions please let me know. Also if you need me to clarify anything, please send me a message.

Thanks
 

A:Mail Merge in word 07

Name Name Name
Name Name Name
Name Name Name

It's going to look similar to that, but there is going to be a chart surrounding it. and each Name is a different board member. however some schools dont have 9 board members, and word is currently pulling the names from the next school on the list in order to fill all 9 cells. How do i Prevent it for doing this without having to do a new mail merge for each school?
 

Read other 2 answers
RELEVANCY SCORE 70.4

I want to use a spreadsheet for the records in the merge. I would like to use one of the columns to specify how many times that particular record should be printed. Is that possible?

I also want a number on each document that auto-increments each time that document is printed.
 

Read other answers
RELEVANCY SCORE 70.4

EXCEL E-Mail Merge

I want to do an E Mail Merge with OUTLOOK and send an EXCEL spreadsheet (not a WORD DOC). Is this possible?

I am very familair with WORD mail merges and OUTLOOK e-mail merges, but can't figure out how to send out a spreadsheet.

Thanks
Jay H
 

Read other answers
RELEVANCY SCORE 70.4

Hi, trying to create some labels ( AVERY L7161 ) from a spreadsheet, (see attached)

Can someone help/advise?
 

A:mail merge from Excel

what i have done so far just includes 18 of the addresses? i.e 1 page?
 

Read other 2 answers
RELEVANCY SCORE 70.4

Hello,

I have a document that was created in Excel, and would like to insert data from a Word Mail Merge file into one of the cells, can anyone help?

In other words can I insert Word data into an Excel cell?

Thousands of articles on how to insert Excel data into Word, but none the other way.

Thanks.

P.S. I use Excel 2007 at work, but have 2003 at home.
 

A:Help with Mail Merge INTO Excel

Hi welcome to the forum.
I have no idea how much data you have in word and what kind of data you want in Excel.
Keep in mind that it it's a paragraph or so you will have to keep in mind the max length of text allowed in a cell (I think that is 255 characters) This is also limited depending on the cell format you use, if it's set to General it allows more because it will treat it almos like a memo field as is in Access, but that has it's limits too.
I cannot imagine a reason why you need Word -> Excel but that is besides the point.
It will give us a better idea if you can post a sample of the Excel file and the Word file (no personal data please)
 

Read other 1 answers