|
Mailmerge to Lotus Notes Email
Hello,
I have a list with duplicate emails in Excel that I would like to distribute
via Lotus Notes email. The Data would look something like this:
Name Sold Email
Joe 3 Fred@aol.com
Hank 4 Fred@aol.com
Billy 5 Fred@aol.com
Tom 7 Sally@aol.com
William 5 Sally@aol.com
etc...
I wish to create a macro that would ...
|
6 |
5/18/2007 7:42:03 PM |
|
|
mailmerge automation from Access
i am doing a mailmerge automation from Access, works fine, however it seems
to think I wnat ot keep track of my cahnges to the document. How do I turn
this off (word 2003) Is this document of application (word) dependent?
Thx Philip
...
|
1 |
5/18/2007 4:32:15 PM |
|
|
Missing tables and queries in mail merge
Our firm uses Office 2003 (Access and Word)
We have general database with client and other information that was
programmed by an outside firm.
I created several smaller databases with tables linked to this general db.
We have letters and forms where I want to use the information from these
smaller dbs to do a mail merge.
However, when I create the document and then try to link the ...
|
5 |
5/18/2007 3:29:53 PM |
|
|
First Capital field formatting
Can anybody tell me why when my data is in capitals in the data source the
First Capital field format has no effect? I've tried using data from Word
table and Excel spreadsheet and both have the same problem. If I change the
data to lower case in the source then I can use the Frist Capital format. Not
causing me a major problem but seems a little bizarre.... I'm formatting just
by using ...
|
3 |
5/18/2007 2:58:00 PM |
|
|
How do you move file from mail merge to excel?
In my first attempt to use Mail Merge I created a long list of names,
addresses, and telephone numbers in Word. Now I need all the information in a
Excel spreadsheet and I cannot open the Mail Mergre file in Excel. Is there a
method to copy the file created in Mail Merge into Excel?. ...
|
3 |
5/18/2007 12:12:01 PM |
|
|
Edit Recipients dialog box - data shifted/scrambled
Hello,
I am working on a Word 2002 mail merge, with an Excel 2002 worksheet as the
datasource. (Using Windows XP Professional operating system.)
The data that we are previewing and attempting to filter in the Edit
Recipients Dialog Box has shifted on some records, i.e. in the Last Name
column, it shows some last names, but some first names. On those where it
shows the first names, t...
|
2 |
5/18/2007 9:50:31 AM |
|
|
Using my own custom return address "graphic" with labels
I've created, in Publisher, and using my company's name and logo and my
address, a return address "graphic" that I want to use on my Avery 5264
shipping lables. The company logo and name are one JPG graphic. The address
to my office I did in a text box. Then I grouped these two things to create
my "graphic".
I want this return to come up at the default return in my Avery 5264 mailin...
|
5 |
5/18/2007 7:10:46 AM |
|
|
MsgBox during merge
How can I code my merge document so that when the merge executes, at a
certain point in the last paragraph, a message box appears on screen to
remind the user to do something?
Blah blah blah [MsgBox: Don't forget to mail the voucher when the merge is
done!] Blah blah blah.
TIA,
Kathy
...
|
8 |
5/18/2007 6:47:56 AM |
|
|
Mail Merge Index
My mailmerge document displays the merge field's index instead of data. How
do I avoid this. Using MS Access 2002....
|
4 |
5/18/2007 3:42:04 AM |
|
|
Office 2007 Rules
I have placed a few runles in a merge document and Now I want to remove
them. I can not view the rules or see them anywhere. How do I remove them?
Kevin Bilbee
...
|
3 |
5/17/2007 9:05:56 PM |
|
|
Punctuating properly when mailmerging
I am currently writing a letter which includes for example, up to 3 different
deductions and rates. I have made the three mailmerge if formulas to only
bring through the ones that should be deducted but when I read the letter it
doesnt entirely make sense as it has not commas or "and"
At the moment i get
#% Tax #% NI #% Pension
What I would like is;
#% Tax, #% NI and #% Pension...
|
6 |
5/17/2007 6:50:40 PM |
|
|
lines of address missing on label
I am using Office 2007-the mail merge puts each field under one another so
the postal doesn't show. How can I get the city and state on the same line?
--
KJC...
|
2 |
5/17/2007 3:46:00 PM |
|
|
How do I retain my date formatting in Word?
When I run my mail merge, word is changing the format of the date. My excel
spreadsheet has the date formatted as "May 17, 2007". After the mail merge
is done, the date shows up in the body of the letter as "5/17/07". How can I
make word retain my date formatting?...
|
2 |
5/17/2007 3:45:09 PM |
|
|
Sharing Templates/Database on P2P Network
I'm trying to share my Access database and mailmerge templates that link with
that database with the other two users on our peer-to-peer network. I'm
having trouble in that the link to the database needs to be reset every time
a template is used on one of the other machines due to the difference in the
database location. Meaning, it's not on their C: drive. Is there a way for
these other...
|
4 |
5/17/2007 5:20:23 AM |
|
|
SKIPIF Error? Word 2000
Hello,
Is it possible that a SKIPIF statement could stop other formatting queries
in a document from working? I have been skating round this issue for the last
few days. I have a document that has some currency formatting queries in it,
and a SKIPIF statement at the top so that the document only generates for
specific criteria. Both the currency and skip statements came from this forum ...
|
3 |
5/16/2007 7:28:40 PM |
|
|
Maximum fields to merge from Excell
Hello,
I use Office 2007 for 2 weeks now and and try to merge more than 255 fields
from a xlsx file in word (docx). Both are in new format (.xlsx and .docx) and
my xlsx file contains more than 255 cols. Is it possible to merge more than
the limit? Can I change something in the options or so?...
|
2 |
5/16/2007 7:07:55 PM |
|
|
how do I add a field to the data source file address list once I .
I have started a address list for mail merge and want to add a field how can
this be done I have tried all the tricks I know....
|
2 |
5/16/2007 4:38:04 PM |
|
|
Excell Data not displaying properly
I have been trying to do a mailmerge where I can take student's grades from a
Excel Spreadsheet and show them in a report done in Word. I use Excel to do
my calculation and it diplays with the % sign that I need. When I do the
merge it shows a decimal point and a large string of numbers. I have tried
the Alt f9 and typing sent before but it just doesn't work.
Any help is appreciated....
|
3 |
5/16/2007 5:13:40 AM |
|
|
Email Merge w/ Word 2003 and Outlook 2007
I'm using Word 2003 on an XP machine to create an email mail merge from my
Outlook 2007 contacts. I get all the way through the merge wizard, enter my
subject line, and the records merge. BUT, Outlook doesn't do anything. None
of the messages are in my outbox or sent items? They simply don't get sent?
Any ideas? I've created several successful email merges using Word 2003 and
Outlook 2...
|
3 |
5/15/2007 6:40:02 PM |
|
|
Dollar signs from Access data to Word in a Mail Merge?
In doing a mail merge in Word 2007 my dollar signs and decimal places don't
carry over from my Access query. Suggestions?...
|
5 |
5/15/2007 4:18:01 PM |
|
|
IF Statement Hierarchy - Word 2000
Hello,
Is there a hierarchy in an IF statement? I ask because I have a mailmerge
that is looking at certain criteria to generate a particular letter version
if that criteria is met, so it says { IF { MERGEFIELD field1 } = 2 "{ IF
{MERGEFIELD field2 } = 1 "LETTER" "" }" }
I should say, that within the merge, there are 2 variations of the above,
the other being { IF { MERGEFIELD field1...
|
8 |
5/15/2007 3:41:01 PM |
|
|
Dialog Box Alert upon opening a mail merge main document
Hi,
I have created a document that I use for a mail merge from an Access DB I
have.
The actual mail merge runs from within my DB - that all works great.
Every time I open the Word document, I get the following message:
Opening this document will run the following SQL command:
Select * from ... <THE SQL STATEMENT FROM MY ACCESS APP
Data from your database will be placed in th...
|
2 |
5/15/2007 3:13:17 PM |
|
|
mail merge -- attachment at bottom of email
Hi,
I've been using the Doug Robbins instructions for attaching files to a
mass email, and (to this point) everything has worked great. Here's
my question:
When I run the macro, the first character of my message is replaced
with my first attachment. For instance, if my message is:
"Hi. Thanks for the attachment."
I get: "<<AttachedFile>>i. Thanks for the attachment."...
|
3 |
5/15/2007 1:46:41 PM |
|
|
Too Many Data Fields in Mail Merge
I am working in Word 2003 mail merge and using a .csv data file as the data
source file. The CSV file has the field headings as a header. Lately,
every time I try to merge from the .CSV data file to the merge letter, I get
the message "Too Many Data Fields." I then have to click 'ok' to contunue.
A few letters will merge ok and then this message pops up again. Is there
some setting ...
|
10 |
5/16/2007 8:11:37 AM |
|
|
Conditional page eject in "Catalogue" mail merge
I have a mailmerge of type "catalogue" and want to insert a page
eject when a certain field changes. How do I do that?
Let's say, this controlling field is called "Zimmer_Nr", as German
for Room_No.
I haven't done Winword programming for at least half a year and
can't remember how to do it, but I would need it for tomorrow...
MS-Office 2000, data source is an Excel ...
|
10 |
5/16/2007 4:43:40 PM |