Over 1 million tech questions and answers.

Mail Merge in 2007 problem

Q: Mail Merge in 2007 problem

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!!!!

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

Read other 11 answers
RELEVANCY SCORE 82

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 82

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 82

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

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 80

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 74.8

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 74.8

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 am using the mail merge wizard in Word 2007 to create address mailing labels from a mailing list I saved in an Excel 2007 worksheet.

Everything is fine when I merge the documents together BUT there's one hiccup.

There’s a space Before the Mr(Mrs) of the name – but there no space in the spreadsheet (data) or before the address block.

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

Mr (instead of)​ ​Mr​ ​I've tried everything I can think of but cannot see where or why this is occurring.

Can anyone help?​ ​Thanks so much.​
 

A:Mail Merge 2007

Read other 7 answers
RELEVANCY SCORE 72.4

Hi everyone

I'm working in a big firm that has a very bad tech support so therefor I come here.

I'm trying to do a mail merge from Word 2007 to a bunch of emails through Outlook 2007

I have my list in Excel with one column named "email"

I have my letter ready in Word and go through "Finish & Merge" - Send Email Messages.

I get the window where I choose which field I want to fetch the email addresses and everything looks fine.

Then I press Send Records - OK, and NOTHING happens.

No messages are sent or received.

Any ideas????
 

A:Mail Merge in 2007

Read other 9 answers
RELEVANCY SCORE 71.6

Hello,

I am formating a letter through Microsoft Word 2007 using Mail Merge. This is the layout I am using:

«FirstName» «MiddleInitial» «LastName»«Comma»«Suffix»
«Company»
«Title»
«Address1» «Address2»
«Address3»
«City» «State_Abbr», «Postal_Code»

They all have Mergefield in the brackets with \b" " at the end of the bracket. The problem I am having is that a space appears in front of "FirstName" throwing off the alignment.

Is there a code or something I can put before to fix this??

Thank You!!!!!
 

A:Word 2007 Mail Merge Help

Welcome to the forum. I would check the FirstName field in your datasource to make sure you do not have a leading space within it. If so just delete them and you should be fine.
 

Read other 3 answers
RELEVANCY SCORE 71.6

Been having a problem with editing the recipient list in mail merge. When I go to save the edited list, I get one of two errors- a "read only" error if saving to a network drive, or a "insufficient permission" if saving to a local drive.

I've been able to duplicate this problem on multiple machines, with multiple files in both the .doc and docx. format. The data files are tables in Word, I have not tried duplicating the issue with Excel or Access datasources.

Of course, I have made sure the data files are not actually read only...

Thanks,

Michael
 

Read other answers
RELEVANCY SCORE 71.6

Hi Tech Support Guy,

I would like make mail merge activity by using VBA.

Kindly find the attached file where i have updated name, Email and invoice number.

By using VBA i would like to send Email to respective supplier by replacing below lines.(Marked in yellow)

Hi {Name},

We are pleased informed you of our latest offers.

Please find the respective contact number {number}.

Thanks,
Manoj

Kindly request you to fix this issue and it wil be highly appriciated!

Thanks,
Manoj
 

A:Mail merge by using VBA in excel 2007

Guys,

Can anyone help me with this?

Thanks,
Manoj
 

Read other 1 answers
RELEVANCY SCORE 71.6

Is there a way to do a mail merge using two databases at once?
 

A:Mail Merge from Access 2007

kogle, you could link one of the databases to the required tables in the other database and then mailmerge the result.
But it really depends on how the data is stored and what you want to do with it.
 

Read other 2 answers
RELEVANCY SCORE 70.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 70.8

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 70.8

I am needing help with a mail merge issue. I have my database in Access 2007

Let's say I have two to tables. Table one consists of customers who have purchased items and their locations. Table two is of the items that were purchased by the customers. The two tables can be joined by their ID's. CID = ID

Table 1
Name Address ID
Bob 123 Main st 502
Kim 13 State st 503

