Excel Delete Duplicates Between Tables

Table 1 – Original
Table 2 – Bounce List from VoilaNorbert

In Table 2 note the cell range ie.A2 to A998
Highlight emails in Table 1 (click on first, hold Ctrl, and click on last)
Conditional Formatting –> New Rule –> Use a formula to determine which cells to format

=countif(‘Table 2’!$A$2:$A$998,A2)>0
Format –> Fill –>choose a color –> ok –> ok

Note:
Replace above table names with whatever you have named your tables
May need to go in and fix rule is not showing properly
On Table 1 click Conditional Formatting –> Manage Rules
Make sure the formula is typed in correctly

Next, Sort so the highlighted or clear cells are on top
Sort & Filter –> Custom Sort –> Sort By A or Email Addresses (let excel expand the filter so all rows are moved together) –> Cell Color –> No Color or Choose a color to be on top
This way you can delete all the duplicates easily once they are grouped together.

Captcha

Register Domain at Google. https://contactform7.com/recaptcha/

Using Contact 7 form on WordPress, goto integration and enter the site key & secret key you created above.

Done!

Responsive Tables

<style type=”text/css”>
table {
border: 1px solid #ccc;
border-collapse: collapse;
margin: 0;
padding: 0;
table-layout: fixed;
width: 100%;
}

table tr {
background-color: #f8f8f8;
border: 1px solid #ddd;
padding: .35em;
}

table th,
table td {
padding: .625em;
text-align: center;
}


@media screen and (max-width: 800px) {
table thead {
border: none;
clip: rect(0 0 0 0);
height: 1px;
margin: -1px;
overflow: hidden;
padding: 0;
position: absolute;
width: 1px;
}

table tr {
border-bottom: 3px solid #ddd;
display: block;
}

table td {
border-bottom: 1px solid #ddd;
display: block;
text-align: right;
}

table td::before {
content: attr(data-label);
float: left;
}
}
</style>

Next the table (you only have to add percentages if you want and only to the thead – it will carry through)

<caption>
Enter Caption
</caption>
<thead>
<tr>
<th scope=”col” width=”10%”> </th>
<th scope=”col” width=”10%”>Price</th>
<th scope=”col” width=”17%”>Bed/Bath</th>
<th scope=”col” width=”17%”>SqFt</th>
<th scope=”col” width=”29%”>Address</th>
<th scope=”col” width=”17%”>MLS</th>
</tr>
</thead>

And you can add labels if you wish:

<td data-label=””>

Moving an Old Contact Database to MailChimp or ConstantContacts?

Uploading your contacts from your computer or company database can be problematic. Depending on how long you have been adding contacts to your database there is a good chance a high percentage of your emails are no long valid. This will cause a high bounce rate and could get your suspended from the bulk email giants.

It’s a good idea to have a 3rd party clean your list before uploading it for use. The company I choose, with great reviews, was Voilanorbert.com Their pricing was very reasonable and found that 35% of my list had invalid email addresses 39% were risky and only 25% were clean, usable email addresses. Mind you, this list went back over 15 years. For checking ~1400 email addresses the cost was $4. Very reasonable. I could have paid an additional $50 and they would have filled in my list with missing names, titles, companies, addresses & phone number.

Create and Use HTML Template in Outlook

Create New Message

Click New Message Button
Format Text > as HTML
Create your message using fonts & inserting graphics

File > Save as > type > Outlook Template

Use Created Template

Click New Item
More Items > Choose Form > Look in Use Template in File System
Choose .oft that you created above

Add Contact Form to WordPress

In Plugins Search for New – Contact Form
Choose Contact Form 7 by Tokayuki
Install > Activate > Settings
Click on Contact Form 1
Update Tabs

Mail

Check the TO field and make sure the auto-fill correctly filled the email that you wish to receive these submissions.

Also check the FROM – if it entered an email that does not exist, go to the CPanel control panel and under “mail” either add that email (or one you prefer) OR under “mail” choose forwards and create a forward to one of existing email accounts if you don’t to have a new account to check

Place on website

Look towards the top of the page and copy the shortcut code.
Click “save”
Then goto your contact page & add paste this code in your page using the “html” view

Welcome!

Thank you for visiting Doss Designs.

We offer a wide range of services. If you do not see a category in the top menu that fits your interest, please email your question to mary@dossdesigns.com and I will personally respond – normally within 24 hours.

Feel free to browse our blog full of helpful information about many different CMS platforms and marketing suggestions.

One Computer Can’t See The Other

Your computer appears to be correctly configured, but the device or resource (DNS server) is not responding

Fix 1

Rt click on windows –> Control Panel –> Network & Internet –> Network & Sharing Center –> click connection

Internet –> Properties

Internet Protocol Version 4 (TCP/IPv4) –> Properties
– Choose Obtain an IP address automatically
– Choose Obtain DNS server address automatically
OK
Internet Protocol Version 6 (TCP/IPv6) –> Properties
– Choose Obtain an IP address automatically
– Choose Obtain DNS server address automatically
OK

Fix 2

Rt click on windows –> command –> Run as Administrator
Enter
ipconfig /flushdns
ipconfig /registerdns
netsh winsock reset
netsh int ip reset
ipconfig /renew
Restart your computer

OR

netsh int ip reset
ipconfig /flushdns
net stop dnscache
net start dnscache