Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: help creating a Mail Merge address database

20 Dec 2010   #11
Irene

Windows 7 Home Premium 64bit
 
 

That is a wonderful visual guide, mikedl.


My System SpecsSystem Spec
.
20 Dec 2010   #12
mikedl

Windows 7 Ultimate x64 SP1
 
 

Thanks, Irene.

I just wish I could figure out why it doesn't seem to be working for Snookie.
My System SpecsSystem Spec
21 Dec 2010   #13
Snookie

Windows 7 Home Premium 32bit
 
 

Very kind of you to produce such a helpful visual guide mikedl

I haven followed the Step by Step Mail Merge Wizard to the letter but am only getting two labels printed out at the top of the page, despite being able to click through and view all the 10 addresses selected in the Address Block window (for getting to grips with this)

I just cannot fathom it out. This is driving me NUTS!!!!

The only difference I can see is in the setup of my database, which is an .xlsx
file, it opens with the Sheet number as you have illustrated, the only difference being that (Although I have formatted it as a Letter sized document in landscape) it shows 50 sheet rows in total which gives 19 blank ones in addition to my list of addresses, so I laboriously have to untick them all. Whatever I do the page is set to have 50 sheet Rows!!
My System SpecsSystem Spec
.

22 Dec 2010   #14
Snookie

Windows 7 Home Premium 32bit
 
 

The problem seems to rest with the Update Labels function, it is not catching the records properly.

I have spent all afternoon trying to get it to work, but failed dismally. In a last resort I did a Google search and it would appear I am not alone, a "fix" is mentioned in the form of a new macro, but I am totally lost on how to do this, so would greatly appreciate help, explaining in simple terms what I do ...

Here is the site :
mail merge label problem word 2007

The same problem as I have is described here also with reference to recording a macro ....
Mail Merge Labels in Word 2007

Reference the Excel .xslx database file, the sortcut has a on it. Is this normal? I notice a few files have this and wonder what it means as I can edit the file so surely it can't be locked?

Hope you all have a good Christmas and are not snowed in if you are in the UK
My System SpecsSystem Spec
22 Dec 2010   #15
mikedl

Windows 7 Ultimate x64 SP1
 
 

Hi, Snookie. If you want to try the Macro, open a fresh instance of Word and copy the text below (in the "code" box) but don't paste it anywhere yet.
Code:
Sub MailMergePropagateLabel()

Dim atable As Table
Dim i As Long, j As Long
Dim source As Cell, target As Cell
Dim myrange As Range
Set atable = ActiveDocument.Tables(1)
Set source = atable.Cell(1, 1)
Set myrange = source.Range
myrange.Collapse wdCollapseStart
ActiveDocument.Fields.Add Range:=myrange, Text:="Next"
source.Range.Copy
For j = 2 To atable.Columns.Count
Set target = atable.Cell(1, j)
If target.Range.Fields.Count > 0 Then
target.Range.Paste
End If
Next j
For i = 2 To atable.Rows.Count
For j = 1 To atable.Columns.Count
Set target = atable.Cell(i, j)
If target.Range.Fields.Count > 0 Then
target.Range.Paste
End If
Next j
Next i
atable.Cell(1, 1).Range.Fields(1).Delete


End Sub
In Word, click the "View" tab then click "Macros" and select "View Macros":

help creating a Mail Merge address database-screenshot00285.jpg

In the next dialog just type anything you want into the "Macro name:" box (it's not important for this exercise but there are some rules about naming Macros so keep the name simple and at only one word) then click the "Create" button:

help creating a Mail Merge address database-screenshot00286.jpg


In the editor that pops up, you will see a VBA code window with your made up name and a few other code snippets - delete all of that and paste in the code you copied above:

help creating a Mail Merge address database-screenshot00287.jpg help creating a Mail Merge address database-screenshot00288.jpg

Close the VBA editor by clicking the normal close button at the top right of the window (the ubiquitous "x") and if Word asks you if you want to save, click affirmatively (say yes). Close and re-open Word (not really necessary but lets do it anyway), start your merge process and when you reach the step for "Update Labels", click the "Update Labels" button and the Macro should run.

If it doesn't, click the "Macros" button on the "View" ribbon and select "View Macros" as we did above in the first few steps. This time, in the resulting dialog, you will see the name of the Macro you just pasted into the VBA editor. Select it, if it's not already selected, then select "Run" (note: this might not be necessary - just clicking the "Update Labels" button should run this Macro but, just in case, I thought I would include the way to run it manually):

help creating a Mail Merge address database-screenshot00289.jpg

I hope it works for you, Snookie!


My System SpecsSystem Spec
23 Dec 2010   #16
Snookie

Windows 7 Home Premium 32bit
 
 

IT WORKED!!!!

Thank you so much for explaining what I should do so clearly.

Have a great Christmas,
Snookie
My System SpecsSystem Spec
23 Dec 2010   #17
mikedl

Windows 7 Ultimate x64 SP1
 
 

Quote   Quote: Originally Posted by Snookie View Post
IT WORKED!!!!

Thank you so much for explaining what I should do so clearly.

Have a great Christmas,
Snookie


(I knew the dinesh emoticon would be useful one day )

Wonderful, Snookie! Seriously, you did most of the work. I just helped a bit.

I hope you have a blessed and joyous Christmas, as well, Snookie.
My System SpecsSystem Spec
23 Dec 2010   #18
Snookie

Windows 7 Home Premium 32bit
 
 

you helped a lot, Macros are a complete mystery to me.

Love the ....... that's just how I felt when it worked!!
My System SpecsSystem Spec
Reply

 help creating a Mail Merge address database




Thread Tools




Similar help and support threads
Thread Forum
How can I mail merge with a locked Access DataBase?
Hi guys We have a help desk inquiry at the moment that I have no idea about. I have attempted several things over the last hour and cannot for the life of me get it working. Am I able to mail merge a letter in word with fields in a LOCKED Access DataBase? Your friend -Iroro
Microsoft Office
Facebook e-mail mess: Address books altered; e-mail lost
Read more at: Facebook e-mail mess: Address books altered; e-mail lost | Internet & Media - CNET News
News
Mail Merge using Windows Live Mail problems
Short Question: Is there any possible way to use Mail Merge in Microsoft Office 2007 with Windows Live Mail? Notes: Using Windows 7 computer. Windows Live Mail is being used as a program to send the emails out. Microsoft Excell is used to supply the email addresses. It is not an address book...
Microsoft Office
live mail 2011 - where is my previous database?
I just upgraded to Windows 7 from Vista, and installed live mail 2011. It did not automatically find my data. Where would I find my previous data in order to import it? (Everytime I upgrade Windows live it's the same old story)
Browsers & Mail
Windows Mail Database Lost? Vista to Window 7
I just upgraded from Vista to Windows 7 and can't find my windos mail messages anywhere. I just read somewhere that I should have exported them first. Any chance of finding them if I didn't export them??
Browsers & Mail


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 13:34.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App