David Overton's Blog and Discussion Site
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small. I specialise in Windows Intune and SBS 2008.
This blog is purely the personal opinions of David Overton. If you can't find the information you were looking for e-mail me at admin@davidoverton.com.

To find out more about my Windows Intune BOOK - Microsoft Windows Intune 2.0: Quickstart Administration click here

To find out more about my SBS 2008 BOOK - Small Business Server 2008, Installation, Migration and Configuration click here

How to do mail merge letters and labels in Office 2007
David Overton's Blog

Buy my books

Windows Intune:Quickstart Administration


This is the RAW book (Read as Written).
Click here for more information
Buy or pre-order today

SBS 2008 - Installation, Migration and Configuration

Small Business Server 2008 – Installation, Migration, and Configuration

Buy today in book or e-book form

Request a Review Copy

Twitter

Syndication

I got a mail on this today, so thought I had better drop a quick note.  The Office 2007 web site has a great search system that got me an answer straight away that includes screen shots to make it real simple. (I searched on the site for mail merge and then picked Word 2007 from the product picker).  Please note that you can also e-mail merge to result in a number of e-mails being sent (perhaps with a newsletter) and that if you use publisher then you can also do things like put in place web links that have a unique identifier so you can tell who clicked on them.

The answers can be found at:

http://office.microsoft.com/en-gb/word/HA100819761033.aspx?pid=CH100626281033 for the letters

http://office.microsoft.com/en-gb/word/HA101091611033.aspx?pid=CH100626261033 for the labels

ttfn

David

 

Technorati tags: , ,

Posted Sat, May 12 2007 8:57 PM by David Overton

Comments

Jane Smith wrote re: How to do mail merge letters and labels in Office 2007
on Mon, Jun 4 2007 6:26 PM

Hi David

I have been used to Microsoft Office 2002 and windows XP, and now at work I have MS Office 2007 and Vista.

I often use excel and word to mail merge, eg doing invoicing, and now I cannot make it work.  Dates get reversed to the American version, and numbers that are formatted as currency do not stay in the correct format.  I have looked at your link on mail merge but am still very confused.  It used to be so simple, and now seems to be far mor complicated.  Can you help?

Cheers

Jane

Jean Sadler wrote re: How to do mail merge letters and labels in Office 2007
on Wed, Dec 10 2008 10:32 PM

I figured out how to merge my data and envelopes, but now a partial address continues to come up when I try to print a single envelope without mail merge. How can I get rid of this address?

Chrissie wrote re: How to do mail merge letters and labels in Office 2007
on Fri, May 15 2009 9:39 AM

Could someone inform me how to mail merge in Vista?

Thanks a lot!

Chrissie

Anonymous wrote re: How to do mail merge letters and labels in Office 2007
on Tue, Jun 23 2009 7:35 PM

Ok I get it now! Cool

Anonymous wrote re: How to do mail merge letters and labels in Office 2007
on Fri, Jun 17 2011 6:14 AM

Can someone tell me why when having created a list file to use for mail merging in Vista and when I open the file it is all wierd and I cant use it>>?

David Overton wrote re: How to do mail merge letters and labels in Office 2007
on Fri, Jun 17 2011 8:02 AM

Hi,

How are you creating the list - which version of Office and can you give me a step by step - which application you use and what you do?

Thanks

David

Add a Comment

(optional)  
(optional)
(required)  
Remember Me?

(c)David Overton 2006-13