-
WSkarniem
AskWoody LoungerA big thank you to Gfamily The formula =LEFT(A1,LEN(A1)-4) works perfectly as all of our user IDs have the four digits at the end.
We, too, had thought of =Right(a1,4) and similar things, but they, of course gave us just the numbers.
Thank you all for your responses. I’ve used this lounge for several years now, and have never failed to get help when needed. You are all much appreciated!
Karnie
-
WSkarniem
AskWoody LoungerThanks for the information, Joe, but I couldn’t make it work. The instructions say:
You can distribute a vCard file as you distribute any other computer file. To do this:
1. Open a new message and address it to the recipient.
2. On the Insert menu, click File.
3. Click to select a vCard (.vcf) file, and then click OK.
NOTE: If you want to include Notes with your vCard, you must insert the .vcf file. If the .vcf is attached to your signature, the Notes field (and other fields) are removed prior from the vCard.
The problem is, when I go to the Insert, File dialog box, there is no .vcf option in the files of type area. I did try Insert, Item and was able to insert a contact that way. The notes came with it here in the office, but I’ll need to send it to someone else that way and see if they go with it then.
Thanks again for the suggestion.
Karnie -
WSkarniem
AskWoody LoungerI had read something about that, too, which is why I can’t understand why one of us got the notes field and the other didn’t. Oh, well. “By design…” or broken. Apparently, we cannot expect it to work. Thank you, Hans.
-
WSkarniem
AskWoody LoungerThank you, Hans. That at least gives us some places to check. We all really appreciate your contributions.
-
WSkarniem
AskWoody LoungerI’ve forwarded it to our Help Desk person, and am waiting for her response. Thanks for the suggestion. I’ll let you know if it works.
-
WSkarniem
AskWoody LoungerJanuary 30, 2006 at 6:26 pm in reply to: Insert leading 0 between text and numbers in a col (Excel 2003 sp1) #997377Thank you, thank you, both of you. That did it. I do love this lounge.
-
WSkarniem
AskWoody LoungerJanuary 30, 2006 at 4:56 pm in reply to: Insert leading 0 between text and numbers in a col (Excel 2003 sp1) #997355Hans,
Thanks for the quick response. I’m apparently doing something wrong. My data starts in A4 with BWC00001, so in the new column B I entered =”BWC0″ & RIGHT(A4,6) – I tried both with and without spaces between the ” and & and the & and RIGHT. The result I get is BWC0C00001. In other words, I have a 0 C instead of just an additional 0. What am I doing wrong?
-
WSkarniem
AskWoody LoungerThank you, Jerry. That’s exactly what we’re testing right now. I appreciate the suggestion.
-
WSkarniem
AskWoody LoungerJefferson,
Please don’t spend anymore time working on it. We’ve located another method using a customized Outlook.hol file, and will give that to our 2003 users. Possibly also to our OL2000 users, but not unless I’m confident that the .hol file hasn’t changed between releases. I may use the Transmit Holidays download for them. It really worked well – on 2000, apparently.
Thank you for taking time to work on this with me. I do appreciate it.
-
WSkarniem
AskWoody LoungerAre you thinking of security restrictions within Outlook itself? Could you suggest something we might look at? I don’t understand why, in some instances it sends the “list” of dates with % symbols separating fields, and in others presents the correct form with the non-functioning button to add the holidays. I do appreciate the fact that you thought of that – without having seen the program.
Additional note: I’ve learned that the program works fine for our users who are still on Windows 2000, and Outlook 2000. If the program runs a macro, could OL 2003 be stopping the program from running on other users machines, even though it ran fine on mine? If that’s the case, is there anyway to make the macro “safe” within our firm?
Thank you.
-
WSkarniem
AskWoody LoungerSeptember 2, 2005 at 5:41 pm in reply to: Displaying reminders ‘always on top’ (Outlook 2003 – SP1) #970617Thanks for the quick response. Not what the user wanted, but I pointed her to the reminder sound option. Too bad it doesn’t have the 10-second Australian option available. I suspect that wouldn’t only make dogs take notice . . .! Thanks again.
-
WSkarniem
AskWoody LoungerEdited by HansV to provide link. Simplest method: select [Post: 499,066] in the header of the post with the mouse, use Ctrl+C to copy it to the clipboard, then use Ctrl+V to paste it into yopur reply. It will automatically be converted to post 499,066.
I don’t know if it will help or not, but perhaps what we figured out in post 499,066 might be useful. I’m sorry – I don’t know how to create a link to it.
-
WSkarniem
AskWoody LoungerJuly 14, 2005 at 5:51 pm in reply to: Contacts and Word Mail Merge (Outlook 2003 / Word 2003) #959954We figured out how to correct it – at least, we think we did. In case anyone else runs into the issue, here’s the process we used on our system:
In Outlook 2003 go to Tools –> E-mail Accounts –> View or change existing e-mail accounts –> Next
Select Microsoft Exchange Server and click Change –> More Settings –> Advanced tab and Remove offending mailbox (e.g. XXXX Administrator) –> OK –> Next –> FinishGo to Word, start the Mail Merge process, choose Outlook address book as source and be sure person’s own Contacts list appears. We created a test merge of labels and saved the document, just to be certain.
Go back to Outlook, repeat above instructions, but this time Add back in offending mailbox.
Test in Word again to be certain it’s still OK.
-
WSkarniem
AskWoody LoungerSeveral of us here tried it, and it stuck for us, too. Don’t know what’s different, but thank you all for your help. This is why I tell everyone about Woody’s Lounge. You’re all great!
Karnie -
WSkarniem
AskWoody LoungerI believe that the user in question had selected the Folder List, exited, and then opened Outlook again, and that it did not stick, but we’ll double check on that. Thank you for your help.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Outlook new and edge do not load
by
cHJARLES a pECKHAM
1 hour, 49 minutes ago -
Problem using exfat drives for backup
by
Danmc
2 hours, 8 minutes ago -
I hate that AI is on every computer we have!
by
1bumthumb
3 hours, 26 minutes ago -
Change Info in the Settings window
by
CWBillow
8 hours, 49 minutes ago -
Attestation readiness verifier for TPM reliability
by
Alex5723
15 hours, 12 minutes ago -
Windows Update says that “some settings are managed b your organization”
by
Ed Willers
57 minutes ago -
Use of Gmail rejected.
by
CBFPD-Chief115
1 hour, 37 minutes ago -
WuMgr operational questions
by
Tex265
2 hours, 16 minutes ago -
Beijing’s unprecedented half-marathon: Humans vs. humanoids!
by
Alex5723
1 day, 6 hours ago -
New Phishing Campaign Targeted at Mac Users
by
Alex5723
7 hours ago -
Backing up Google Calendar
by
CWBillow
1 day, 13 hours ago -
Windows 11 Insider Preview build 27818 released to Canary
by
joep517
2 days, 1 hour ago -
File Naming Conventions (including Folders)
by
Magic66
1 day ago -
Windows 11 Insider Preview Build 26100.3613 (24H2) released to Release Preview
by
joep517
2 days, 8 hours ago -
Microsoft sends emails to Windows 10 users about EOS
by
Alex5723
1 day, 19 hours ago -
Outlook 2024 importing Calendar and Contacts – FAILURE
by
Kathy Stevens
1 day, 1 hour ago -
Adding Microsoft Account.
by
DaveBRenn
2 days, 10 hours ago -
Windows 11 Insider Preview build 26120.3576 released to DEV and BETA
by
joep517
3 days, 9 hours ago -
Windows 11 Insider Preview Build 22635.5090 (23H2) released to BETA
by
joep517
3 days, 10 hours ago -
Windows 11 won’t boot
by
goducks25
1 day, 2 hours ago -
Choosing virtual machine product for Windows on Mac
by
peterb
3 days ago -
Rest in Peace
by
Roy Lasris
4 days, 4 hours ago -
CISA : Install Windows March 2025 Updates until April 1 or shut down PC.
by
Alex5723
1 day, 2 hours ago -
Google proposes users with incompatible Win 11 PCs to migrate to ChromeOS Flex
by
Alex5723
4 days, 5 hours ago -
Drivers for Epson Perfection V600 Photo – scanner
by
Bookman
20 hours, 36 minutes ago -
Long Time Member
by
jackpet
4 days, 7 hours ago -
Woody Leonhard (1951–2025)
by
Will Fastie
1 hour, 36 minutes ago -
What I learned from Woody Leonhard
by
B. Livingston
4 days, 1 hour ago -
Windows Settings today
by
Simon Bisson
3 hours, 27 minutes ago -
Mail Merge magic in Microsoft Word
by
Peter Deegan
1 day, 14 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.