|
Adding file name to a mail merge using PDF
I have captured the macro for automatically PDF-ing the mail merge. It names
the file automatically. I would like to add an additional name into the file
name. ie: let's say the file name is "10222.pdf" and I would like to add
Allergen.10222.pdf. How would I add the word 'Allergen'? I would like for
it to automatically put the word "Allergen" as its PDF-ing. I don't want to
rename...
|
2 |
10/8/2008 7:54:35 PM |
|
|
Labels from a mailmerge
I am trying to print labels from a database but it keeps putting one address
on each sheet of labels, how can I fix that? Thanks...
|
2 |
10/8/2008 7:48:02 PM |
|
|
Is it a better/new way to perfrom mail merges from a template?
...
|
2 |
10/8/2008 4:51:00 PM |
|
|
Mail merge using Microsoft Query - problems
I have a SQL Server database that contains the data I want in my mail merge
in a number of different tables. I've written a piece of SQL that displays
the correct information, which I've saved using Microsoft Query. When I set
up my Mail Merge to use this query as its Data Source it only returns data
for fields in one fo the tables. The column headings are there for the
others but not...
|
5 |
10/8/2008 4:47:25 PM |
|
|
Word Mail Merge From Excel Data
I'm doing a mail merge in Word with Data from an Excel spreadsheet. When the
Excel cells are blank, I don't want the blank spaces to appear in the Word
Mail Merge. Is there a way to prevent the blank spaces from showing in the
Word doc?...
|
2 |
10/8/2008 2:18:25 PM |
|
|
Field shading
how do you switch off field shading in word 2007? I've set field shading to
'never' in word options, but the shading is still there......
|
4 |
10/8/2008 9:47:01 AM |
|
|
MailMerge - Working application.
I have a header text file with 578 field headings. There are about 200 Word
templates. Each template is set to use this single header file from the Word
menu across all the templates. The datasource text file is also mapped
manually from the Word menus for each template. Both file names do not
change. Just the contents of the datasource file which is copied from a
Windows server after a ...
|
4 |
10/8/2008 9:37:55 AM |
|
|
Merging dates to hard text
Hi,
I am using mail merge and the 'Date' field. Is there anyway to make the
'Date' field fixed after the merge? I want the date of the merged document
to stay fixed when it is reopened. The 'Date' field updates to the current
date if the document is repoened. The 'SaveDate' and 'CreateDate' seem to use
the date of the template containing the mergefields not the actual merged
docume...
|
3 |
10/8/2008 9:05:25 AM |
|
|
keep a mail-merged document from asking to connect to a database
I use a database to create individual letters for clients. When I send the
letter to colleagues to review they are prompted to select from my database.
How can I convert a merged document into a regular document (containing the
data I merged in) so that they don't have to deal with this?...
|
2 |
10/8/2008 5:36:12 AM |
|
|
why do links in pdf's disappear when I insert the file into word
I'm trying to do a mail merge for e-mails. When I insert my PDF document
into the message body, the entire PDF converts over to a JPG and links
disappear. What am I doing wrong?...
|
2 |
10/8/2008 5:34:46 AM |
|
|
Mail merge issues!
Hi there
I've bene asked to prepare a mail merge letter for 100 recipients. I had
done this, saved and sent it to my boss. However, the mail merge did not
pull through the recipients of all the worksheets. Only saved the last in
the list.
How can I retrieve the other receipients letters without going through the
hole process again?...
|
2 |
10/7/2008 7:33:06 PM |
|
|
Pdf Maker error
I have Adobe Acrobat 9 Pro, Office 2007 and Windows XP SP3.
I have recently bought the Adobe software and see that it allows to merge to
a pdf and automatically send by email in the same way I am currently doing by
merging my document as an attachment to email.
However, when I have tried using this function I get the error message:
"Word experienced a serious problem with the 'acrobat pdfma...
|
2 |
10/7/2008 7:32:13 PM |
|
|
mail merge 2007 word labels
I have exported a list from our student program to excel for a label mail
merge. I have their birthdates in the list. When I merge and update the
labels the birthdate format changes to mm-dd-yyyy. I can not get it to change
to yyyy-mm-dd. any suggestions. I have tried to format the cells in excel as
a date in the y-m-d format but it still goes to word as mm-dd-yyyy.? Please
and Thank you...
|
2 |
10/7/2008 7:28:49 PM |
|
|
mail merge with excel data
I am merging excel data into Word 2007 doc. My fields are in a table with 3
columns with several lines of data in each column. When I merge my data into
Word, I get a section break next page after each table which puts one table
on each page, now I have 100 pages with one table on each page. How can I
prevent these section breaks from being inserted?...
|
2 |
10/7/2008 7:19:14 PM |
|
|
mailmerge
I want to learn mailmerge, How there are simple way?...
|
3 |
10/7/2008 10:29:09 AM |
|
|
merge for labels in Word-2003 - now getting a little cross bar ...
What has happened? Have used mail merge for labels in Word 2003 for a long
time - years... This month it is not working. The only thing that shows up
in the document is a little cross bar in the upper left of the document.
When I click on the cross bar - I get many big black bars across the page.
I did a detect and repair of Office Word and it is still happening.
I need badly to c...
|
2 |
10/7/2008 4:43:16 AM |
|
|
Merging variable length data to a table
I have a table set up in my main document and I'm merging data to it from and
Excel spreadsheet. The table is set to auto fit to conetents, Every thing
works fine for the first 9 records, where the "part number" field ends in 1
through 9. However when the 10th record (part numbers ending in 10 and
above) and up are merged, the last character is wrapped making the cell
taller instead of...
|
2 |
10/6/2008 8:29:44 PM |
|
|
Printing records in order?
I am printing address blocks to envelopes, and I have close to 20 worksheets
in the excel file that I am pulling the data records from. The issue I am
having is that once the print job has been sent, the print outs do not come
out in any sort of order according to the database. How do I force the print
out to come out in the order that they are listed in the xls file?...
|
2 |
10/6/2008 7:42:58 PM |
|
|
Mail merge adds "mailto:" to email addr
Word 2007 mailmerge field "email" from Access 2007 adds the extra
#mailto:...# to the email address. How do I prevent it? The Access 2007
database is clean.
Example:
leafpatrol@fllha.org#mailto:leafpatrol@fllha.org#
Thanks, Ray...
|
4 |
10/6/2008 7:43:36 AM |
|
|
Differences in mail merge in 2007 and previous version
In previous versions of Word, if you set up a letter with merge fields, you
created a header and a data file. When you then used the document, when you
entered data, a pop - up form would allow you to enter the data for the
fields and then be inserted in your data document which then was merged into
a new form letter.
When I try to set up the same type of document in 2007, I don't get ...
|
6 |
10/6/2008 4:40:49 AM |
|
|
Mail Merge with Public Outlook Folder instead of personal address
My mail merges work fine from my personal address book. We have created a
Public folder though that has other addresses that we want to use. The
folders display when we are in Outlook, but they don't display as an option
when I select Outlook as a Mail Merge option. How can we access these groups?
Thanks in advance,
Dave
...
|
2 |
10/5/2008 7:25:32 PM |
|
|
Dlookup on mail merge
I have a mail merge letter that is linked to an Access database table. I can
map most fields that I need but some of the fields I want would be DLookup
fields if I was creating an Access report. How do I do DLookup formulas in a
Word document?
Thanks
Tony...
|
4 |
10/4/2008 7:40:45 PM |
|
|
How do I format a birthdate for mail merge labels
I am creating labels for student files. I have my list exported to Excel.
When I do a mail merge the Birthdate set at YY-MM-DD in excel - changes to
DD-MM-YY on the label. How do I correct this on the label?...
|
3 |
10/4/2008 8:40:00 AM |
|
|
Printing an Informational Cover Page for each Doc
I am trying to figure out if there is a way to print a page that lists the
information of what is being printed. Much like the first page of a fax
printout. It might include the date, the document name, etc. I was told that
it is possible. Does anyone know how to accomplish this?
Thanks!!!...
|
2 |
10/3/2008 4:51:22 PM |
|
|
Word not merging cells with numbers and letters
I am merging an excel document in to word (both office 2007). Some of the
cells have data with a number and a letter such as 32R. On merging these
cells pull through as a zero. Any suggestions.
Many thanks
kanedmamma
...
|
6 |
10/3/2008 2:53:03 PM |