Query to Mail Merge issue

I am running Access2003 on WinXP SP2.
I send out dues letters for members of a retiree group.  When I try to do a 
mail merge to my Dues Query all goes fine except the telephone number in the 
query which is (555)555-1234 comes out 5555551234.  If I copy the query into 
an excel spreadsheet and use that as the datasource for the mail merge it 
works fine.

Is there something I need to do to format the query so it merges with the 
right format.
Thanks
Billa
0
Utf
12/22/2007 8:30:00 PM
access.queries 6343 articles. 1 followers. Follow

2 Replies
769 Views

Similar Articles

[PageSpeed] 11

In the query format the field to include the parentheses and dash.  In query 
design view, instead of the field name put an expression along the following 
lines in the field row of the design grid:

TelNoFormatted:Format([TelNo],"(000)000-0000")

Where TelNo is the field name.  The query will return a column named 
TelNoFormatted, so you'll need to refer to that rather than the field name 
when merging.

BTW you might like to take a look at the following link from which you can 
get a demo of various Access to Word automation operations, showing how to 
mail merge, fill word tables. insert values at bookmarks etc., all from 
within Access:


http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=ws-msdevapps


Ken Sheridan
Stafford, England 

"BillA" wrote:

> I am running Access2003 on WinXP SP2.
> I send out dues letters for members of a retiree group.  When I try to do a 
> mail merge to my Dues Query all goes fine except the telephone number in the 
> query which is (555)555-1234 comes out 5555551234.  If I copy the query into 
> an excel spreadsheet and use that as the datasource for the mail merge it 
> works fine.
> 
> Is there something I need to do to format the query so it merges with the 
> right format.
> Thanks
> Billa

0
Utf
12/23/2007 10:53:01 PM
Thanks Ken, I'll give it a try.

Bill Alsdorf
Brighton, Colorado

"Ken Sheridan" wrote:

> In the query format the field to include the parentheses and dash.  In query 
> design view, instead of the field name put an expression along the following 
> lines in the field row of the design grid:
> 
> TelNoFormatted:Format([TelNo],"(000)000-0000")
> 
> Where TelNo is the field name.  The query will return a column named 
> TelNoFormatted, so you'll need to refer to that rather than the field name 
> when merging.
> 
> BTW you might like to take a look at the following link from which you can 
> get a demo of various Access to Word automation operations, showing how to 
> mail merge, fill word tables. insert values at bookmarks etc., all from 
> within Access:
> 
> 
> http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=ws-msdevapps
> 
> 
> Ken Sheridan
> Stafford, England 
> 
> "BillA" wrote:
> 
> > I am running Access2003 on WinXP SP2.
> > I send out dues letters for members of a retiree group.  When I try to do a 
> > mail merge to my Dues Query all goes fine except the telephone number in the 
> > query which is (555)555-1234 comes out 5555551234.  If I copy the query into 
> > an excel spreadsheet and use that as the datasource for the mail merge it 
> > works fine.
> > 
> > Is there something I need to do to format the query so it merges with the 
> > right format.
> > Thanks
> > Billa
> 
0
Utf
12/24/2007 1:01:01 AM
Reply:

Similar Artilces:

PowerPoint 2007 / 2003 "Compare & Merge" crosswalk?
I cannot find the "Compare and Merge Presentations" function on 2007. The tutorial says some of 2003 functions were lost, and you should check with online help. Have not been able to locate anything equivalent or close in 2007. That feature was removed from PPT 2007. It's back (and better) in PPT 2010, though. PPT 2010 is in beta right now. -- Echo [MS PPT MVP] http://www.echosvoice.com "Confused Presentor" <Confused Presentor@discussions.microsoft.com> wrote in message news:0436F244-FE21-449D-9F85-F02788E0BFE0@microsoft.com... > I canno...

How to create report from Pivot Table View of Union Query?
Hi all, I have create a Union ALL Query. I want to generate a report from it. The Pivot Table View of this Union Query shows exactly what I want (having Row Heading, Column Heading and Detailed Data), so how can I make it as a Report? I have tried to create new report, but there is no options of making a pivot table (something like Crosstab Query and Pivot Table View of the Union Query). Also tried to export to Excel, but it shows only count of records. I want all detailed records. Thank you. -- Message posted via http://www.accessmonster.com Hi Duane, I tried to create a crosstab qu...

Windows mail comes alright but then disappears
Hello, Background I run my Gmail thorugh Windows mail. The settings in Gmail is activated for pop. The settings in Windows mail are “recent: my.name@gmail.com”. The server port settings are 25/995. Furthermore I use Windows Vista, F-secure, Internet Explorer 7. Windows Mail arrives alright. To the inbox. I can open it and so on. Problem comes when I have a look in another folder in Windows mail, such as sent or junk. Then the newly arrived mail just disappears from the Windows mail. It can still be found in the Gmail, but that´s not what I want. What am I doing wrong...