Table 2
Item price CID
pen $1.00 502
key $0.75 503
ball $3.25 502
key $0.75 502

I want to send letters out to the customers telling them what they have purchased, but I do not want to send multiple letters to the same customer if the have purchased multiple items. For example, Bob, has purchased three items. I only want Bob to receive one letter

My question is...How can I join these two tables to make one mail merge and not send out a single letter to a customer who has purchase multiple items?

Thanks.
 

A:Access 2007 Mail Merge question

You could also do this in a report directly in Access bypassing Word altogether.
 

Read other 2 answers
RELEVANCY SCORE 70.8

Hi, i have been trying to make a mail merge to print lables on an A4 label paper.

I used this to make the mail merge:
Quote:

«title» «name» ---------seperator--------- «Next Record»«title» «name»
«address» -------------seperator------------«address»
«city» ---------------seperator---------------«city»
«postal_code» ----------seperator----------«postal_code»

«Next Record»«title» «name» ---seperator--- «Next Record»«title» «name»
«address» -------------seperator------------«address»
«city» ---------------seperator----------------«city»
«postal_code» ----------seperator---------«postal_code»
now my problem is that when i make the merge it is displaying like this:
Quote:
Label 1 ----------seperator----------Label 2
Label 3 ----------seperator----------Label 4
on the next page:
Label 2 ----------seperator----------Label 3
Label 4 ----------seperator----------Label 5
why does not continue from label 5 in the next page, and finish at label 8???
 

Read other answers
RELEVANCY SCORE 70.8

Doing a weekly mail merge on Office 2007 with two different xls files. One of the fields to be used is a customer number - the majority of customer numbers are digits only but some accounts are alpha numeric. I just noticed that for some in one file the alpha numeric enty is changed to Zero instead of W1234 - all the numeric account numbers have no issue.

In the other file all account numbers are fine including the W1234? I looked at the formatting of the cells and it shows up as General for both files.

Anyone please who can shed some light on this?
 

Read other answers
RELEVANCY SCORE 70.8

I have tried several times to mail merge from Word 2007 and I get the message MAPI Folder or Address Book not found.
My operating system is Windows XP.

I would be grateful if someone could help.

Thanking in anticipation.
 

A:Unable to mail merge in Office 2007

Read other 7 answers
RELEVANCY SCORE 70.8

I am running an application that uses automated mail merge from access records called by a VB6 programme. It generally works fine on all versions of Word but periodically Word 2007 on an XP machine is not closing properly leaving the template open and therefore, next time one attempts to run the same mail merge one gets a 'document in use' message.

It is working fine in most environments - this particular PC did have both Word 2003 and 2007 loaded. We have removed 2003 but this doesn't seem to have solved the problem.

Any ideas anyone?
 

Read other answers
RELEVANCY SCORE 70.8

We are now on Office Pro 2007. We use Mail Merge in Word extensively, using our Access database as the source. We have 2 computers in the office.

When we open the mail merge document, it links to Access properly (we generally open the Access db first because it is quicker). We then merge to an individual record and save the merged document as *.docx.

When we re-open the document, it should be a normal Word document. Now what is happening is that when the merged document is created on MY computer, it opens the link to Access. When the merged document is created on THE OTHER computer, it opens as it should, without the link to Access.

Any ideas on what is going on???
 

A:Mail Merge - Word & Access 2007

I have never used Mail Merge, but it sounds as if on your Computer the merge data is being "Linked" instead of "Imported".
 

Read other 2 answers
RELEVANCY SCORE 70.8

Hi,

I've just tried using Office 2007 Word email merge. I've followed the tutorial for doing it step by step:

1. Use E-mail Messages.
2. Use The Current Document (my email message is already types out in the open document).

