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:
http://www.slipstick.com/con...How do I create a sample in Excel?
I am trying to create a sample, needing every 20th record out of around 3000
You need a VBA procedure.
Dim RowNdx As Long
Dim DestRng As Range
Set DestRng = Worksheets("Sheet2").Range("A1")
For RowNdx = 1 To 3000 Step 20
Set DestRng = DestRng(2, 1)
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Mary" <Mary@discussions.microsoft.com> wrote in message
news:ADE0AD7F-B459-41AE-8B2...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.
...Computer freezes when printing mail merge in Publisher
When I use mail merge in Publisher, I can only print about 10 of the contacts
at a time or Publisher freezes. It doesn't seem to matter how large or small
the file size is either. The problem started when I got a new laptop. I
didn't have this problem on my old one, so I'm thinking it has to be a
setting somewhere. Thanks for any advice.
Hi r2knutso (email@example.com),
in the newsgroups
|| When I use mail merge in Publisher, I can only print about 10 of the
|| contacts at a time or Publisher freezes. It doesn't seem to matter
|| how larg...Email with no address, subject or content
Please bear with me if this subject has been covered ad nauseum, but I
frequently receive email with no "From:" address, no subject and no
apparent content. I'm running Outlook 2002. Can anyone tell me what's
going on here? Is it an attempt to plant a Web bug? Regardless, I
would like to create a rule that automatically dumps such mail in my
spam folder. Using the rules wizard I see how to redirect email from a
specific address, but leaving the address field blank doesn't work.
Thanks in advance for any help.
...How do I change the name of Access 2007 Database?
Unable to rename or delete Access 2007 databases created for practise. Can
On Nov 22, 3:56 pm, leroyd <ler...@discussions.microsoft.com> wrote:
> Unable to rename or delete Access 2007 databases created for practise. Can
> anyone help?
What is the error message you are getting?
> On Nov 22, 3:56 pm, leroyd <ler...@discussions.microsoft.com> wrote:
> > Unable to rename or delete Access 2007 databases created for practise. Can
> > anyone help?
> What is the error message you are getting?
> navi...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...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...Can't create Organizational Forms Library in Exchange 2003 with SP
I cannot create an Organizational Form in EFORMS REGISTRY folder (from First
Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When
I right-click the EFORMS REGISTRY folder and select New, there is no
Organization Form. Instead, I only see Public Folder in the popup menu. Do
you have any idea why Organizational Form menu does not show?
My Exchange Server is Exchange 2003 with SP2. The login user is Administrator.
Could you please help me? Thank you very much.
Is that account member of "Enterprise Admins" group?
Yang Zhang wrote:
&...Lost Outlook contacts
I recently backed up my hard drive on DVD, then also kept
the entire contents to another HD. I then reformated my C;
drive, and reinstalled all of my programs.
When I searched for my outlook info, I could only find
backups I had specifically made for export (These are .PST
files). Where was Outlook storing all of this information
before, and have I lost it all? I hadn't made a backup for
a few months, but all of the info was there each time I
opened the program.
I recently had to reinstall my OS and drivers on a new
hard drive. I have access to my old drive and my data is ...Outlook 2007 addresses
How can I find the list of addresses I have sent emails to? When you start a
new email you can put a letter in the To line and list will come up. Where
is that list? How can I print it out?
that is the autocomplete cache. You would need a utility to print it out.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Out...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...Using Outlook with a mobile phone
I wonder if anyone can advise me if it is possible to set up Outlook for use
with a mobile phone. The situation is that I currently have a laptop which
id bluetooth enabled and I can connect it to my iSP to collect emails when I
am out of the office. However as it turns out this is only part of the
solution, as I frequently get emails which contain attachments such as
spreadsheets when I connect via the mobile at 9.something KPS it takes ages
(too long) to pick up my emails.
I have an IPaq with the pocket pc version of outlook on it and that enables
it to truncate the messages, which is to ...Field Service Calls and Invoices
We use the Service Call modules for repairs in our Stores and have a
situation that I'm trying to find a workaround. We have situations where our
technicians will pick-up items without prior notification to our dispatchers.
All of a sudden we get an invoice and currently we have to track down the
charge and then we are forcing a PO into the system from the Service Call in
order to properly receive and enter the invoice.
Does anyone have other ways to do this and track the information/cost on the
Service Call without needing to create a PO after the fact.
This is not an applicat...How do I create a click on + symbol to open a root and click on -.
I'm looking to create an excel file with drop down menus.
I'd like to have a category. Click on the "+" symbol and the category opens
up and shows all of the subcategories.
Each category can further be opened if I so choose.
Each category can be have a number total associated with it.
When you click the "-" symbol. The subcategories close and the sum total of
all subcategories is shown in the category total.
example. creating a budget.
Category is utilities
sub categories are: phone, cable, electric, gas, etc...
Monthly utility total ...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?
...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...How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the
current form field. This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
gxCurrentField = Me.ActiveControl.Name
However it doesn't work properly when changing records in a subform.
My parent form contains two subforms in a many-to-many relationship.
The above variable usually ends up containing the name of the first
field in the second subform when switching records in the first
How to correctly code this? Or is there some native variable I'm not
aware of? I...Exporting contacts in a csv file
I am a mysterious problem exporting my contacts as csv file. The
resulting file has only 58 contacts out of almost 1200 contacts in my
outlook. These contacts appear to be the last 58 contacts added. (I
say appear because the attribute "createdon" is not exported so I
can't be exact. Why is this?
cinnamngrl <firstname.lastname@example.org> wrote:
> I am a mysterious problem exporting my contacts as csv file. The
> resulting file has only 58 contacts out of almost 1200 contacts in my
> outlook. These contacts appear to be the last 58 contacts added. (I
> say appea...how create Quota filter in WIndows 2003 R2 using Script
I need create quota filter in Server 2003 R2 using vbscript. quota
filter should be applied to directories and not by users.
I searched information about it on google without success.
thank's in advance
First you need open your FSRM (File Server Resource Manager), then you
create a quota template, you must specify if your quota is "software" (just
monitoring, but never deny the user) or "hardaware" (deny users when they
use 100% of the quota), you must specify if you want send e-mail to user
when this user use...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...creating a spredsheet and log the info into another spredsheet
I have a excel sheet that is printed out and a cashier manual enters
information, invoice number, invoice amount, cash amount, check
amount, amex amount.... I would like to have the cashier input this
information on her PC and print a copy to go along with the deposit
and at the same time log the information into a google excel document
I created. Any ideas how this can be done?
...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...Creating Exchange 2003 organization
Is it possible to have two Exchange Organizations in the same domain? I need
to reproduce a problem and was hoping to install an Exchange server to an
existing domain however I need the organization to be different. Is this
possible? When I installed EX 2003 I wasn't prompted for information other
than location of files.
Thanks in advance
On Mon, 28 Feb 2005 08:09:03 -0800, "RP"
>Is it possible to have two Exchange Organizations in the same domain? I need
>to reproduce a problem and was hoping to install an Exchange server...