I'm looking for advice on utilizing MS Office 2007 Word while making a postcard and using a mail merge with my contacts listed in an Excel spreadsheet. Anyone know how to do this and what to look for? My Excel file has more information than just names and addresses. Will this be a problem?
-
Donate to my Tour de Cure
marK in WA and Ryobi Fanatic Association State President ©
Head servant of the forum
©
-
Did you try the 'Step by Step Mail Merge Wizard'? You can step thru most of the process without hurting anything, pert much up until you hit 'Print'.
Depending on the spreadsheet layout, you may have to manually insert the field blocks, or you may be able to just select the 'Address Block', which should show you how the addresses will appear printed out, and give you a chance to select/deselect/manipulate individual fields. After that it gives you the option to review the addresses as they will appear on the envelope, and exclude someone who was naughty and didn't make the x-mas card list
After that... you're ready to print.
You can do all this stuff individually, but the Wizard does make it *really* easy.All right, breaks over. Back on your heads!
-
No problem Mark, you can just select the fields you want including insertion of salutations, names and any other data you want to customize the mailing.
Its pretty much as Milanuk says, it is pretty easy. stamping and mailing can be a PITA if you have lots to do. I do this a lot for clients and can recomend a couple of different services that are pretty cost effective. If you are interested PM me.Jon
Phoenix AZ - It's a dry heat
________________________________
We all make mistakes and I should know I've made enough of them
techzibits.comComment
-
Rant WTF!!! I was going to do postcards printed and made by my very own desktop pc and printer. Sent LOML on a shoppin' trip OMG
from a local discount store I can get card stock with 4 cards per sheet for a total card count per package for ~$8. Hmmmm I need to mail about 100......
2 @ $8 + $27 postage = $43. Box of envelopes for $1.99 or there-a-bouts + $42. postage for letter size add in the way less aggravation factor of planning and formatting a letter plus the fact that I know my printer will feed envelopes and I think I'll just spend the extra few bucks and go letter first class.
/Rant
Phew I feel so much better. Thanks for the suggestions I'll play with it this evening.Donate to my Tour de Cure
marK in WA and Ryobi Fanatic Association State President ©
Head servant of the forum
Comment
-
If you are doing full color graphics on the front side dont forget to account for the INK!!!Jon
Phoenix AZ - It's a dry heat
________________________________
We all make mistakes and I should know I've made enough of them
techzibits.comComment
-
Update: Mail merge was mostly successful. I'd done this before but not by importing a db. Could not figure how to print envelops but labels were probabaly less work anyway so I went that route. Funny things did happen though. Somehow the source .xls file was moved to a different location while doing the merge.Donate to my Tour de Cure
marK in WA and Ryobi Fanatic Association State President ©
Head servant of the forum
Comment
-
If you're doing color postcards, you might want to try any of several mail order printers. They group together lots of smaller full color jobs to make it economical. We used to use them all the time for postcard marketing.
Here's an example that will apparently do 100 full postcards for free. http://www.vistaprint.com/vp/ns/my_sales.aspx?xnav=top -- scroll down about 60%.
online at http://www.theFrankes.com
while ( !( succeed = try() ) ) ;
"Life is short, Art long, Occasion sudden and dangerous, Experience deceitful, and Judgment difficult." -HippocratesComment
Comment