|
Word mail merge to email account with pdf attachment
Hi,
Every month i need to send salary slip to my employees. I do this by using
mail merge application picking up the data from my paysheet which is in excel
and send the payslip in html format to the concerned employee. Now, i want to
send the same payslip to the respective employee through the same mail merge
concept but each payslip should be sent as pdf attachment.
Is this possib...
|
7 |
10/31/2008 2:09:00 PM |
|
|
Mail Merge Problems Word 2003
Can someone help? Doug Robbins provided a url to a site, but the information
did not help... I have been to numerous sites trying to solve this problem.
I am using 2 columns and 61 rows of a multi-column spreadsheet as my
datasource in a mail merge to a Word document..... I don't want a
one-of-many, I want all the records, regardless of whether they are
replicated in the list or not. ...
|
4 |
10/31/2008 12:45:51 PM |
|
|
Excel Formats and IF
Hi there
I'm doing a mailmerge from an excel spreadsheet. It has a variety of time
values, dollar amounts, and rounding.
While I have worked out how to write the code to include the formatting, how
do I extend this so that blanks show as either nothing or N/A?
Time fields currently have this:
{ MERGEFIELD Mon_Start \@HH:mm }
Blank time fields are showing as "00:00" and I need them to ...
|
5 |
10/31/2008 6:25:44 AM |
|
|
removing first character in mergefields
I am trying to do a calculation with merge field data. However, my data is a
formatted number with a $ at the beginning. Changing the original data to a
number only is not an option. I am working with Word 2003.
By reading earlier posts I have figured how to do the actual calc I just
don't know how to get it to ignore the preceding $.
Data: $875.00
Would like to take monthly amou...
|
3 |
10/30/2008 8:30:01 PM |
|
|
Form Fields go missing during Mailmerge
Is there any way to keep form fields from being deleted or restoring them to
the original document after the mailmerge process?...
|
2 |
10/30/2008 7:37:22 PM |
|
|
Formatting Nubers in Word Table after Mail Merge
I have created a mail merge that draws information from a spreadsheet (Excel)
and places a series of dollar amounts into a table in the Word document. The
problem is that the numbers on the Word document don't follow the dollar
format as set up in the Excel spreadsheet so I get values like 113247.1
instead of $113,247.10.
Is there a way to change the format of these cells in the Word t...
|
2 |
10/30/2008 5:09:22 PM |
|
|
Word 2007 Data Source Problem
I have a Word 2003 mail merge document. Its data source is a Word 2003
document containing a table. The table's first row contains the field names.
I have been able to make changes to the data source and then save the
changes. I recently updated to Word 2007, and I can no longer save my data
source changes - it tells me the file is read only, but it's not. Help!...
|
9 |
10/30/2008 1:23:03 PM |
|
|
How do I use field codes to format a number into currency?
I would like to format my numbers in a mail merge to be shown as Currency so
with $ and 2 decimals. I know I can do this with a field code but can't get
it to work....
|
7 |
10/30/2008 1:11:01 PM |
|
|
Persistant Data Source in reusable documents
How do I create a reusable mail merge document which remembers the file name
of the data source and automatically opens the data source file whenever the
document is opened?...
|
4 |
10/30/2008 9:40:41 AM |
|
|
Word (2007) cannot find its data source
In Word 2007, when I open a previously created mail merge document, I get a
dialog:-
XXXXXXXX.docx is a mail merge main document. Word cannot find its data
source, Y:\xxxx_data.csv.
And when I click "Find Data Source...", I can locate the data source file,
but selecting it doesn't work as it gives me the same dialog again.
What have I done wrong here?...
|
1 |
10/29/2008 10:24:01 PM |
|
|
How can I make a show/hide text box that contains a table?
Question is about MS Word 2003. I consider myself a WORD expert but I'm
stumped. My office uses a document template which contains a table within a
text box. The table/text box can be toggled to appear or disappear by
clidking on a a "SHOW/HIDE GRID" button on the tool bar. I have gone through
all the HELP topics and can find nothing about how to make this type of
show/hide table or ...
|
2 |
10/29/2008 9:43:02 PM |
|
|
Maintain excel formats in a word mailmerge
Hello all,
I am trying to finish a mailmerge from an excel database, but for some
reason the formats are not staying with the information when it comes through
the mailmerge. I was told it had to do with the DDE in the advanced options
of excel, but it didn't seem to work. Could anyone enlighten me?...
|
3 |
10/29/2008 7:50:09 PM |
|
|
Mail Merge & INCLUDEPICTURE Not Working
I'm trying to setup a mail merge to generate ID cards from a CSV file.
However, after following the instructions in the MS Knowledge Base on how to
use Mail Merge with Images (http://support.microsoft.com/kb/909132) I still
cannot get it to work.
What happens when I generate a new document from the data is that I get x
number of pages saying "Error! Filename not specified". If I do an...
|
3 |
10/29/2008 7:40:02 PM |
|
|
Email Merge with Attachments Being Overwritten
I've been successfully using Doug Robbin's macro to send email merges with
attachments, but I've run into a problem when I send more than 1 attachment.
It looks like only the last attachment gets sent -- almost like my Word
document isn't set up properly and the first attachment is being overwritten.
Has anyone ever had this issue before, and can you suggest a fix -- thanks....
|
3 |
10/29/2008 12:19:01 PM |
|
|
Ignore merge field codes when field doesn't exist
Hi, I work at a charity, and we have a template letter document that prints
different receipt letters depending on different donations.
Sometimes, raffle tickets will have been purchased, and we need to add the
ticket range info to the letter. The problem is that letters without raffle
ticket information don't have ticket info fields in the data. Therefore, I
get "Error! MergeField w...
|
3 |
10/29/2008 7:56:05 AM |
|
|
MULTIPLE SIGNATURES - 1 WORD DOC
We have a word doc and need to mailmerge to a file to print personalized
letters.
We have 11 different signatures(in separate files) and the 11 different
names in a field in the excel file.
Can someone help me out on how to mailmerge and get the different sigs to
print respectively. Cannot figure out how to put the sigs into one file, if
needed? and then how to tell the word doc where...
|
3 |
10/29/2008 7:39:26 AM |
|
|
Format SSN to keep leading zero's
I’d like to format the SSN so that mail merge does not drop the leading
zero's. Currently I’m using the following switch: {MERGEFIELD
SEC_MORTGAGOR_SS_NUMBER\# ###'-'##'-'####}. While the switch does insert the
dashes any leading zero's are dropped. So, 012345678 becomes 12-34-5678 (I
want the field to format as 012-34-5678). Any suggestions?
Thanks,
Manuel
...
|
2 |
10/29/2008 1:41:19 AM |
|
|
Nested If statements
I have been working with nested if statments and trying to find if there is a
limit to the number of nested IF's that you can have? I have 3 working and
when I add a fourth, the whole statement fails.
thanks for any info...
|
3 |
10/28/2008 7:48:08 PM |
|
|
Creating Labels with Mail Merge
In Word 2007, how do you create a sheet of different mailing labels using
excel as the data source to merge.
I was able to create the labels and used the Replicate Option and clicked on
UPDATE all labels - but it update the top and bottom row but skips the middle
labels. Then it takes the second person and puts the second person first on
the next page and repeats them again and so on......
|
6 |
10/28/2008 7:06:44 PM |
|
|
Perform mathematical calculations with merge fields
I have a letter that we created in Word 2000 that I need to update. I can't
open the document in Word 2003, so I'm recreating it. The document contains
several merge fields. I want to perform a multiplication of a merge field
(which is a number) by a set number (in the example it's 35). I used the
{=35*{mergefield xxx}\#,0.00\*Mergeformat} in Word2000, but I can't get it to
calculate...
|
14 |
10/28/2008 5:25:01 PM |
|
|
Mail Merge Word 2003, VB.NET 2008, CreateDataSource
Hi there,
I am trying to programmatically create an .ODC in my application and assign
it to a template for mail merge.
So far I have recorded a macro setting the .ODC up and cut and paste the
macro code into my application:
myDoc.MailMerge.OpenDataSource(Name:= _
"C:\Documents and Settings\cb\My Documents\My Data
Sources\RRS-MSSQL-DEV SUPPORT ctrl_users.odc" _
, Co...
|
2 |
10/28/2008 5:17:58 PM |
|
|
Mail merging labels: labels not advancing per page
I used the Merge Wizard to get my labels set up. Each page has 12 labels
which are showing up sequentially: Vendor A on the first label, Vendor B on
the second and so forth. However, when I scroll to the second page of labels,
it's starting the page with Vendor B from the merged spreadsheet instead of
the Vendor M. Each sheet starts with the following vendor from the first
label area on ...
|
3 |
10/28/2008 5:12:08 PM |
|
|
If statements
Is there a way to use IF statements within a mail merge? I'm using an excel
file as my data source. I have the prefix merge field, but about half of the
data entries have none. So when I merge in Word, the prefix field is skipped
(as it should), but I still get that space in between where the prefix would
go and the person's first name. Is there some sort of IF field where I could
basica...
|
6 |
10/28/2008 3:53:01 PM |
|
|
Percentages in word 2007 via merge with excel
I am having trouble with converting the percentages from 14 digits ( or so
)to a simple 54% display ( for example ) I have tried the *100 code but
am having problems, perhaps i'm typing it in wrong, can someone paste me the
code on here please...
|
4 |
10/28/2008 10:28:07 AM |
|
|
Data source for mailmerge not selecting all data - PLEASE help!
Hi all,
I am wondering if someone could please help - I am lost/baffled as to what I
may be doing wrong. I'm doing a mail merge using an excel table as my data
source. When I choose OLE DB Database Files, all of my data is selected, I
can filter accordingly and complete the mail merge. However, there are many
cells in my worksheet which contain more than 256 characters, so these come
...
|
4 |
10/28/2008 6:12:31 AM |