3. Use An Existing List (I already have an email list to send from and choose it).
4. Add my recipient information blocks (I've done this).

5. Preview the message (done this, all is good).
6. Hit "Electronic Mail...",
~a small options window opens to make sure the right fields are selected, I've selected "email_message", filled the subject line, selected HTML and under "Send Records" I've selected "All".

7. I hit "OK", this is suppose to be when the emails get sent, but nothing happens!

~At least I am not getting any of the emails that I've sent to my own email address?

Does anyone now why this might be?

I really like finally getting to mail merge, I am looking forward to using quit frequently, that is if I can figure it out?

Any help will be greatly appreciated.

HAPPY THANKSGIVING!

John

Read other answers
RELEVANCY SCORE 70.8

I just installed Office Prof 2007. Word is working fine except when I try to start mail merge.
As soon as I use any of the menu choices, the program pauses and then shows that the program is not responding.
 

A:Mail Merge Word 2007 (not Responding)

Read other 16 answers
RELEVANCY SCORE 70.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 70.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 70

I am trying to do a mail merge from a Word 2007 document.

I go to "Mailings"
Then to "Start mail merge"
"Labels"
then
I choose my label style and number
then
"select recipients"
then I click on my document.
This is where I think there may be a problem.

It doesn't give me an option to select the data table. Not sure why. It always did in the past.

The next step is for the address block. This also is not giving me a preview like it did before.

After I "Update labels" and then click preview.

There is nothing. Not one word to preview and the 8 pages of labels consisting of 1800+ words is gone.

I'm at a loss.

Thanks,
Mark
 

Read other answers
RELEVANCY SCORE 70

I have windows 7 & office 2007. I am attempting to create an email merge. I have tried to do so starting with first with outlook (which takes me to word) which failed in sending, and then starting with word (which takes me to outlook and then back to word) and also failed in sending. I have followed all instructions to a T (as provided by help in both programs as well as microsoft help online).

What am I missing? Is there some connection between the 2 programs that needs to be set up first?

Read other answers
RELEVANCY SCORE 70

Hi, I am having real problems trying to send mail merge emails to subscribers of a charity event I am organising. I have previously done it successfully but I have recently changed my laptop and it now runs on Vista - this is the only change. I am using office 2007. Please help! Thanks.
 

Read other answers
RELEVANCY SCORE 70

i'm making a program on access 2007 and yesterday i used the mail merge wizard and i export a table on a word 2007 document. now i'm trying to run this document file o a different computer and when i tried to open the file i got an error message "error has occured: 'C:\Document and Settings\....\db.accdb' is not a valid path. make sure that the path name is spelled correctly and that you are connected to the server on which the file resides" . how i can remove this error message in order to open this file on any computer that i will working on?

thank you
 

Read other answers
RELEVANCY SCORE 70

Hi,

Not sure if anyone can help me here, but I thought I would try.

I wrote a mail merge letter last year with the following criteria:

{ IF { = OR ( { COMPARE { MERGEFIELD Dfault_Code1} = "UW" }, { COMPARE { MERGEFIELD Dfault_Code1 } = "AW" } ) } = 1 "UW & AW Message" "Regular Message" }

Basically, if the Dfault_Code1 field contain either "UW" or "AW", I wanted the letter to display the UW & AW Message, otherwise just the regular message. The compare function served my purposes perfectly.

However, now there are 2 values that I want to add so it will display the UW & AW Message, FW & CW. Does anyone know if this is possible using the compare function? I have played around with it but I can't seem to get it to work.

If I can't use this function, can anybody suggest something that will work? I have done VBA programming in Excel and Access, but I am a bit of newbie in Word.

I appreciate any help that anyone can offer.

Thanks.
 

Read other answers
RELEVANCY SCORE 70

I am having a problem in getting a successful mail merge to print some
labels usng Excel as a data source on a 3 column, 10 row sheet under Office
2007/Vista. (Avery 8160 labels)
When doing the merge, only the first row of labels gets completed.
I have used the same Excel data under XP without problem.
I have tried doing it manually and using the 'wizard' but have failed
miserably - any thoughts please as to whether its me or a glitch somewhere?
(The Excel sheet and mail merge works well on my
laptop under XP Pro and
Office XP)
From what I have read this is common. Any hints on how to fix this issue?
SK

A:Mail merge (word 2007) will not do labels correctly.

Have EXACTLY the same problem.

Strangely, it happens only on my desktop, but not on the laptop w/c has the same configuration.

Don't understand this as a year ago, it was working perfectly well.

Labels are Avery 5160. 3 columns, just like above, and it only prints the first row, and then arbitrarily some records scattered through the rest of the merge.

PLEASE HELP!!!

Read other 2 answers
RELEVANCY SCORE 70

This may or may not be a word problem. It may be something that can be accomplish in Access.
I am doing a mail merge in word. The mail merge may produce 1 sheet or it may produce 10 sheets, depending on the amount of fields it needs to print. Example: I need to print coupons. One person may have 10 and another may have 100. The way I have been doing this, (and it is time consuming), I create an Access file with all the fields. Then I merge them into a Word doc. I have 12 coupons that will print to one sheet. The coupons with data, (all different), will print the amount on them and the fields that have no data will print VOID on them. I would like to know if there is a way to print only coupons that contain the data and the ones that have no data would just not print at all?

Read other answers
RELEVANCY SCORE 70

This may or may not be a word problem. It may be something that can be accomplish in Access.
I am doing a mail merge in word. The mail merge may produce 1 sheet or it may produce 10 sheets, depending on the amount of fields it needs to print. Example: I need to print coupons. One person may have 10 and another may have 100. The way I have been doing this, (and it is time consuming), I create an Access file with all the fields. Then I merge them into a Word doc. I have 12 coupons that will print to one sheet. The coupons with data, (all different), will print the amount on them and the fields that have no data will print VOID on them. I would like to know if there is a way to print only coupons that contain the data and the ones that have no data would just not print at all?

Read other answers
RELEVANCY SCORE 70

At present I am running Windows 7 64 bit with Microsoft Office 2007.

I also use a bespoke piece of software that uses access 97 databases. I am not able to port over to access 2007 due to the bespoke software needing access 97.

A major part of the bespoke software uses mail merge functionality into word. Due to hard drive issues I have had to re install the software on a new pc (windows 7 64 bit running ms office 2007.)

When ever I try to do a mail merge, there is an SQL error for linking to the access 97 database.

I am unsure how to correct this issue since I only have access 2007 on my computer. I suspect it has to do with the datasource or odbc driver.

Any help would be mutchly appreciated.

A:Access 97 / Word 2007 Mail Merge Issues

You will need to install Access 2.0 however, I'm not sure if Access/bespoke will integrate with Office 2007, especially if it is the 64bit version.

Regards,
GEWB

Read other 6 answers
RELEVANCY SCORE 69.6

Win 7 Home Premium + Pro upgrade/ HP Pavillion Elite 112y

Hi All,
I'm trying to email to around 320 recipients out of my MS Access program. I've created a good email list, with proper field names that "match" Publisher. The list "loads" into Publisher, and when I send/merge, the screen had me believing that the mail was being sent. Didn't happen, though. The only "clue" I have as to why, is that (contrary to other times when I've used Publisher/Access merge) I couldn't get to see "recipient previews." Tried starting over several times; same results. Any ideas? I love working with Publisher/Access for personalized emails that don't show the others on the recipient list; hope someone can help me find the answer to this problem. Thanks.
 

