Interested In Advertising? | Contact Us Here
Warning!

 

Welcome to Clean It Up; the UK`s largest cleaning forum with over 34,000 members

 

Please login or register to post and reply to topics.      

 

Forgot your password? Click here

Colin Day

How do I Mail Merge?
« on: August 07, 2010, 01:04:37 pm »
I have my customers on exel and want to produce individually addressed labels in order to send a newsletter to them.

I've googled it but I can't head nor tail of it ???

jasonl

  • Posts: 3183
Re: How do I Mail Merge?
« Reply #1 on: August 07, 2010, 01:34:29 pm »
Buy carpet cleaners software , add data , 5 clicks and you can print as many addresses as you have in your database, was really simple.
I clean carpets
I dry Buildings

ianharper

Re: How do I Mail Merge?
« Reply #2 on: August 07, 2010, 02:21:52 pm »
Colin

I think you have to import it and its to do with the type of file it is. not sure but you should be able to convert on-line to formate need if you cant import as is

look up importing files to your database program if you have one. I used act 6 for years before i went stone age. you can get old versions on ebay.

Respect

Ian Harper

derek west

Re: How do I Mail Merge?
« Reply #3 on: August 07, 2010, 03:33:56 pm »
go into excel, click on help, then type in "how do i mail merge" then follow the instructions, ;D

wynne jones

  • Posts: 2918
Re: How do I Mail Merge?
« Reply #4 on: August 07, 2010, 04:43:53 pm »
Buy carpet cleaners software , add data , 5 clicks and you can print as many addresses as you have in your database, was really simple.

Save yourself a lot of grief. I recently got this http://www.carpetcleaningsoftware.co.uk/and it was worth every penny.
It's not expensive, you just can't afford it.

Colin Day

Re: How do I Mail Merge?
« Reply #5 on: August 07, 2010, 06:47:58 pm »
Buy carpet cleaners software , add data , 5 clicks and you can print as many addresses as you have in your database, was really simple.

Been there done that lost all data twice thanks to our computer crashing....  >:(

Please note: Cleaner's software was NOT at fault and when I had it up and running, it was bloody brilliant!

nevil

  • Posts: 478
Re: How do I Mail Merge?
« Reply #6 on: August 08, 2010, 02:07:05 pm »
Buy carpet cleaners software , add data , 5 clicks and you can print as many addresses as you have in your database, was really simple.

Been there done that lost all data twice thanks to our computer crashing....  >:(

Please note: Cleaner's software was NOT at fault and when I had it up and running, it was bloody brilliant!

My guess is windows was and is the problem. I lost a lot of my data last year also. Even when it was working well I found I had to wipe and re install windows every six months as it would grind to a halt otherwise. I now use Ubuntu which never crashes, never slows down and is rock solid as well as being super fast. Best thing I ever did.

Joe H

Re: How do I Mail Merge?
« Reply #7 on: August 08, 2010, 03:48:50 pm »
Buy carpet cleaners software , add data , 5 clicks and you can print as many addresses as you have in your database, was really simple.

Been there done that lost all data twice thanks to our computer crashing....  >:(

Please note: Cleaner's software was NOT at fault and when I had it up and running, it was bloody brilliant!

but there is a backup faciluty in Cleaners Mate software, Colin. Save it to where you want. Its advantageous to have a usb memory stick to back up all the files you have created.

Colin Day

Re: How do I Mail Merge?
« Reply #8 on: August 08, 2010, 06:03:03 pm »
Buy carpet cleaners software , add data , 5 clicks and you can print as many addresses as you have in your database, was really simple.

Been there done that lost all data twice thanks to our computer crashing....  >:(

Please note: Cleaner's software was NOT at fault and when I had it up and running, it was bloody brilliant!

but there is a backup faciluty in Cleaners Mate software, Colin. Save it to where you want. Its advantageous to have a usb memory stick to back up all the files you have created.

I even bought an external hard drive and backed the files onto that and onto a USB pen after the first time I had lost every customer..... When I came to retrieve the files, my computer wouldn't allow them to be brought back up onto my computer ???

Bkalex

  • Posts: 5
Re: How do I Mail Merge?
« Reply #9 on: August 08, 2010, 06:24:07 pm »
Hello Colin,

heres a link which tells you how you can mail merge using excel.

http://wordprocessing.about.com/od/usingmailmerg1/l/blexcelmerge2.htm

I trust this helps,

Alex

Joe H

Re: How do I Mail Merge?
« Reply #10 on: August 08, 2010, 06:36:31 pm »
So the problem not with Cleaners mate but with the computer.
Get computer fixed and then you can use a decent bit of software.

Colin Day

Re: How do I Mail Merge?
« Reply #11 on: August 08, 2010, 09:27:32 pm »
So the problem not with Cleaners mate but with the computer.
Get computer fixed and then you can use a decent bit of software.

As stated above Joe, that is right.... Cleaner's Mate was not at fault!

Good computer's aren't cheap to us mortgage payers though Joe  :-\

dave123

  • Posts: 234
Re: How do I Mail Merge?
« Reply #12 on: August 09, 2010, 07:17:43 am »
Co;in .
 Put the cost of a new pc through your books then it's free ;D


Dave

dave123

  • Posts: 234
Re: How do I Mail Merge?
« Reply #13 on: August 09, 2010, 08:04:52 am »
By saying it's free I meant that it comes off your tax return .


Dave

Colin Day

Re: How do I Mail Merge?
« Reply #14 on: August 09, 2010, 08:19:48 am »
Think I'll invest in a good computer around Christmas time.... Then I can tell the wife it's a Christmas present for the kids ;D

Joe H

Re: How do I Mail Merge?
« Reply #15 on: August 09, 2010, 10:08:54 am »
Colin, computers powerful enough to do the work a business like ours does need not be an expensive one.
If you have any computer fayres about you could pick up a new box for under £200 which will be a good spec. If your monitor is ok then use it, if you have your operating system cd use it, attach your keyboard mouse and away you go. £200 - and set against business expense.

Its only if you doing high end graphics or playing high end games yo need to spend more money, and most kids have Wiis and Playstations for games anyway.

benny d

  • Posts: 706
Re: How do I Mail Merge?
« Reply #16 on: August 13, 2010, 07:13:43 pm »
Hi Col

Thanks for your help last week .We look like we will be getting a new porty shortly.
"If i'm not in action, I'm in traction"
Voted 397th best looking carpet cleaner in West Sussex 2015. Up 10 from last year...

Colin Day

Re: How do I Mail Merge?
« Reply #17 on: August 13, 2010, 07:32:15 pm »
Hi Col

Thanks for your help last week .We look like we will be getting a new porty shortly.

No problem, really enjoyed chatting!!!!