Zip codes in mail merge
Office 2007 - used spreadsheet to create an address list; zip codes appear correctly in spreadsheet but when using spreadsheet as a mail merge document, the first digit disappears in the zip code field, i.e., 05401 becomes 5401. =text(a1,"00000") or use Word field formatting codes: Mail merge Excel to Word: a.. http://www.mvps.org/dmcritchie/excel/mailmerg.htm b.. http://www.mvps.org/word/FAQs/MailMerge c.. http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx d.. http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm e.. news:microsoft.publi...

Thanks for all the help on Year-to-date query!
It's so great to know that there are folks out there that can take the time to help someone whose 78 year old brain is slowly turning to gorgonzola cheese! Again, thanX Mikie Francisco 9 @ ATT N E T ...

Add Movie to Outlook E-Mail Message via "Web Tools" toolbar--question
Using Outlook 2003 (in fact all of Microsoft Office 2003), and have Word selected as e-mail editor. Windows XP Pro with all updates. Recently I discovered on the Office web site a way to insert a movie (inline) to an e-mail message. I have one question about its implementation. If (in an HTML-formatted e-mail, and Word selected as e-mail editor) with the cursor in the body of the message, you click on "View", "Toolbars", you can select a toolbar called "Web Tools". On that is an icon that says "Movie". If you click on it you can add a movie to the e-ma...

Query from Multiple Workbooks
Hello, I have 12 files in a directory with a sheet name Sales containing Sales data for each month having more than half a million rows in each workbook sheets The field names are all the same in all the files like date, item, itemgroup, branch, unit, salesman, amount etc I am looking for a way to get a query from all these workbook and get a summarised report based on criteria like sales by salesman, by month, by product, by product group, by date, by branch etc. Is this will be possible through code?. Itry to use MS query but not successful Using Excel 2007 and Win XP ...

Forward mail through other smtp server.
I have exchange 2003 with sp1. My ISP started blocking port 25 and forcing me to send mail through thier server. Is there any way I can send my exchange mail through their server or curcomvent thier port 25 rule? Thanks Eric On your Internet Mail Connector forward your mail to their server instead of using DNS (aka smarthost) Greetings Hans http://fots.nl "Eric" <ericsweb@madison.tds.net> wrote in message news:fffd36e5.0411240934.9b56ee2@posting.google.com... >I have exchange 2003 with sp1. My ISP started blocking port 25 and > forcing me to send mail through th...

forward exchange 2003 mail to external email #2
hi anybody knows how to do this? i tried this but it didnt work http://www.msexchange.org/tutorials/mf015.html its ok now..i just create another account..and and configure an external mailbox to that account..and then on the first account, i just put a forward to under delivery options the another accoount..:> :> ...

merging two accounts
This seems like something that should be easy, but it's totally stumped me. I use my laptop at home and at work. At work, I log onto a domain, so that I actually have two accounts on my laptop: "username" and "username.domain". So far so good. My problem is that I use the same email accounts both at work and at home. To avoid having two independent Outlooks on my computer that check the same email accounts, I moved the data file (.pst) locations of both accounts to one place. This worked fine, and when I opened Outlook from both accounts, it shows the sa...

Query to Redistribute a Table
Hi I am struggling with how to query a table with the current structure: Field1 Field2 ...Field14 Jan Feb Mar Apr... x y ...z 10 15 13 16... etc, It represents sales per month to customers per delivery adress, product and so forth.The numbers under each month respresents the sales for that month. I need to be able to query so I can see all detalis (ie fileds 1-14) per row per month, ie redistribute that original table so I can use month as a field and still use all the original fields. My new table needs to be something link Month Field 1 Field2 ... Field14 New ...

2007 dst issue
the client i support currently has about 20 exchange 2003 sp1 servers (mixed FE/BE (mostly clusters) PF, BH) i am putting a plan in place to move to sp2 early next year i have since come across article 926666 regarding the post sp2 exchange update for 2007 dst change i have built a test environment to successfully create this issue i have a 2003 sp1 dc and a 2003 sp1 server with exchange 2003 sp2 including the windows dst update but not the exchange update i then created a test mailbox and from outlook setup 5 calendar entries the week of march 26 at various times when viewing in OWA, al...

Outlook integration issues
We're running Outlook 2K3 and the CRM client with ver. 1.2, when I try to import the contacts list it tells me that Outlook cannot be started even if it is running. Can anyone assist me with troubleshooting this issue. ...

How to reorder email accounts in Mail view?
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: Exchange Is there a way to change the order that email accounts display on the left side in Mail view? Hi, sorry, you can't change that. The accounts are ordered alphabetically, with the default account on top. On 22/02/10 18:51, spamtarget@officeformac.com wrote: > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: > Intel Email Client: Exchange Is there a way to change the order that > email accounts display on the left side in Mail view? -- Mi...

CRM Report Issue
I designed a custom report to run pending activities & assigned activities of current loggin user. This report is running in report server and showing current user's assigned activities. i am passing current user name in parameters as @User Name from sql query. After deploying this report into crm. its throwing an error message like this. "An error has occurred during report processing. The Value expression for the query parameter =91@UserName=92 contains an error: Index was outside the bounds of the array" The current user name passing from crm report as "...

