|
Mail Merge [If...Then...Else...]
Under
Tools > Letters > Mail Merge >Insert Word Field (in merge tool bar) is
If...Then...Else...
This window allows for adding text under specific circumstances.
During an online class for Mail Merge, I was shown a similar window, but
instead of inserting text, you would add Mergefields.
The window had the first row (Field name, Comparison, Compare to) or
something...
|
20 |
6/15/2007 5:48:09 AM |
|
|
Truncated large text fields
This is a similar question to the one posted by Macy in 2005 except that only
one field is being truncated.
I have a database which I am not able to access directly for the purposes of
running queries, reports etc but I am able to export data from it in Excel
format. Among the fields exported are two text fields one of which is 2000
characters in size and the other 3000 characters.
...
|
2 |
6/14/2007 8:51:57 PM |
|
|
EMAIL MERGE WITH 2 or + ATTACHMENTS
Hi I tried this tutorial:
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
and it works but it sends only the attachment in the third column
(attachment2) while the attachment1 no.
How can I fix it? I need to send 2 attachments…. I tried to use 4 columns
but it always just send the attachment in the last one...
Thank you...
|
4 |
6/14/2007 7:53:42 PM |
|
|
Word 2007 Mail Merge problems with Excel file providing list
I built a custom sized page with text boxes for information.
Basically it's a template for printing addresses on specific parts of
a postcard. Three of the text boxes have common information, but the
fourth will hold the recipient addresses. I start the mail merge in
Word 2007 and choose "letter" as the document form. I follow all of
the steps. My list is linked to the word file because I...
|
7 |
6/14/2007 5:58:46 PM |
|
|
How can I mail merge Outlook Address Book into Word 2007.
How can I mail merge my Outlook Address Book into Word 2007 using a different
default email server? I use Mozilla and do not want to use Outlook for my
emails. Help. I did not have this problem with version 2003. Help Please....
|
2 |
6/14/2007 5:15:00 PM |
|
|
How do I merge to a table in Word - w/o every row a new page?
I am trying to merge date from an Excel spreadsheet to a table in Word. The
Word table is set up with a header row as the first row (column headings -
not merged) and the merge fields are in the second row. When I complete the
merge, each row is on a new page, and I want just one table on one page. I
tried setting it up as a Directory and this solved some of my issues, but the
header ...
|
2 |
6/14/2007 5:03:33 PM |
|
|
Locking info in cells
In Excel Pro 2003, I am trying to enter data from one cell only (A1 – Jones)
and have it saved in another column of cells.(Column C1). If I enter ‘=$A$1’
in cell C1, I get the name in that cell – which is fine.
My problem is that I now want to enter a new name from cell (A1 – this time
Brown) and have it saved in the new cell C2 without changing the Jones name
in C1, but of cour...
|
2 |
6/14/2007 4:08:18 PM |
|
|
Mail merge labels
If I have already done mail merge labels, but only used the first few on the
page how can I get the program to begin on another label other than the first
one so that I can use the other unused labels?...
|
3 |
6/14/2007 10:13:20 AM |
|
|
Merge Options
Upgraded recently to MS Access 2003 (and Word 2003). What would be best
approach to merge documents to Access queries? From word document to the
query opting for DDE, or ODC, or MDB, or ODBC DSN....very confusing.... or
from query to the word document using word's wizard?...
|
6 |
6/14/2007 8:07:33 AM |
|
|
Shrink blank fields in mail merge
How do I shrink blank lines in a mail merge. Typically one contact may have a
2 line address and another has a 3 line address. How do I ensure that the 2
line address contact doesn't have a blank line before the town/city line? I
know it can be done in Access but can it be done in Word?
Thanks....
|
2 |
6/14/2007 6:02:36 AM |
|
|
Awesome
Check it out: www.BrandonsMansion.com
...
|
1 |
6/14/2007 4:13:40 AM |
|
|
MS Access Database via DDE option not available
I have an exsisting mail merge with Word2003/Access2003 that I use only once
a year for Vacation Bible School at my church. This year it decided not to
work! THe mail merge pulls data from a query in Access to create letters in
Word.
I have read several posts and have made a little progress, but I am still
stuck. I have checked the "Confirm conversions at open", and when I get to
O...
|
5 |
6/13/2007 7:34:01 PM |
|
|
Excel and Word - mult lines on info on excel for one customer
I currently keep an excel spreadsheet for all of my customers, and typically
do a simple mail merger for letters. My manager has asked me to create an
attachment letter with mult lines of information from a new excel spreadsheet
I created and it keeps repeating the same information from line one only.
The headers for my excel spreadsheet are shown in example below and I would
like to h...
|
4 |
6/13/2007 5:33:00 PM |
|
|
Mail merge with Word 2003 and SQL 2005 on a date and time field.
I'm trying to do a mail merge from Word 2003 and MS SQL Server 2005.
Previously I used Word 2003 and Access 2003 but I have since migrated
the data to SQL and still use Access as a front end for this app. The
app used to call a Word 2003 document through a hyperlink and run a
query to pull all records. The user would then select Mail Merge
Recipients and narrow the query down to just the da...
|
5 |
6/13/2007 5:10:52 PM |
|
|
How do I print electronic postage on postcards?
I use Mail Merge to print "No Thank You" post cards for rejected applicants.
When I try to add electronic postage to the postcards, I can't get the
postage in the right place or to show on all 4 cards. (Using standard 4 cards
per page) How do I print the postage in the right place and on all of the
cards?...
|
1 |
6/13/2007 2:56:02 PM |
|
|
weird macro thing in Word 2007
We just updated to Office 2007 and I have an envelope mail merge that I use
each week. I have a macro that changes the data that is merged from small
case to capitals and takes out the periods so that they are Post Office
formatted. When I use it, the macro works, but when I print the envelopes,
Word changes them back to their original Upper and lower case format. What
do I need to do...
|
5 |
6/13/2007 2:49:03 PM |
|
|
Meging to a table with section breaks
Whenever I merge to a table, I always get setion breaks between each
record. I'm sure this is really basic, but how do I get rid of them?
...
|
2 |
6/13/2007 11:11:06 AM |
|
|
Formulas?
I have been requested to create a merge document. One of the fields that is
being requested is to calculate a date in the future (5 days from today, 89
days from, etc.). Can you create a field in a merge document that would
calculate something like that? If so, how would one do it?...
|
4 |
6/13/2007 6:59:21 AM |
|
|
Awesome
Check it out: www.BrandonsMansion.com
...
|
1 |
6/13/2007 3:54:38 AM |
|
|
Merge with CSV. Encoding problem
Hi.
Using Word 2003 SP2, when I link the datasource, a csv file, to the
document, appears a dialog to select the text encoding: Windows (default),
MSDOS, Other.
Programming with VBA, that dialog does not appear, but the document
generated from the merging, the characters with accent (á,é, etc...) are seen
like "squares" or japanese characters.
The Document.Open method has a para...
|
2 |
6/13/2007 1:14:49 AM |
|
|
Excel 2007 - Filters and Mail Merge
I am trying to do a mail merge from a filtered set of data (using
Excel and Word 2007); however, Word pulls all entries (even those not
included in my filter) to finish the merge. How can I delete those
entries that I do not want included (those not included in the filter)
without having to do this one by one?
...
|
2 |
6/13/2007 12:50:10 AM |
|
|
I need to do a mail merge and I want to use windowed envelopes
Does anyone know how to do a mail merge document and also use a windowed
envelope so i do not have to print a separate label or envelope but just use
the address on the document?...
|
3 |
6/12/2007 8:18:00 PM |
|
|
Saving mail merge template not saving setting in address block
We are using CRM and need to link certain fields in a mail merge, plus mark
the option to always include the country field. I can do this on a new mail
merge, then update all labels, however, I need to save these settings, so
that the user printing the labels does not have to re-map the fields etc. As
well, we wanted to save the specific label size and margin settings, so we
need to sa...
|
8 |
6/12/2007 5:57:04 PM |
|
|
auto merge field
I have a straightforward Excel database and want to embed the files in a Word
doc. Each time I try to merge the fields, I get a window in which some of the
fields are displayed but not under their correct column nam (e.g. Surname,
Forename etc) but AutoMergeFie. Can anyone help me to rectify this as I don't
want to automerge. Thanks...
|
5 |
6/11/2007 9:41:00 PM |
|
|
MAIL MERGE
I need to produce a directory/catalog and when the unique ID Number changes
the next set of records should print on a new page. Can someone direct me to
a page that will help me....
|
3 |
6/11/2007 8:15:43 PM |