Read other answers
RELEVANCY SCORE 69.2

Directions say to use the underline instead of spacebar. The list prints out with the underline still there!
 

A:Office 2007 Mail Merge address show underline

Have you tried using Spacebar instead of underline? Go against Microsoft for once!
 

Read other 2 answers
RELEVANCY SCORE 69.2

I use mail merge only once a year, for holiday envelopes. So I'm unfamiliar with most of the options. My recipients are stored in Excel. I have saved a (single envelope) .docx with my return address and «FirstName» «LastName» «Address», etc. for recipient. But I don't know how to use it. Every year I have to start from scratch. Thankfully, I've made a checklist so that I don't have to learn everything anew each December.

It just makes sense to use the saved layout instead of redoing the whole process each time.

Where & how in the "Start Mail Merge/Envelopes/Select Recipients . . ." sequence do I tell it to use the saved layout (template)? Is a .docx the correct file type?
 

Read other answers
RELEVANCY SCORE 68.4

I have been sending individual emails to roughly 400 of my clients and perspective clients per month.  I have been sending them one by one so I could personalize it. I need to be able to do the following.  
 
Include the first name of my client after "Good Afternoon _______ "   in the body of the email.
 
Select 1 of my 3 business email addresses from my Microsoft Outlook 2007 Imap emails.
 
