Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2012, 10:19 AM
m&co m&co is offline showing results of If statements in a mail merge Windows 7 64bit showing results of If statements in a mail merge Office 2010 32bit
Novice
showing results of If statements in a mail merge
 
Join Date: Jan 2012
Posts: 2
m&co is on a distinguished road
Default 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!!!
Reply With Quote
  #2  
Old 01-05-2012, 02:01 PM
macropod's Avatar
macropod macropod is offline showing results of If statements in a mail merge Windows 7 64bit showing results of If statements in a mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,212
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
  #3  
Old 01-06-2012, 08:54 AM
m&co m&co is offline showing results of If statements in a mail merge Windows 7 64bit showing results of If statements in a mail merge Office 2010 32bit
Novice
showing results of If statements in a mail merge
 
Join Date: Jan 2012
Posts: 2
m&co is on a distinguished road
Default

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...


Reply With Quote
  #4  
Old 01-06-2012, 07:27 PM
macropod's Avatar
macropod macropod is offline showing results of If statements in a mail merge Windows 7 64bit showing results of If statements in a mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,212
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
showing results of If statements in a mail merge currency not showing correctly on mail merge tonywatsonmail Mail Merge 1 12-07-2011 04:29 PM
showing results of If statements in a mail merge Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
showing results of If statements in a mail merge 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft