Filemaker List of Emails Separated by Commas in a Global Text Field

I am using FileMaker Pro 11 and it has basic email functions. The major problem with the email function in FileMaker is it lacks any accounting of when and if the email was sent. Also, after closing and opening Filemaker, you have to re-enter the SMTP server again. A real pain.

So the best way is to use your own email program. When I use FileMaker, I usually want to send an email to multiple clients from the found set of records. The format the email programs use is emails separated by a semicolons.

The following solution will create a list of emails in your found set of records, separated by semicolons and copy to your clipboard using a FileMaker script so that you just have to paste the emails from the clipboard into the BCC box of your email.



Create a new global text field by going to File>Manage>Database..., call it Email List, click on tab Storage and check the box Use Global Storage, click OK, OK

Create Script in Filemaker

Script Name: List Emails

Go to Record/Request/Page [First]
Clear [Select; YourFMDatabaseFile::Email List]
Loop
   Set Field [YourFMDatabaseFile::Email List & YourFMDatabaseFile::YourEmailField & "; "]
   Go to Record/Request/Page [Next; Exit after last]
End Loop
Copy [Select; YourFMDatabaseFile::Email List]

Save

Find the set of records you would like to email. Run the script List Emails (or create a button that runs the script). Open your email program, open a BCC, paste the emails from the clipboard. Done.



YourFMDatabaseFile = Your FileMaker database file name
Email List = The global text field that was created in these instructions
YourEmailField = The name of your text field in your database with the emails
List Emails = The script that was created in these instructions

Source: http://fmforums.com/forum/topic/35357-display-a-comma-separated-list/

Re-Enable Firefox Dialog Box to Save Tabs on Quit

On the new Firefox versions starting with 4.0, the dialog box to save the last set of browser tabs when you quit Firefox has been removed. You will need to configure Firefox to get the dialog box back.

1. In the address bar of Firefox, type, about:config

2. Click "I'll be careful, I promise!"

3. In the filter bar, start typing, browser:showQuitWarning, click on it or hit enter

4. Right click on "false" and select Toggle, it will become true.

5. You are done, no need to restart Firefox.

6. A dialog will appear asking if you want to save the last set of tabs when you quit Firefox.

How to Edit Text in a PDF with Acrobat Pro

If you are missing the font in a PDF, here are the video instructions to change the font and text. Basically, go to Advanced Text Selection, highlight the text, right click the highlighted text, select properties, change the font and make sure to click on embed before approving.

http://acrobatusers.com/tutorials/how-to-edit-text-in-a-pdf

Enable One Button Scanning From Brother MFC 7820n

The solution can be found at the Brother website for Windows XP to 7. It involves changing the Windows Firewall settings to open a port for incoming 7820n scan saves to the designated computer.

http://welcome.solutions.brother.com/BSC/public/us/ca/en/faq/faq/000000/002500/000097/faq002597_000.html?reg=us&c=ca&lang=en&prod=mfc7820n_all#step2sp2

Reset Laptop Wireless Radio To 802.11n

My 802.11n wireless laptop seemed sluggish when transferring files. I looked at the status of the connection and it was pegged at 54 Mbps which is the maximum throughput for 802.11g and no matter what I did with the laptop radio settings and the wireless router settings, it was stuck on 802.11g.

One note, since my cable internet connection gets up to 30 Mbps, having G does not affect my internet browsing, of course, unless there are several other wireless G connections browsing at the same time. So really, having N is only important when transferring files between computers on a home network, particularly during media streaming.

One other note, to achieve 802.11n maximum throughput of 300 Mbps, authentication settings have to be WPA or better. Specifically, WEP authentication limits throughput to 54 Mbps.

To reset the wireless N laptop connection stuck on 802,11g:

1. Start>Control Panel>Network and Sharing Center (Windows 7)
2. Click on Wireless Network Connection
3. Click on Wireless Properties
4. Click on the Security tab
5. Change Security Type to No Authentication (open). The authentication will reset and you will lose your connection.
6. Reconnect back to your wireless SSID and enter your password.

Checking the Status of your connection should reveal faster throughput to 802.11n.

Windows 7 Remote Desktop Reset To Full Screen

I often have Windows Remote Desktop (RDP) open to another computer and minimize it in the background. Since playing Starcraft II where the screen resolution changes, the RDP session reverts down to a lower resolution and is then enclosed in a window with scroll bars. It loses the original fullscreen appearance. There are several ways to resolve this.

1. A tedious but logical solution would be to close the RDP session, open the RDP application, click on Options, click on the Display tab and drag the Display Configuration back to Fullscreen. Then Connect.

2. The more elegant nonexistent Windows manual solution: While in the RDP session that has been downgraded from fullscreen, type Ctrl+Alt+Break.

3. What if your computer is a laptop without the Break key? Try Ctrl+Alt+Fn+End or Ctrl+Alt+Fn+Pause, where Fn=Function key.

Clean Install a Windows 7 Upgrade

You can clean install from Windows 7 Upgrade software. You don't need to pay for a full version, especially if you already paid for Windows XP.

My approach was to install into a faster and larger SATA hard drive, specifically a Seagate 1.0 T drive and leave my XP system in my old drive intact.

I went into BIOS and configured it to boot from my NEC DVD/CD drive first, after placing my Windows 7 Home Premium Upgrade disk into the drive. The Windows 7 install loaded, and I chose my new drive as the destination for the new Operating System install.

I did not immediately put in my serial and activate the software during the install process to be safe, but I think it would have probably been OK since the Install Software did detect that my old drive had an OS System in it.

After installation has completed, update everything through Windows Update and then Activate it by right clicking on Computer and choosing Properties.


http://www.winsupersite.com/win7/clean_install_upgrade_media.asp