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...Paragraph formating jumps to defaults.
We are using Office/Outlook 2007
We have an email signature script that is run when users login, it´s working
ok except for two things;
If the default paragraph settings in Word 2007 for a user matches those in
the signature script, the signature will use the "Base defaults" of Word
2007, that is SpaceAfter = 10 and LineSpacing = "Multiple" with a value of
So if I change the script to use SpaceAfter=0 and the user has set his/her
Word 2007 to use SpaceAfter=0, the result will be SpaceAfter=10.
If the script is set to SpaceAfter=0 and the us...Proper Table(s) Layout
I have created a couple of Dbs which the table structure seemed to simply
fall into place, it was just logical in my head.
That said, I am working on a new db and for some reason I am doubting myself
and wanted a second opinion.
The db is basically a contract db to input all the info, and there is a lot
of info, for each contract. Where I am 'lost' is the fact that the contracts
are broken into categories: clients, components,engineering, warantee... For
all of the components (with the exception of clients) there are a number of
fields but only 1 entry per contract....Where is the lasso feature in 2008? (was in formatting palette in 2004)
Operating System: Mac OS X 10.5 (Leopard)
Hi, <br><br>In Excel 2004 in the formatting palette in image, there are different selection marquees and lasso's. Where are these features in 2008 Excel? I can't find them anywhere. <br><br>thnx
I just found my answer, the "genius's" at Microsoft / MAC Office decided to kill off all these editing features... <br><br>Over $200 to upgrade to a product with LESS features... I don't think so... unbelievable, I will continue to use 2004 because 2008...why does sorting change a scatter plot graph?
Why does the way a spread sheet is sorted change the look of a scatter plot
graph??? the graph is just a plot of two points, (X, Y) and these two points
are definded by two collumns for a given row. The two collumns don't change,
and the row all stays together, so why does it change where points are
plotted out on the graph when you re-sort it?
Usually, for an XY (Scatter) chart, with values of X in a column and
corresponding values of Y in an adjacent column, for three or more points,
Excel assumes (correctly) "Series in Columns."
But, when you have only...Formatting a subtotal line with a macro
I already have in use a macro that runs a sort and subtutal function. I
would like to format the subtotal row using visual basic since there is
already a macro in place.
Look at this:
ActiveCell.Font.Bold = True
"DJDKAL" <email@example.com> skrev i meddelelsen
>I already have in use a macro that runs a sort and subtutal function. I
> would like to format the subtotal row using visual basic since there is
> already a macro in place.
This is what I've g...Changing Prices in HQ.
Hi, I have this little issue. I want to change the put items on promotion
using the price wizard using HQ. Unfortunately if I have stores who has
differents prices for a same item the wizard do not make the proper change
becuase it use the price already stored in the master table. Does anyone saw
this issue before? Who was solved?. Thks in advance for your help. Rgds
The easiest way to look after this is to not change any data on the ITEM in
HQ, but to simply do the worksheet for altering the sale price and then send
it to the respective stores.
Then in the works...Content of emails is changing without any reason !
I changed operating system last week. From Win XP to Win 7. Used to work
with Outlook Express at full satisfaction.
I could transfer most of my emails automatically with export/import features
of Microsoft software.
But I suddenly discover 1 very big problem (bug ???)
I am used to work with several maps, and hereby go to several levels deep.
Such as :
Date of action
Name of patient
So sometimes maps can go several levels deep.
When I check ema...formatting auto replies
Does anyone know of a method that allows outlook 2k2 to format automatic
replies regardless of the format of the original message? I setup this
automatic response rule that replies with a template, but problem is, when
replying to http clients (hotmail or yahoo), the message at the receiver's
end has words totally misplaced, all over the page. Any suggestions would be
...Table link documentation
I am having trouble trying to locate A/P check data that has project related
costs. I found the check data but it is does not indicate the projects, I
found the project data but can not determine thye logical link between the
two tables, I may be using the wrong tables the tables I am using are PM80500
and PA31102. Is there any documentation of how all the tables in the system
are logically link. I am trying to write reports in MS Access, but there
are 1500+ tables in GP (version 10)
In an effort to find the correct table you can do a number of things (believe
me I do)....Saving toolbar changes
After spending a lot of time to customize a toolbar in Excel 2003, it disappears when opening up another file, or starting the app again. I repeatedly change it, save it as XLB, XLT, save multiple copies in every possible location...but the damn thing always defaults to its own toolbar settings. This makes toolbars almost useless.
How can one insist that PPT use YOUR toolbar setting, rather than its own default
If I have a lot of tool bar changes to make, I close all the
workbook that are not hidden then unhide my personal.xls
from the Window menu.
I don't know why...Change cannot be saved due to sharing violation
I've this message while saving the excel file even if no change ha
been done to the file. There is no share on this file (exclusive use)
File resides on a network drive
It's very disturbing
Thanks for your help
Vobiscum's Profile: http://www.msusenet.com/member.php?userid=245
View this thread: http://www.msusenet.com/t-187102186
Thanks for your answer, I will try tomorrow noo
----------------...Importing AOL Email File Cabinet
Is it possible to tranfer a complete AOL Email File Cabinet into outlook?
AFAIK, no, but see if anything here will do it:
http://www.slipstick.com/config/convmsg.htm - check out Address Magic Plus
first, it can convert almost anything.
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
Outlook Tips: http:/...Changing query execution sequence
I got a spreadsheet which would execute a bunch of queries. It's noted that
the queries are executing in the sequence of when it was added to the
spreadsheet. Does anyone out there know of a way to switch the order without
deleting and recreating them?
...Duplicate record in RM tables
We experienced an issue in Apply Sales Document that may have caused a
duplicate record somewhere. We found this when running Paid Sales
Transaction Removal and received this message:
Violation of PRIMARY KEY contraint PKRM3101. Cannot insert duplicate key in
I ran the RM duplicate tool found in the automated help area of this website
and found the following:
--- Begin copy here ----
Duplicates between RM Open and RM History
Document #: 07-003021-17 Customer #: 079100 RMDTYPAL #: 7
--- End copy ---
It looks like the duplicte tool also logs the qu...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam firstname.lastname@example.org> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Format for credit card numbers
I've tried a custom format for entering credit card numbers (four groups
of four digits, separated by dashes: xxxx-xxxx-xxxx-xxxx.
I have tried to use ####-####-####-#### and 0000-0000-0000-0000 but
each of these causes the last digit to change to zero. So if I enter
5415779800902512 I get 5415-7798-0090-2510.
Anybody already solved this problem?
Schmacker's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28041
View this thread: http://www.excelforum.com/showthread.php?th...140 MB file went to 5.08 MB after editting 1 table
Hello All -
I need some ACCESS insight...please...
Several years ago, I built an access db to track my business
scheduling and accounts payable/receivable.
So this database is EXTREMELY IMPORTANT TO ME.
The file has grown to 140 MB.
Today I made a copy of the file and then edited my calendar table.
I removed all columns which had 2006 data (72 totals columns) - the
table had about 144 columns originally.
I then added 72 columns with 2008 headers. These columns are now
blank since I have not added any 2008 data yet. Afterwards, I looked
around and everything looks good - my 2007 data is the...Automatic changes in cells
Hi for some reason I now have to save my work for any formlas etc to change
when I update a worsheet, how can I stop this as it is a pain and sometimes
I need to do changes to see how they work before saving the work.
Click on Tools | Options | Calculation tab and set to Automatic
calculation, as it is probably set to Manual. You can press F9 to
force a recalculation under a manual setting.
Make sure you save the file with the Automatic setting, to avoid it
happening next time.
Hope this helps.
On Feb 1, 11:42=A0am, Office 2004 Test Drive User
<heepenm...@yahoo.co.u...Change the text of a shape rather than its master
I build custom masters by mixing two general shapes, say square and
circle together, and have text on both the shapes.
But after I drop an instance of the master into a page, I cannot
modify the text of the instance. To do so, I need to modify the text
on the master, which is non-sense for me.
How to change the text of a shape without modifying its master?
How are you doing this? By code or by the UI?
Are you grouping the shapes? If you drag two shapes to the stencil, it will
group the shapes. So instead of a square and a circle you have three shapes.
A Square, Circle and the...cell colour change when set markers are reached
i need to get a cell to change colour when markers are reached eg
a qualification lasts 12 months. what i want to do is have the cell change
from yellow to orange to red as the expiry date gets closer.
If column A contains expiry dates then select column A,
=DATEDIF(TODAY(),A1,"m")<1 red for 1 month
Click Add button, formula2:
=DATEDIF(TODAY(),A1,"m")<2 orange for 2 month
Click Add button, formula3:
=DATEDIF(TODAY(),A1,"m")<3 yellow for 3 month
Adjust number of months as you like!
Is there any way to format a cell differently depending on the number of
decimal places typed in? What I need is a minimum of 2dp but 3 if the typed
entry matches. eg 1.2 appears as 1.20 and 1.234 appears as typed.
Try formatting the cell with a custom number format such as 0.00##
AlfD's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=478
View this thread: http://www.excelforum.com/showthread.php?threadid=27494
"AlfD" <AlfD.email@example.com...Pivot Table Defaults
In the pivot table field list, whenever I create a new pivot table and I am
inserting fields into the value area, I generally get as default field
setting the 'Count' value. Is there a way to format the spreadsheet to make
Excel recognize the data as all numbers so it defaults to the "Sum" function
as opposed to "text"?
The rule that the PT Wizard adopts is,
If all the values in the field being added to the data area are Numeric,
then it uses Sum.
If any of the values are Text or BLANK, then it uses Count.
It sounds as though you have defin...Changing ip address of exchange server #2
I have a back-end server and a smtp server in DMZ.
I want to change ip address of back-end server. are there any issues?
all incoming and outgoing emails are going via smart host.
No issues at all as long as you remember to change all the references to
this server in your firewall, SMTP scanner etc.
"Jack Dorson" <JackDorson@discussions.microsoft.com> wrote in message
> I have a back-end server and a smtp server in DMZ.
> I want to change ip address of back-end server. are ...Setting appointment start & end time increments format
In Outlook 2002, I can easily set the Day View to display
the time increments in 15 minute blocks, but on the
Appointments form, the Start and End Times available on
the drop-down menus, respectively, are in 30 minute
increment blocks only. How can I set the format for the
appointment page to have the Start and End Times for
appointments have increment time blocks of 15 minutes?
Thanks! My direct email address is:
If you set your appointments in 15 minute blocks
Outlook will start to offer that. It takes a few uses
Nikki Peterson [MVP ...