- #HOW TO PULL MAILING LISTS FOR FREE SOFTWARE#
- #HOW TO PULL MAILING LISTS FOR FREE CODE#
- #HOW TO PULL MAILING LISTS FOR FREE PLUS#
The first is when a family is sometimes only using the husbands name (e.g. There are two flaws in this method – that’s why it’s only quick and dirty. If that’s the case, the message DOUBLE! will appear: IF(C3=C2 ”DOUBLE!” ””). Which is quite easy, if you know how: check if the last name in cell C3 is the same as in cell C2. Now that we have sorted the addresses, we will add another formula to check for doubles. That’s the reason why you should only use that one in this exercise. The unique identifier is the postal code, not the place. You can use both Deurne and Antwerp in my address, no problem.
#HOW TO PULL MAILING LISTS FOR FREE CODE#
living in Deurne, which is a suburb of Antwerp, the postal code is 2100. There is a reason why you should only use the postal code for this sorting and not the place: in some cases, different place names can be used for the same postal code. And we are doing this first by postal code, then by address and then by the last name. To check for doubles, we are first going to sort the Excel sheet with mailing addresses.
#HOW TO PULL MAILING LISTS FOR FREE PLUS#
Especially if you are mailing physical pieces: there is the production cost, plus postage cost. After that, first the message (“”, which is an empty string) is shown when the condition is true, the second message (“CHANGED!”) is shown when the condition is false.Ī very costly error in mailing lists is double entries. The ‘IF’ argument indicates that we want to check a certain condition: if cells B2 and C2 are exact the same, including the case. There is also an easy way to check it, via the following formula, where the original values are in the B-column and the ‘proper’ values in column C: =IF(EXACT(B2 C2) ”” ”CHANGED!”) The formula consists of different parts. If the formula above made changes, you probably want to know which names have changed, so that you can also correct them in your database, your CRM system. In these cases, manually checking it wouldn’t be a bad idea.
E.g., the last name of the queen of Belgium is d’Udekem d’Acoz. And certainly the ones with a lowercase ‘d’ are sensitive to it: they are usually a sign of nobility. In the region where I live, some last names have a lowercase d (d’, de or du) or a lowercase v (van or von). And you need to be careful, especially in some parts of the world. Using this function in Excel is, of course, a ‘quick and dirty’ way of doing this.
And then you extend that formula to the rest of the column (you can do that by grabbing the ‘+’ sign at the right bottom border of the cell and dragging that to the last cell you need). Suppose all the names are in the B column, with B1 being the column title, you go to cell C2 and use the following formula: =PROPER(B2). If you have a mailing list exported to Excel, you can easily transform a column with names. So ‘proper’ would transform EDDY HAGEN into Eddy Hagen. ‘Upper’ will transform all the letters into uppercase, ‘lower’ into lowercase and ‘proper’ will give every word a first capital letter. Well, Excel has the following functions: UPPER, LOWER, PROPER. Let’s start with an easy one: how can you – automatically – adjust the use of uppercase/lowercase in Microsoft Excel. They could, and should, have been prevented from happening. And all of these mistakes are very annoying. And the same company often shouts at me in their emailings: ‘EDDY, now is the right time!’. And one brochure was addressed to miss Eddy Hagen (I checked it before starting writing this blog post and I’m definitely male! ? ). And I got a ‘last chance’ invitation for a seminar that I already had attended a few weeks ago… And if I look a bit further back, I’ve received two pieces of the same mailer, on several occasions.
#HOW TO PULL MAILING LISTS FOR FREE SOFTWARE#
I got one for a very special promotion for a software upgrade, which I had already purchased from their website about a month ago. Just to give you an idea how often I see errors in mailing lists: the past week I got a mailing in the wrong language (in French instead of Dutch). Let me show you how.ĬONTENTS: Uppercase, lowercase, proper case | Doubles | Language dependent | Let’s get serious… | The G-word… | Why is this important? For some common errors in mailing lists, a few simple tricks in Microsoft Excel can already help you. Two mailing pieces at the same moment, wrong use of capitals, wrong language, even assigning me the wrong gender. And I know: I see them on a regular basis. And it’s definitely reflecting on the brand image of the sender: errors in mailing lists. Especially when you are on the receiving side.
0 kommentar(er)
