|
Aligning deciamals
How do you align currency figures in a mailmerge document so that it is right
justified and all decimals are aligned vertically?...
|
2 |
3/19/2007 3:52:37 PM |
|
|
Aligning deciamals
How do you align currency figures in a mailmerge document so that it is right
justified and all decimals are aligned vertically?...
|
1 |
3/19/2007 3:16:02 PM |
|
|
Blank fields showing as zero
I am using Word mailmerge to print fields calculated in Access. I want a
null or zero result to print as blank. Should be simple but ... !!...
|
5 |
3/19/2007 1:54:00 PM |
|
|
Mail Merge with Bookmarks
I am attempting to have a list of bookmarks in a seperate document (doc1)
with text and mergfields allocated to this bookmark and I am then trying to
merge the bookmarks into multiple other documents (doc1, doc2, doc3 etc) by
using the bookmark that is allocated.
I am trying to do this without much success to try and save me time as I may
want to change some of the information in the bo...
|
2 |
3/18/2007 2:18:06 PM |
|
|
Mail merge problems in Word 2007
Has anyone else had problems doing mail merge in Word 2007? I tried to
connect to a query in a .accdb database but when the list of queries came up
the particular query I wanted wasn't listed. When I open the database the
query runs fine but if I try merging from that query using the option
available in Access 2007 the resulting data appears corrupted when I get to
the first step of th...
|
1 |
3/18/2007 9:16:00 AM |
|
|
Is there an easy way to do a mail merge letter?
I want to do a simple mail merge letter with just address and Dear (whatever)
can't understand the instructions on the help....
|
2 |
3/18/2007 6:31:10 AM |
|
|
Cannot find data source
When I open a particular merge doc on my computer it connects
automatically to the data source, as it should. On a co-worrkers
computer she gets the message ...cannot find data source... When she
selects the data souce through the dialog box, she get the same
message. The only thing she can do to get the document to work is
remove all merge info and use the wizard to connect to the data
so...
|
5 |
3/16/2007 6:45:20 PM |
|
|
automating the SQL warning and the choice of text format
Hi all (again)
I was just wondering as I am trying to automate a word mail merge as much as
possible (least user clicks)
is it possible to automate the dialog boxes that appear when opening a word
file that use mail merge
in particular the "this file will run an SQL command select * from ... "
click yes and the " what is the encoding of this text file" I want that to
be default ...
|
3 |
3/16/2007 3:07:34 PM |
|
|
Mail Merge with Multiple Rows
Hello all,
I have a document that I want to use for one client; however the client
could have multiple rows because they could deal with several different
banks. So all their demographic information stays the same but they might
have many different bank it could be 1 or it could be 10, I have no idea at
the time I run the merge. What I want to know is how to I run the merge
that cou...
|
3 |
3/16/2007 12:04:46 PM |
|
|
If -Then-Else Statements in Word 2003
I have been reading all the posts regarding the use of Word Fields to
skip a field if the data is blank but I'm still having problems.
I have two Mergefields on the same line <<County>> and <<PostCode>>.
In some cases, like sending a letter to Australia, the County field is
blank but the PostCode field contains data but when I merge the data,
the whole line is blank...
|
8 |
3/16/2007 10:10:39 AM |
|
|
1st row of data does not become field names
when I choose an xlsm file to be a data source, i pick an excel sheet. But
when it merges. the field names are the first row of data as opposed to
Name, etc. How can this be solved?
thanks...
|
2 |
3/16/2007 9:44:22 AM |
|
|
Using excel in a merge
I have created a mail merge using excel as the database.
Every time I run the merge the numbers appear with lots of decimal places no
matter which number format I use in excel.
I tried just copying the numbers in to word & then recopying them back to
excel.
They appeared with all the decimal places so it must be word that is the
problem.
What can I do?
...
|
2 |
3/16/2007 8:12:40 AM |
|
|
Mailmerge & MS Exchange
I have created a mailmerge letter document using my contacts from Outlook. I
have enabled the "sharing" option on my contacts and assinged "owner" status
to my assistant. We work off of different machines.
My assistant can "see" my contacts in her Outlook client on her computer,
and when she opens the Word document to merge, she is prompted to choose a
contact folder to merge from. Howe...
|
3 |
3/16/2007 6:32:33 AM |
|
|
how to send out a press release to 1000 e mail addresses
I am out of touch, being used to sending out with mail merge so have no idea
where to put addresses and how to merge them for an e mail press release,
anybody out there can help I would be immensely grateful thank you...
|
2 |
3/16/2007 12:01:33 AM |
|
|
"0" in empty column when converting from Excell data to Word direc
I have an Excell data base that I convert to a Word directory. It has
addresses, phone numbers, comments, etc. When it is converted to a directory
if there is no information in the Excell column then Word puts in a "0". I
want to get rid of that zero. How?...
|
2 |
3/15/2007 11:58:40 PM |
|
|
How do I perform a mail merge into a table?
What I'd like to do is mail merge from my data source into a Word table.
So, in order to put more than one record on a page, I use the NEXT field
code on each new row. The problem with this is that if I have 20 rows per
page and, say, use only 15, there are now 5 blank, but outlined rows in my
output document. It would of course be easy to remove these rows, but the
entire merge process w...
|
8 |
3/15/2007 6:58:10 PM |
|
|
Mailmerge Invert columns for flashcards
I've finaly figured out an effecient way to make flashcards except one
problem.
In an excel file I have two columns, one for each side of the flash card. I
then do a mail merge with a small size label ie. name badge (2.1" by 3.5")
which creates 8 boxes per page. The merge fills each box with an entry from a
specefied column in the excel file. Now the fronts of the flashcards are
prepar...
|
6 |
3/15/2007 4:45:05 PM |
|
|
Fixing Mail Merge header files
I have an appl that automates Word Mail Merge. It was written a long time
ago and it uses a template document that is created and saved with an
attached Header file (csv text file) but no attached data source file. It
attaches to a generated csv Data Source file at run time.
I have clients who have been running this application successfully for many
years, but as some convert from Wo...
|
4 |
3/15/2007 2:36:28 PM |
|
|
faxing from word 2000
When I try to send a fax from word 2000, I get an message error occured
during loading. Any suoggestions.
--
djones...
|
3 |
3/15/2007 2:20:16 PM |
|
|
Merge data with 2 forms on one page
We have 2 forms, side-by-side in column format. At the top of each, are
merge fields. When I use the "Next" field, it goes to the next record on the
page, but then repeats the 2nd record on the next page. I've tried putting
"NEXT" about everywhere I can think. Can this be done? I either get two
records the same on a page or two different records on the same page with the
next page r...
|
4 |
3/15/2007 6:26:57 AM |
|
|
labels to an apartment complex with 300 units
I dont want to type 300 separate labels.. is there a way to merge unit numbers....
|
2 |
3/15/2007 6:00:30 AM |
|
|
Cross referencing - Mail Merge Document
My mail merge document contains cross referencing to paragraph numbers some
of which are contained in "if statements" and when the document merges my
cross referencing does not update correctly, it simply refers to paragraph
"1" if it was in an if statement.
Is there any way that I can use cross referencing in a mail merge document
if the referenced paragraph is in an "if statement"?
...
|
2 |
3/15/2007 4:18:08 AM |
|
|
Printing email with stationary problem
I have a user who would like to print some of her emails with the stationary
on them. She uses stationary a lot. Anyway when she tries to print the
statioanry disappears. I tried a suggestion of turning on the background
print in Internet Options but that didn't work. Any ideas?
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-mailmerge/200703/1
...
|
1 |
3/14/2007 9:08:14 PM |
|
|
format zero values merge fields
I am using Word and Excel 2007 and am mail merging numeric values from Excel
into Word. I would like any zero values to be returned as "-." I know how
to return the values as "0" or blank, but not as "-". Does anyone know the
"switch" that gets me to this format??...
|
2 |
3/14/2007 7:14:10 PM |
|
|
_para_fax"_no_word_2003?
Como activo o bottão "intercalar para fax" no word 2003, se já tenho o
microsoft fax instalado e configurado e o microsoft outlook instalado?...
|
2 |
3/14/2007 5:26:31 PM |