#1
|
|||
|
|||
showing results of If statements in a mail merge
I am using a mail merge to create a multi page document that highlights a different company on each page. The information about each company is coming from an excel spreadsheet. Since it is not a typical word merge.. I am having some issues- all of which I did not have under Office 2007. I am now on Office 2010. Here are the areas that will not show up properly-
1) phone numbers. Not all of the phone numbers have extensions, so I can't simply format the number using this switch (000) 000'-'0000 2) I am pulling in the results of formulas- the are all words, but come from a variety of separate excel sheets. Sometimes the formulas are blanks and other times they are a character (a bullet, so be precise) that is concatenated with text. Any ideas on how to format the merge fields so that they will look correct in my merge? Thanks for your help!!! |
#2
|
||||
|
||||
Hi m&co,
Without knowing how the data appear in the source, it's hard to advise. For the phone numbers, the issue will likely be that the phone number format in Excel is just a formatted display whereas, if you have an extension in the same column, that will not be a number but a text string. This can lead to problems with mailmerges because, if you don't have text strings in the first few rows, the mailmerge algorithms will assume all the data should be numeric and any text string will be evaluated as 0. What you should have is numbers in one column and extensions in another. It's also not clear what you mean about data coming from a variety of spreadsheets - Word can only use a single file as a mailmerge data source. Whether text formatting such as bullets will come through largely depends on which data connection method you use. DDE tends to work best at preserving formatting.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Sorry.. I know my post was a little unclear. This is the formula that shows up in excel..
=IF('F:\Fund VI\company data\[company data sheet- AT.xlsx]Sheet1'!K4="","",CONCATENATE($A$186,'F:\Fund VI\company data\[company data sheet- AT.xlsx]Sheet1'!K4)) Basically, the company data sheet-at.xlsx is a separate spread sheet and the contents of the field, if any, is text. If the text field is blank, the resulting formula shows up as a blank. If it contains text, the formula show up as a bullet and then the text from the other spreadsheet. It used to populate the results correctly on my mail merge. This is what my result now looks like... the 12am is when there is text, and the 12:00:00 AM ● 0 ● 0 ● 0 Also, even though some of my numbers have extensions (Which I can easily put in a separate row), the rest of them are formatted as special text- phone numbers. I changed that thinking maybe it would help- previously they were just numbers. However, no matter how I format it the result is 12:00:00 AM Please let me know if that helps clairfy things at all How do I determine the data connection method? Sorry, I'm really a bit over my head here... |
#4
|
||||
|
||||
Hi m&co,
Can you post a cut-down copy of your workbook and mailmerge main document? Delete anything sensitive beforehand.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
currency not showing correctly on mail merge | tonywatsonmail | Mail Merge | 1 | 12-07-2011 04:29 PM |
Saving INDV mail merges During the mail merge | sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |
Deleting records/results from mail merge | alexb123 | Mail Merge | 2 | 08-12-2011 02:27 PM |
Unread mail not showing up in Inbox - Outlook 2007 | ayaz_rn@hotmail.com | Outlook | 0 | 04-30-2009 11:32 AM |
IF statements that shifts to right. | kent | Excel | 0 | 01-19-2006 02:23 PM |