Include 2 PDF documents.  
 
Using mail merge via  Microsoft Word does not give these 3 options from what I can find.  This would save me so much time if I can send personalized mass emails to my clients.  Any help or ideas would be greatly appreciated.  

A:Outlook 2007/ mail merge/ cant include attachments or email to send from

anyone?

Read other 4 answers
RELEVANCY SCORE 68.4

I have it set up to list an agency and then a recipient.

<name>
<address 1>
<address 2>
<city, state, zip>

<date>

<recipient name>
<address 1>
<address 2>
<city, state, zip>

In the first set it seems like it automatically set it as an address block even though it doesn't say it anywhere and if the address2 is blank it moves the city,state,zip up to fill in the gap. In the recipient address, if there is no address2, it leaves a blank line. Using the address block fix is problematic because it does not seem to want to allow me to choose the specific fields, it names them for me. Also, there are nine versions of the letter I arranged into excel fields to get around having to create multiple versions. I was going to just either put the info in the excel field or leave it blank, but it leaves blank lines on that too.

Is there a way to suppress the blank fields? I have seen some complicated sql language that supposedly will do it, but I don't understand what they're telling me to do.

Help!

~Shadowfax
 

A:Solved: Word 2007 Mail Merge Unwanted Blank Line!

For fields that might be blank, try conditionally adding that field versus a regular add. In your example, it would look something like this:

{Mergefield "Address 1"}{IF {Mergefield "Address 2"} <> "" "
{Mergefield "Address 2"}"}
 

Read other 3 answers
RELEVANCY SCORE 68.4

I've successfully created and run a Word 2007 Merge document and discovered that I omitted a field. Every time I open the Word template I created to add the new field it propagates and creates the merged document and I can't seem to figure out how to add another field to the template. HELP, of course.
 

A:Solved: MS Word 2007 Mail Merge Template-Can't find how to amend

Read other 6 answers
RELEVANCY SCORE 67.6

I have a form with a button. I need to be able to press the button and have Access export a query to Word 2007's mail merge. Is this even possible? All the tutorials I can find say I need to select the query from the Navigation Pane, then go to External Data -> Export -> More -> Merge it with Microsoft Office Word. The problem is that I don't want to give the user access to the Navigation Pane.

Thanks in advance.
 

A:Access 2007 - Query export to Word mail merge w/Command Button

Read other 16 answers
RELEVANCY SCORE 67.6

Problem creating address labels in mail merge. Excel 2007 >Word 2007
Avery 5160.

Problem:
Everything works good until I preview labels. Many of the labels are left blank. causing a whole lot of wasting labels!
in some cases the merge was filling randomly. I thought it was caused by cells that were hidden, but it still happened after i deleted all of those.

can anyone help my sanity and help me stop wasting all this label paper?

Thanks.
 

A:Solved: How to Remove blank address labels in mail merge. Word 2007

well i realized after i continued through the printing process, it eliminated the problem.
 

Read other 1 answers
RELEVANCY SCORE 65.6

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 62.4

I've been trying to set up an email merge in Word 2007 using a Table in Access 2007. However when I "Finish and Merge" the emails cannot be delivered because the email field contains the email address and #email address#. How can I solve this?

Read other answers