|
Mail merge using a secure database
I have a user that is trying to do a mail merge using a secured access
database and when the database is accessed, using the right password and
correct priviledges, it opens with gibberish. Is there a special way for
mailmerge to access a secured database. Using office 2007 and access 2003. ...
|
2 |
6/20/2007 11:25:18 PM |
|
|
Stop Ask fields when previewing prints
Whenever I go to Print preview, the ASK fileds I have set up on my template
keep prompting me to check and OK the content. I'm using them to insert
headers on manuals that include up to 20 chapters - I therefore have to OK
all of the 20 dialogue boxes when I either go to print preview, or come out
of preview.
Is there a way I can turn this off? Have checked the Tools, Options and
ca...
|
2 |
6/20/2007 7:04:43 PM |
|
|
Mail Merge Field cutting off text
I have a user who is using Excel as the list and has a field with text in it
that he is merging to a Word document, problem is that about the last 15
words from the merge field is being cut off. Is there a character limit on
merge fields and if so are you able to increase the size??
Thank You!
Cal Expo...
|
2 |
6/20/2007 6:56:14 PM |
|
|
Multiple Merge Documents with One Record
Is it possible Word/Access 2003 to merge multiple documents with one record?...
|
2 |
6/20/2007 6:52:04 PM |
|
|
Database Field SQL Statement
OS: XP Pro SP1, Word 2003 SP2
DATABASE \d "C:\\Temp\\VerizonAirCard.mdb" \c "DSN=MS Access Database;DBQ=
C:\\Temp\\VerizonAirCard.mdb;DefaultDir= C:\\Temp;DriverId=25;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;" \s "SELECT * FROM
'tblAirCard' "
I’ve been unable to change the select statement above to work properly.
I’ve tried to use tic, backslash and tic and backs...
|
10 |
6/20/2007 6:41:14 PM |
|
|
Header is dropped when merging to email
I set up a mail merge document in Word that includes the company logo as a
graphic in the header. When I merge the document to email, the header is
dropped....
|
2 |
6/20/2007 5:42:48 AM |
|
|
SWF in mail merge
Well, I did a mail merge with photos by using the 'includepicture' field with
the 'if' field inside.
I'd like to do a mail merge with swf (if <<field>> = "Test" X Y) where on X
and Y I would put two Flash ActiveX objects, but when I merge to a file, the
flash object (or the result of the whole if field) becomes a static picture.
Why does it happen?
Resuming, I'd like to do ...
|
2 |
6/20/2007 5:41:00 AM |
|
|
Merge Document Closes
We use word and access 2003. When searching for records using the toolbar's
search icon the merge document sometimes "closes". What would cause that to
happen?...
|
1 |
6/19/2007 8:41:37 PM |
|
|
x picture item rounding
Hello All,
I'm using the x picture item to the display the last 4 digits of my field
which is a 16 digit number. The documentation says "Drops digits to the left
of the "x" placeholder. If the placeholder is to the right of the decimal
point, Word rounds the result to that place."
Word is rounding my number even though there is no decimal. Is this because
the number is so large? If I ...
|
6 |
6/19/2007 6:45:01 PM |
|
|
mail merge freezes when completing merge - using excel 2007 as sou
every time i try to complete the mail merge in word 2007, the new document
freezes. the data source is an excel 2007 file. there are only about 12
recipients, and i haven't done anything fancy in the merge (address block).
i've used mail merge frequently for awhile, so normally i can troubleshoot
what is wrong, but i haven't been able to this time. i've tried creating new
documents, but ...
|
1 |
6/19/2007 5:34:07 PM |
|
|
Can you use word to print individual cheques?
Does anyone have a template that can print individual bank cheques?...
|
1 |
6/19/2007 12:03:11 PM |
|
|
how to use check buttons or options buttons in a mail document
I want to use mail merge for sending by mail.
In my basic document are options buttons to fill in.
When I'm sending the mail, the responder can't click the button....
|
2 |
6/19/2007 10:55:29 AM |
|
|
my labels aren't merging
i'm trying to do a mail merge for address labels but when i complete the
merge only one label has an address on it...
|
12 |
6/18/2007 9:37:01 PM |
|
|
margins Error
I couldn't set my Word page setup in 32x39 cm with this margins:
Top: 1.5 cm, Bottom: 1.5 cm, Left: 1.5 cm, Right: 1.5cm...
|
2 |
6/18/2007 12:03:29 PM |
|
|
printig error
I couldn't print with Xerox DocuColor 6060 when my page setup is 32x39 cm...
|
1 |
6/18/2007 11:35:00 AM |
|
|
Save results of mail merge as individual files
MS Office 2003, Win XP
I've set up a mail merge document that works fine. I now want to save
each individually merged file as a separate document so that I can
email it as an attachment.
However the only output options I seem to have are to to print the
documents or to create one large file.
Does anyone know if there is a way to save them as separate files?
...
|
3 |
6/17/2007 7:19:24 AM |
|
|
display of no of pages after mail merge
well before completing my mail merge process ,i at first set the pageno
option through header & footer, but to my surprise after completion of my my
mail merge process i found that though in the status bar total no of pages is
being displayed but again the same no of pagei.e.suppose 4 pages are there
,than page 1of 4 is being displayed in all the pages. i tried several
possibilities but ...
|
2 |
6/16/2007 10:18:39 PM |
|
|
when I use mail merge the merge drops the '0" of zip code
when printing labels from the xls sheet, the first number os the 'zip code
is dropped if it a "0"...
|
2 |
6/16/2007 10:10:01 PM |
|
|
Support "Categories" (Outlook Contacts) in a Word Mail Merge.
Hi Guys,
When your mail merge data source is "Outlook Contacts" how can you choose
the "Category" field, as your merge criteria?
My 600 Outlook contacts are all categorized. But as far as I can see, there
is no way in Word to perform a Outlook contacts merge with the condition
based upon the Outlook contact's category.
My work around is to start in Outlook, highlight the contacts I...
|
4 |
6/16/2007 1:39:01 PM |
|
|
Filter Merge Data by Date Range
Hi Guys,
I'm merging with an SQL table, which includes a date column.
And I need to merge the records for a specific day only.
The date column is formatted as '2007-12-31' (yyyy-mm-dd) and includes a
time stamp 00:00:00.
But when I use "Filter & Sort" in Word, I cannot get it to filter by the
date at all. No matter what varations of operators & values I try, it won't
filter the re...
|
3 |
6/16/2007 11:50:16 AM |
|
|
how do i display leading zeros when mail merge to Word doc
When I mail merge zip code to my word documents leading zeros are dropped.
Eg: 07866 becomes 7866. How do I get Word to display the zero?...
|
2 |
6/16/2007 2:57:58 AM |
|
|
Show two fields from next record conditional upon one original fie
Thanks for looking at this, it's got me foxed, I feel I'm on the cusp of
working it out, but not quite!
I want to print a document using a database that sometimes interlinks with
the next record. I run a small property business and would like to automate
the contract process. I fill in the database with all details and then go to
print the contract interrogating the database. Sometimes...
|
3 |
6/15/2007 12:03:53 PM |
|
|
Suppress error messages when merging in batch
We do merge in Word through a batch job. This is fine unless there is
an error, for example one of the records in the data file is
incomplete. Then the merge hangs. If such a merge were run online
the user would see the error message and acknowledge it, but in batch
mode there is no way to acknowledge it. Is there any way to avoid the
hanging and instead have Word exit and return an error...
|
2 |
6/15/2007 10:48:02 AM |
|
|
elds
I am mailmerging a standard letter to an Excel data source and using the More
Items link in the wizard to insert the fields. I am keeping the Database
Fields checked and do have the fields from my Excel spreadsheet available.
What are the fields that are shown when I click the Address Fields button –
are they Outlook fields? - they look very similar. ...
|
5 |
6/15/2007 7:26:01 AM |
|
|
etters
After I have merged to a new document, is it possible to save each letter in
the file as a separate file so that I can store them in the appropriate
client folder? I know I could copy and paste but that seems to be a very
clunky way to do it. ...
|
3 |
6/15/2007 7:18:01 AM |