473,326 Members | 2,134 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

When I import (?) data into word through a mail merge, how do I keep format

emandel
65
So I am importing data from a query into MS word for a mail merge, and one of the fields is a $ amount. In Access it is formatted properly as a currency and shows up fine on the screen (e.g. $24,000), but in MS Word, when I run the merge (or preview it) it comes out without the $ and with out the comma (e.g. 24000).

Please help
Aug 29 '10 #1
1 1529
missinglinq
3,532 Expert 2GB
I think the formatting has to be done on the Word end. Here's a link on the subject:

http://office.microsoft.com/en-us/wo...in=EC001022717

About two-thirds of the way down the page they actually use currency as an example of formatting text.

Linq ;0)>
Sep 6 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Steve M | last post by:
I'm trying to do invoke the mail merge functionality of MS Word from a Python script. The situation is that I have a template Word document, and a record that I've generated in Python, and I want...
1
by: S Taylor | last post by:
I am running MSWord VBA code from within Access VBA that merges a Word mail merge document to the printer, using data in Access. In Office 97 it worked fine, but in Word 2003 a new message comes up...
0
by: Fred Zolar | last post by:
Is it possible to use a SQL Server stored procedure as a datasource for MS Word mail merge? If yes then how?
2
by: VB Programmer | last post by:
I have a database with customers. I aslo have a simple HTML newsletter: Hello ! Your address is , , . You work for . Here is your logo: . I want to let the user: 1. Edit the newsletter in...
0
by: pnr | last post by:
I transferred my database to a new computer. I can open it in 2003 Access, but am keeping it in the 2000 version until I get it working correctly. I have dozens of Word documents where I use...
1
by: aeh | last post by:
I want to do a Word mail merge with several detail records for each address, example: orders in the last month for each customer. Thanks
2
by: veaux | last post by:
I have single integers representing a month (i.e. 2) and need to convert this to (March 1, 2007). So "2" represents really the end of the previous month. I'm using MonthName and adding 1 in my...
1
by: Joe M. | last post by:
What is the best method for driving a word mail merge from data obtained from a vb form? Is it Word version specific? That is, will we need to rebuild the app after upgrading to Word 07? thx.
1
by: TommyGunn | last post by:
Hi everyone, Is there anyway to automatically put Access data into Mail Merge in an existing Word doc with content? I have bits and pieces of this done, but I can't seem to put it all together....
0
by: YY | last post by:
For some reason my word mail merge throws execption when it reaches wrdMailMerge = oDataDoc.MailMerge. Can any body guide me in a clean wasy of doing mailerge from sql server 2005 table ? I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.