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...TempVars unusable in field default value
I'm trying to use a temporary variable to keep track of which CSR is
I have a macro which prompts user for ID code, which is stored in the temp
On a form control default value property, I can use the expression
[TempVars]![TempUser], which will populate that user's ID code into the
However, I cannot use that same expression in the tables field default value
property. If I try, when I save the changes to the table, I get the error
message "Could not find the field 'TempVars]![TempUser'. "
Any ideas why I ca...How do I set up a daily average of unit sales formula
More info required.
(remove nothere from the email address if mailing direct)
"jim m" <jim firstname.lastname@example.org> wrote in message
...Can I copy radio buttons so that the second set is independent of.
I have a group of four radio buttons that all point to one cell. My goal is
to create a second set that looks identical to the first but which points to
a second cell. This is for a questionaire that will have many questions with
the same four answer values. I want to be able to quickly create 100 button
groups that will each update a separate cell for scoring of the questionaire.
There are optionbuttons on the Control toolbox toolbar and there are
optionbuttons on the Forms toolbar.
Each has different behaviors.
If I had to use lots, I'd use the Forms version.
Here's a pos...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...fiscal year setting question
i know that the fiscal year settings get more or less set in stone, so i had
a quick question before i set it for my org.
in the template field, what is that used for? if i select 'quarterly', does
that mean i can only run reports on a quarter basis? what if i wanted to do
ultimately, my question is what is the 'template' field used for?
Fiscal year setting must be aligned to your company's accountig policy.
Fiscal year setting primarily defines sales quotas. When you set quarterly
periods, you can set quarterly quotas for mem...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...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...VB Macro #2
I have a macro that is generating Excel files. When the macro runs, it saves
two different tabs in the workbooks as values. It needs to test and wait
until the formulas that are pulling amounts from another database are
correctly populated with the amounts.
Right now, I am getting N/A# instead of amounts for some, but not all, of
the files. I think the problem is that the formulas have not completed
pulling the amounts before the macro pastes that tab as zeros. (N/A# is what
appears when the formulas have not completed calculating - once they have
completed, the N/A# is replaced ...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
----------------...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?
...Problem with macro assigned to custom toolbar button
Problem with macro assigned to custom toolbar button
I am having a probelm with macros assigned to a custom button on
custom button. I am using excel 2000.
1. I have created a macro called "Jump" in a workbook named "Test1"
2. I then created a custom toolbar and added a custom toolbar button t
3. Through the customize dialog box I assign the Macro "Jump" to th
Everything works fine UNTIL.
If I do a SAVE AS for the workbook "Test1" and call it something els
like "Test2" and then close "Test2" an...Outlook set up
In MS Outlook 2002: When I send an email, it has my email
address in the from field. People receiving it cant tell
it is from me, and it gets deleted. How can I make MY
NAME appear in that from field instead of my email address?
On Mon, 19 Jan 2004 11:17:36 -0800, "etata"
>In MS Outlook 2002: When I send an email, it has my email
>address in the from field. People receiving it cant tell
>it is from me, and it gets deleted. How can I make MY
>NAME appear in that from field instead of my email address?
Just a...set print area #2
Where is the "set print area" button in Excel 2002 that was in Excel '97?
> Where is the "set print area" button in Excel 2002 that was in Excel '97?
Are you sure it was "standard"? Only way I could get in was to right-click
the toolbar|Customise and drag it to the toolbar from Commands|File
...How do I set up a 98% baseline across my chart?
I am trying to show on a bar chart the baseline that represents SLA
requirement of system up time of 98%. How do I do this?
You can find information on adding a datum line here.
Andy Pope, Microsoft MVP - Excel
"Deb" <Deb@discussions.microsoft.com> wrote in message
>I am trying to show on a bar chart the baseline that represents SLA
> requirement of system up time of 98%. How do I do this?
...Macros not performing correctly
I recorded a macro to place a vlookup formula in four cells that are side by
side. When I run the macro it only performs the first task, it does not go on
to do the other three. I used the tab key to go to the next cell while
recording the macro, I don't know if that's why it's not working or if it's
The script looks like this:
' EERates Macro
' Macro recorded 3/4/2005 by BCBSOK
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Sheet1!R3C1:R102C2,2,0)"
ActiveCell.FormulaR1C...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...default text height comment
Is there a way to set the default text height for a new comment?
(I've looked through help but can't find it if it's in there.)
I assume you mean the font size? There is no text height available in Excel.
A comment has a shape property and that is what you can use to change the font size.
They didn't make it easy ...
Range("D4").Comment.Shape.TextFrame.Characters.Font.Size = 12
Portland, Oregon USA
(free and commercial excel programs)
wrote in message...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!
Regards,...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 ...