Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge does not accept formatted cell of Excel
We are trying to mail merge from Excel to Word.
- The $ sign in Word is not captured from Excel as the cell is formatted with the Currency sign - Also when we are creating a roster list or directory that has to be merged from Excel to word where phone numbers are concerned the brackets created in Excel through the format route is not captured by the mail merge in Word. Could you please explain the procedure for this merge field. Thanks Freny |
#2
|
|||
|
|||
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Freny" wrote in message news We are trying to mail merge from Excel to Word. - The $ sign in Word is not captured from Excel as the cell is formatted with the Currency sign - Also when we are creating a roster list or directory that has to be merged from Excel to word where phone numbers are concerned the brackets created in Excel through the format route is not captured by the mail merge in Word. Could you please explain the procedure for this merge field. Thanks Freny |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003 Small Business - Mail Merge from Excel Sheet Duplication Oddi | Mailmerge | |||
Carrying Excel cell properties into word when mail merging | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge | |||
Excel dates formatted d/m/yy convert to m/d/yy in mail merge | Mailmerge |