12-16-2014 11:15 AM
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.
12-16-2014 12:22 PM
12-16-2014 12:39 PM
The problem is I want my labels to use these fields
First Name Last Name
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.
12-16-2014 04:05 PM
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 email@example.com