Community
Showing results for 
Search instead for 
Do you mean 
Reply

Doing a Label Merge Between Act 11 and MS Word

New Member
Posts: 12
Country: USA

Doing a Label Merge Between Act 11 and MS Word

I still use Act 2009 (Version 11) which still works for me.  Every year I use Act to create Christmas Card labels, and every year it's a struggle to remember how to do it.

 

I really don't like the use the Act Word Processor, so I prefer to use Word.  Can someone tell me how to merge the data in my contacts with labels I've created in MS Word?  These are standard labels (e.g. Name, Address 1, City, State, ZIP), so nothing tricky in terms of fields.

 

I've tried exporting, creating labels, etc., but I cannot remember how I can easily use the data in ACT for my labels in MS Word.

 

Thanks in advance for the help.

Bronze Super Contributor
Posts: 1,538
Country: United_Kingdom

Re: Doing a Label Merge Between Act 11 and MS Word

Just go to File | Print.. and select which label you want.

David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org 
New Member
Posts: 12
Country: USA

Re: Doing a Label Merge Between Act 11 and MS Word

The problem is I want my labels to use these fields


First Name Last Name

Address 1

Address 2

City, State ZIP

 

 

I must be an idiot because for years I can't get the Report Editor to do this.  I can't get, for example, a comma to follow immediately after City.  If I try to manually insert a comma, I have to place it a LONG ways away in case I have a city with a long name.

 

What am I doing wrong?  Thanks.

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Doing a Label Merge Between Act 11 and MS Word

You need to use a VB script to concatenate the city, state and zip fields. If you're interested in having a custom template created, send me a private message or send a direct email to royel@techbenders.com

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129