lost e-mails 08-24-10
I am losing my e-mails after I open them. They are disappearing from the inbox . I believe they are still being saved somewhere, but don't know where, or how to locate and fix the problem. Please help.. anyone. Thanks -- len While in the Inbox: View | Current View. Show All Messages should be the only option checked. -- Bruce Hagen MS-MVP [Mail] Imperial Beach, CA "len" <len@discussions.microsoft.com> wrote in message news:55E726CD-8CF1-4CCE-B559-B514974DF4DB@microsoft.com... >I am losing my e-mails after I open them...

Update Query ctnd:
Hello, I have tried the code from Arvin however I now get 2 paramater prompts. The 1st is for "transactions.Datefield" and the 2nd "Please enter Waiting or Pending" UPDATE transactions SET transactions.Status = "Cleared" WHERE (((transactions.datefield)<Date()-10) And ((transactions.Status)=[Please enter Waiting or Pending])); Can I run this procedure atomatically when the database opens without the prompts & user input Thanks The first prompt implies that datefield isn't the actual name of the field in your transactions table. The second prompt...

Can't access send/receive under mail setup
I am using Outlook 2003 with exchange. I want to add a pop3 account. The Pop3 account sends but won't receive (although the Outlook test message is fine). When I go to tools/options/mail setup and push the send/receive button, nothing happens. I have just installed a new hard drive. This worked on the old one, and on other computers. I have recreated the profile from scratch but I have the same problem. What's going on? Can someone help me? -- Thanks. Sammie SBS 2003, OFFICE 2003, XP-PRO-SP3, IE7 ...

Issue writing IF OR Error Formula Types
Having trouble putting a formala together. I have the following formula which works: Senario : $d$d = either weight or unit or unknown (of an ingredient) e8= is a quantity number ( either in grams or units, o an ingredient. eg 100 or 1) Raw data is in nutrition!$b$6:$g$70 The following formula works so far: f8 ( which is the no. o calories)=if($d$d="weight",e8/100,e8)*vlookup(c8,nutrition!$b$6:$g$70,3,false) But I also want to add to it that If e8(quantity)=0 or blank or invalid then "qty?" should appear in th f8 cell And not sure what to do to avoid an error in f8...

Query All records except latest
Access 2003 I need to limit my query to ALL RECORDS EXCEPT the most current record. Any ideas on how to do this -- deb Deb - It will look something like this, assuming no more than one record per date per key field. You can adjust to use date/time if that is needed. It depends on what makes your records unique. Try something like this, substituting your table and fieldnames... Select myKeyfield, field1, field2, field3, myDate FROM myTable Where myDate < (Select max(myDate) from myTable AS T2 WHERE T2.myKeyfield = myTable.myKeyfield) -- Daryl S "d...

Discover card issues
I spoke with customer service tonight because after I connected to Discover through Money, the logon page showed a different card #. It turns out Discover is assigning new card #s (to what group of cardholders I do not know). She did say the direct download problem was fixed. And indeed it did download one transaction and opened a new account with the new card #. It appears impossible to retrieve by direct download the transactions that had been missing (due to download problems) before the card # was changed. The fix I guess will be an indirect statement download when the next statement...

How do I print mailing labels?
By using word's mail merge. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Join OneNote Tips mailing list: http://www.onenote-tips.net/ "ckjt" <ckjt@discussions.microsoft.com> wrote in message news:DF2392CF-BA1E-48BF-8F1D-F87A16CFE6AC@microsoft.com... > Use Word... Mail Merge -- Cheers, Alpho...

receiving double e.mails
In my inbox in Outlook everytime I get an e.mail there is always 2 of the same e.mail coming through-Can anyone help me with this Please? What version of Outlook are you using? Sounds like you may have duplicate accounts pulling e-mail from your mailbox. Or perhaps a misconfigured rule that is duping your received messages? -- -Ben- Ben M. Schorr, MVP Roland Schorr & Tower http://www.rolandschorr.com http://www.officeforlawyers.com/outlook.htm "Louise" <Louise@discussions.microsoft.com> wrote in message news:82D90374-7B29-4648-96EB-D3F2C288C757@microsoft.com... >...

MS Query cannot be started because it isn't installed
I'm trying to get External Data from SQL Server using my Excel 2000, but it says MS Query cannot be started because it isn't installed. I've installed the MS Query Add-in severals times and it's still not working. Does MS Query work with Excel 2000? ...

Create a Group Mailing List
I have created mail groups in the past, but now cannot. I have also read all the directions on this message board, but nothing works for me. Help! Why can't you? Are you missing the buttons on the toolbar? Missing buttons from the Windows Contacts toolbar http://www.vista4beginners.com/Missing-buttons-from-Windows-Contacts-toolbar Vista - "New Contact" and "New Contact Group" Button Missing http://www.vistax64.com/tutorials/186477-new-contact-new-contact-group-button-missing.html -- Bruce Hagen MS-MVP [Mail] Imperial Beach, ...