Reply
 
Thread Tools Display Modes
  #1   Report Post  
Freny
 
Posts: n/a
Default 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   Report Post  
Doug Robbins
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
2003 Small Business - Mail Merge from Excel Sheet Duplication Oddi Los Mailmerge 1 May 4th 05 02:52 PM
Carrying Excel cell properties into word when mail merging RIPage Mailmerge 1 April 26th 05 09:21 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 16th 05 12:38 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 11:46 PM
Excel dates formatted d/m/yy convert to m/d/yy in mail merge GayleT Mailmerge 1 November 29th 04 03:43 AM


All times are GMT +1. The time now is 05:37 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"