Killer macro idea for business mailings
One of you programmers should write a macro to validate a city from zip
code. I receive excel files from response cards and a lot of people will put
some random letters for their city instead of the actual city name, or maybe
they'll put the wrong abrieviation for their state. It would be awesome if
all the zipcodes could validate the state field and change if necessary and
the same for the city fields too.
Okay, have at it :)
Okay, well good idea I think anyways, but it turns out that my columns just
weren't wide enough so it didn't display more then 2 letters.
...e-mail doesn't leave
I am not new to outlook, but I don't know what to do. Recently, Outlook will
not send e-mails. I get a variety of messages, and essentially they say there
is an interuption and/or a problem with my isp.( error 0x80042109) My isp is
comcast and they only service outlook express; they suggest calling MS and MS
wants money. I refuse to pay for help with outlook: A few years ago I was at
a MS tech meeting(as a biz user) and a man got up to speak. He said more
people have cursed his name than anyother person on earth. He was a
co-developer of Outlook.
I also recently downloaded IE7 and ...send the same e-mail with one or two fields changed.......
I would like to send the same e-mail to many differnet people with
one or two fields changed (for example the name of recipient and the
date).How canthis be done?? I would also like to be able to save the
e-mail and use it again and again.
can anyone help
If you have Word installed and it's the same version as Outlook (both 2003,
for example), you can do a mail merge between the two. This would allow you
to set up the text the way you want it to, and you can save the document for
future use. Look at the following page for further information:
I have some questions :
1. I have some custom reports, for example report A, B and C. But why there
are some user CRM who can not view the custom reports, although they are CRM
user and they are member of SQLReportingGroup in active directory.
2. Why there're some user that not automatically include of
SQLReportingGroup member, although they are member of active directory &
registered as user in Ms CRM?
Thx before ^_^
...Using rules wizard to send to a list of emails addys in BCC
i need to setup an automatic mailing of a newsletter that
i receive, to be forwarded to a list of emails addresses,
where the emails are inserted into the BCC line, and not
the TO line.
I do not want my clients to see each other's emails.
No, natively you can't. Even when you use a template to reply with and fill
in the BCC field it won't work. It is even worse this way; the rule gets
But programmatically it is possible although not supported by Microsoft. For
Robert Sparnaaij [M...office 2000 [excel] cannot open previously OK file. Help
When trying to open a Microsoft Excel Work Sheet that I had accessed modified
and saved to only yesterday [Office 2000] a window pops up with:
"name.xls cannot be accessed. The file may be resd-only, or you may be
trying toaccess a read only location. Or, the server the document is stored
on may not be responding."
Older files stored on the same mediums ;HD, Flash memory or 3.5in. diskette
are accessed with no problem.
This is on a network drive?
...Excel and some disappeared sheets
Anybody has the same or similar experiences :
- I worked with excel file / closed as usually
- new day opened and unfortunatelly some very important sheets
disappeared / why ? Don=B4t know
- I had about 7-9 sheets just now only 3 ones are there but not so
important as another ones
- the file has original size / I quickly looked into file by normal
text editor only for reading
and all relevant data are there, however if I open file by Excel, NO
original sheets or data
- this file is VERY IMPORTANT for me
- why happened ? Don=B4t know since I ask anybody for help
Thanks in advan...Mysterious e-mails
i keep getting e-mails that look and appear that they have
come from people either in my phone book or in some cases
from people that have ligitimately e-mailed me or that I
In fact the e-mail has come from somewhere else even
though the sender appears to be ligitimate.
Most of these e-mails are dated 3 or four weeks old and
show that they have been read in my inbox.
I've asked a few people if they have forwarded the mail to
me but they havn't.
Most e-mails are selling Viagra or some other product.
??? any clue ???
Thanks in advance
You're being spammed. First...Cannot open Excel attachment from e-mail when Excel is already ope
This is driving me crazy. If I already have Excel open (with or with out a
spreadsheet open) I cannot open an Excel spreadsheet attached to an e-mail.
If I close Excel and retry it will open Excel and the spreadsheet.
Any ideas? I hate having to close all my open spreadsheets when I want to
open a spreadsheet that's been e-mailed to me!
One of these usually works with a similar problem starting workbooks by double
clicking them in Windows Explorer. Maybe one will work for you and your email
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close E...CRM Outlook Client Configuration Wizard Problem
CRM 4.0 - Microsoft Outlook Client
We've Microsoft CRM 4.0 Server roll up 8 as well as CRM Outlook Client on
the same roll up version. Our Internal Web Access works without problems
users get to it and they're automatically authenticated. IFD Development is
the same way except they're prompt through a login page for their username
and password when they're coming from an external network.
Ever since we moved to a new facility users are experiencing problems
connecting to CRM using their outlook client, I have a test machine where I
have the CRM Outlook Client ins...Mail will not Send/Receive automatically
I have outlook set up to send/receive every minute but it suddenly stopped
doing so. Anyone have ideas why?
Several. For starters, a one minute polling interval is just nuts.
It is difficult to determine why automatic polling is failing when you do
not post your mail account type, connection type and polling settings. If
automatic polling once worked and now fails, you also need to examine what
changes were made to your setup before automatic polling stopped working.
In general, here are the reasons automatic polling might fail in Outlook:
1. You have created an unrealistic po...Outlook Mail via a PROXY SERVER?
If I am using a shared Internet service on a second computer using a PROXY
server on the host (first) computer. I can access the net using the PROXY
settings on the Internet explorer. However, how do I download mail with
OUTLOOK 2000? The proxy server is CCPROXY from YoungZSoft (this runs on XP)
and it has the MAIL Settings enabled but the difficulty is what to do on the
That would be determined by the proxy manufacturer - check with their
> If I am using a shared Internet service on a second computer ...Mail enabled public folders / spam
For each of my users inbox I have exchange mark mail with the SCL and move
anything over my threshold into their junk mail folder. This works pretty
well and eliminates nearly all of the spam we get.
I have not thus far managed to work out how to get this working for mail
enabled public folders. How can I set this up (perhaps nominating anotehr
folder as the 'junk mail' folder) or something similar?
...OL2002 Problem : HELP, SOS, MAYDAY
I have an IMAP account and OL2002 as client.
I have checked for my account ( tools, send/receive
settings, define send/receive groups, <my_account>,
edit) download item description only.
It works only the first time I start OL2002, but it does
not work anymore for subsequent automatic/manual
Please could someone really help me ?
Thank you in advance,
...Using Company Wide Mail Templates.
I do not know if i am at the right spot here, or if it is evne possible, but
i got the following question.
My boss would like me to make sure that every outgoing mail has the same
looks. It starts by adding a signature that is the same for everyone, except
with ofcourse personalized information. This was easily done by giving
everyone a signature.
The next question is however, to put the head of our website, also above our
mail. This means that every user that sends a mail, the mail will have a nice
header, underneath that header, the mail is typed, and then its ended with
the si...WLM Beta Junk Mail Filter
The junk mail filters has stopped filtering mail. The address shows in the
list of blocked addresses but the mail is not filtered. The filter worked
fine in WLM but I don't think it has worked since I loaded the Beta.
Where exactly are you looking when you say the address is the same as the one
in your Blocked Senders? The From line may not show the true entry, look at the
entry in the From field you see after pressing Ctrl+F3 on that message.
Gary VanderMolen, Microsoft MVP (Mail)
"DickW2" wrote in message news:O7$LTHNMLHA.4084@TK2MSFTNGP05.phx.gbl...
T...Help With Margin Formula
I need help with a margin forumla (calculated from retail). Say I have a
cost of $10.00, and I need the formula to calculate a 40% margin from
retail. So the retail should end up at $16.67. Not sure how to get from
$10.00 to $16.66, I just know the cost and the margin I need to make.
"JR" <firstname.lastname@example.org> wrote in message
> I need help with a margin forumla (calculated from retail). Say I have a
> cost of $10.00, and I need the formul...GETPIVOTDATA data_field help
When I enter a reference to a cell, eg A2, as the value for the data_field item in the GETPIVOTDATA I get a #REF error. However, when I instead type the value of A2, eg 2003, manually into the GETPIVOTDATA formula, it works. Can anyone please help--I want this formula to vary based on what is in A2.
This function is so variable in action, and difficult to handle, that
have given it up in favour of VLOOKUP. In fact, having no problem i
use with pivot tables
Message posted from http://www.ExcelForum.com
Try copying the headings from the pivot table, and pasting them into the
ce...Exchange server crashed, please help....! Need to restore two priv.edb and pub.edb files into one....!
I was wondering if I could get some help with the following problem we are
having on our company.
Here is the scenario; Our Windows NT 4.0 SP4a server running Exchange 5.5
SP4 crashed (Server 1) due to the exchange database reaching its 16 Gig's
max limit. I went ahead and moved some mailboxes' e-mails to a few .pst
files in order to make some space. This worked ok. Then, I decided to build
another exchange server (Server 2) to moved some mailboxes and alleviate the
load. Once the server was ready and configured as part of the current
exchange site, I went ahead and move...Mail Merge to business cards
I am working on a huge project for work, creating Employee Photo ID cards. I
have created a database for all the information including a hyperlink column
for the photos. and am using business cards to print them on. I have two
1. The pictures aren't loading into the cards.
2. I continue to get the error message "Publisher cannont merge with this
number of pages" even though I have followed the instructions for the
Any suggestions? Thanks
I am running Exchange 5.5 on NT 4.0 sp6a. Norton Anti-
virus deleted my edb.log file. I have done an on-line
restore with Arcserve 2000 and now my directory service
won't start. getting 1166 internal processing error. I
have been to support and could find anything that helped.
Thanks in advance
You may want to run eseutil /mh <drive and path to your dir.edb and
include the dir.edb > c:\edb.dmp. Find this file and see if your dir is
also inconsistent. If so you will need to restore your dir.
Nan Bennett (MSFT)
Microsoft Exchange Support
Please do not send e-mail...Setting Defaults in New Item Wizard
How can I set a default value in the New Item Wizard? I want to always use a
barcode type that is about 10 down from the top and I want Taxable Item to
always be checked. Help...
Good question, I need an answer too.
"A StanTech Associate" wrote:
> How can I set a default value in the New Item Wizard? I want to always use a
> barcode type that is about 10 down from the top and I want Taxable Item to
> always be checked. Help...
You can set the default sales tax under Manager, File, Configuration, Sales
Tax, Default item tax group.
To set a default barcode type yo...Removing text from cells leaving numbers (help with function)
I need a function that will remove all text from a cell and just leav
numbers. Formatting cells to number does not work.
For example if I have:
(Sired] Tennessee 37013 (herein
I just want 37013 left.
Anybody know a function to resolve this
Message posted from http://www.ExcelForum.com
The following will strip the text from the active cell and place the number
in the adjcent cell one column to the left. If there are subsequent numbers
in the original string you will get erroneous results. Put the cursor on the
cell to be processed and run the macro.
********************************...Mail merge from excel
I am trying to merge a list of names from excel into publisher. When using
the mail merge wizard it wont let me load the names all it says is f1 and f2.
what am I doing wrong? any help is greatly appreciated.
...Auto Delete the e-mail
We are using Microsoft Exchange 2003 and Outlook 2003. One mail box calls
"Sales", i configured the achieve function for this mail box, this function
will automatically delete mail if the mail is order than 7 days. But this
function is not running if the outlook closed, is it possible this function
running on server only, no need to open Microsoft Outlook for running the
achieve function in client PC ?
Philip Tsang <email@example.com> typed:
> Hi all
> We are using Microsoft Exchange 2003...