|
outlook 2007 mail merge
when I try to use mail merge from outlook 2007 to word 2007 I get this error
message "MAPI FOLDER OR ADDRESS BOOK NOT FOUNDâ€
Any suggestions would be appreciated....
|
10 |
1/1/2009 8:32:26 AM |
|
|
Error: Mail merge not completed....doesnot contain mail merge fiel
Hello,
I am getting the following error while creating - Directory mail merge main
document - in Word 2007: "Mail merge cannot be completed as becasue the
document does not contain mail merge fields"
I have used a 2 column "Directory Source.xls" as my data source and also
created a 2x1 table in the Word document with merge field "email" in the
first (left) cell of the table & "file" ...
|
4 |
1/1/2009 5:00:01 AM |
|
|
Merge Fields won't populate after Datasource change
If this post should be in a different forum, please let me know. I'm trying
to run a Word 2003 Mailmerge to a mailing label template. I've set up the
Mailing label mailmerge and my datasource is a stored query in an Access
database. Everything works fine with the mailmerge from Word. Now I want to
run that mailmerge from a Visual Basic 6 program, but change the datasource.
When I change ...
|
3 |
12/31/2008 10:44:10 PM |
|
|
cannot locate in Act mail merge fields.
Act uses Either Act WP or Word . They are supposed to drop down when you
click on "View" then you can put the mail merge fields on your document. ...
|
1 |
12/31/2008 10:44:05 PM |
|
|
Desire for non repeated text
I am using Office 2007 and have (with the help of Graham and Macropod)
created a successful mail merge document (directory). This document is
actually a narrative report of many measures. I want to include a cover
page, TOC and introductory comments at the beginning of the document and some
other narrative to introduce sections throughout. All this narrative is
"canned" and does not ...
|
2 |
12/31/2008 10:42:41 PM |
|
|
If "Yes" then "Yes or round as percentage
I am trying to import data from Excel into a Word document via mail merge.
All data in Excel is derived via a formula. One field <<Target>> is giving
me trouble because is may be a percentage e.g.98.5%, a Yes/No. or Null. I
have tried If Then and nothing seems to work to get the results I need.
If the value is Yes, then I need it to state Yes, If it is a percentage, I
nee...
|
10 |
12/31/2008 9:08:05 PM |
|
|
merging highlighted data from excel
I have formatted my excel spreadsheet with highlighting and text color.
However, when I mail merge data from my excel spreadsheet to make labels,
none of the formatting transfers- only the data. Is it possible to merge
the colors too?...
|
1 |
12/31/2008 5:22:04 PM |
|
|
Problems with Mail merge with attachment
Hi,
I am trying to send individual emails with individual attachments. I have
followed the steps outlined in the article "Mail Merge to E-mail with
Attachments" and am having a little trouble.
I have created the directory, written the email I want to send, connected to
data source (same one that I used for the directory) and copied the Macro.
However, I when I run the macro I ge...
|
2 |
12/30/2008 11:01:16 PM |
|
|
Extra space in "Name" field when merged
When I merge data into the 'name' field, the first line of the address block,
there is an extra space in front of the name. The merge is coming from Excel
and i have checked the formatting for the cells and it all appears
fine..Thanks in advance...
|
2 |
12/30/2008 5:46:18 PM |
|
|
Mail Merge to E-mail with Attachments - NEED HELP Please....
Hello,
I have tried to follow the steps mentioned by you, in the link below,
verbattim:
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
But, still I am quite UNABLE to send the "mail merge with attachment"
successfully (tried both with 1 attachment & 2 attachment) . I am not
getting any error BUT the VB script continues to show the output as: "0
messages sent" & there is no...
|
8 |
12/30/2008 6:49:35 AM |
|
|
word som e-mail editor
I Office 2003 var det muligt at bruge Word som e-mail editor. Der var en
knap, så man fik til, copy osv. frem. I 2007 versionen kan man tilsyneladende
kun sende et word dokument som vedhäftet fil. Og den der med copy/paste kan
da bruges, men er jo ikke ligefrem noget fremskridt....
|
2 |
12/28/2008 5:16:59 PM |
|
|
Mail Merge to E-mail with Attachments - NEED HELP Please....
Hello,
I have tried to follow the steps mentioned by you, in the link below,
verbattim:
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
But, still I am quite UNABLE to send the "mail merge with attachment"
successfully (tried both with 1 attachment & 2 attachment) . I am not
getting any error BUT the VB script continues to show the output as: "0
messages sent" & there is no...
|
2 |
12/28/2008 12:55:05 PM |
|
|
last numbers of the record
is there anyway to include the last # of a record on a label?
I'm trying to get the label to show as 1/10, 2/10,, etc. from a table.
--
Dilbert Firestorm
Opus is my Hero!...
|
9 |
12/27/2008 8:41:40 AM |
|
|
When using Mail Merge to Email, how can you attach documents?
I am using Office 2003 and pretty well versed in Mail Merge to Outlook... but
I can't figure or find a way to add attachments to the letter. I need to
send the word document as HTML email with 2 other Word documents as
attchments....
|
4 |
12/26/2008 8:28:28 PM |
|
|
multple pages of labels won't print from mailmerge via excel data
I am trying to create mailing labels from Excel data.
Defined name for list of addresses. This should be about 3 pages of labels.
But after going thru the mail merge wizard it will only create a single
page of labels. Everything works perfectly except it only pulls one page of
source data from the excel database, even tho I have defined much more data?...
|
2 |
12/26/2008 8:24:41 PM |
|
|
Mail merge outcome 0
I'm trying to mail merge datas from my Excel.. Unfortunately some of my
fields shows 0, instead of the actual text.. as oucome.. I have checked my
datasource.. excel.. state general....
|
2 |
12/26/2008 6:14:47 AM |
|
|
Merge Excel/Word 2007, getting 12:00AM in merge which is NOT in ex
Hi,
I am merging data from excel into a word document. I am getting data in
word that is showing "12:00AM", however, there is data in the excel sheet and
it is NOT a date and it is not blank - it is part of an address line, such as
"Deliver to Front Desk" or any kinds of words, but definately not a date and
not blank.
I have tried re-typing the data in excel, I have even put a " ' " ...
|
14 |
12/23/2008 2:48:11 PM |
|
|
Update All Labels results in skipped labels
I've reviewed and followed the posts suggestions on this issue but still only
the first and last rows of labels to display records. I'm using Word 2003. I
created a clean spread sheet of only 17 rows . There are no long addresses.
When I complete Select Your Data Source the first label is blank and all
others display <<Next Record>>. Then I select Arrange Labels > Match Fie...
|
4 |
12/23/2008 8:26:34 AM |
|
|
combine column data into a row
I am attempting to email clients that have mulitiple patients (animals).
Instead of sending each client numerous emails I would like to combine the
patients into one email. Is there a way to combine the names that show up in
different rows into one row?...
|
2 |
12/23/2008 2:34:07 AM |
|
|
Mail Merge - If statement
Hi
I have a mail merge letter to send to potential clients.
Some of the data in one merge field (<<Contact Name>>) is 'No Contact'. I
want to set a rule in the mail merge template that says when the data 'No
Contact' is merged it is replaced with 'The Manager'. Is there a way of doing
this?
(I know I could do Find and Replace ('No Contact' with 'The Manager') in
exc...
|
22 |
12/22/2008 11:38:28 PM |
|
|
Mail Merge / excel
I have a mail merge document that works fine except a couple of the field are
a percentage field , in excel i have formated it to 2 decimal points but wen
it merges to work, it show the whole number which is about 15 digits
any idea how to make it just the tow. is ok in excel but not in word...
|
10 |
12/22/2008 11:29:01 PM |
|
|
Formatting Date - not working for me
Hello,
I am pulling in a date from Excel and it is formatting as a number.
I have searched and see the example of
{ Mergefield Birthday \@ "MM/dd/yy" }
--
Thanks, Pat ...
|
4 |
12/22/2008 10:45:01 PM |
|
|
Using AND in a field code
I'm trying to use field codes, and distilled down to a test case with a
formula embedded in the first IF expression:
{IF {=AND(1<2,1<3)} = 1 "OK" "BAD"}
Looks simple enough - but I can't get this to display 'OK' - even when I
update the field. I did see it work - but now it's gone again. Seems utterly
unreliable. Is this a bug and is there a fix?...
|
3 |
12/22/2008 9:51:16 PM |
|
|
mail merge
I have 981 names that I am merging from Excel into MSWord to create labels
for our mailing. Everything says it has merged but only the first 30 names
on the list will print...does anyone know where the other 600+ names are? I
can't find them and it is frustrating...thanks,...
|
3 |
12/22/2008 4:36:01 PM |
|
|
Numeric Formate
Hi,
I want to display numeric numbers without spaces:
e.g.
1) if Price < 1000, e.g. 12.3, then it is displayed as "12.3"
2) if Price >= 1000, e.g. 10003, it is displayed as "10,003"
However, if I format is as : {Price \# ,##0.0}
1) will be displayed with spaces. e.g " 12.3"
The only workaround I can think of is format it as :
{IF {= Price / 100} < 0 "{Price \# 0.0}" "{Pri...
|
4 |
12/22/2008 10:48:00 AM |