Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
mike_mike
 
Posts: n/a
Default putting tabs in a mail merge field?

Hi

i standard letter with merge codes
{address}

Dear sir

These companies are in breach..
{mydata}

I want to all the following data into {mydata}
2005 tab Company 1
2006 tab company 2

I am merging from excel how do i get the tabs into word as they seem to be
turning to spaces? I do have them in the excel using char(9) in the source
data ..I do not want to use a list/catalog/directory merge just a standard
letter.


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default putting tabs in a mail merge field?

Which version of Word? When I try to do this in Office 2003, the tabs come
across no matter which way I connect to Excel (DDE, OLEDB, ODBC). (They do
/not/ come across if I just copy/paste into Word, unless I use Edit|Paste
Special and choose, e.g. RTF formatted text rather than HTML format).

Peter Jamieson
"mike_mike" wrote in message
...
Hi

i standard letter with merge codes
{address}

Dear sir

These companies are in breach..
{mydata}

I want to all the following data into {mydata}
2005 tab Company 1
2006 tab company 2

I am merging from excel how do i get the tabs into word as they seem to be
turning to spaces? I do have them in the excel using char(9) in the source
data ..I do not want to use a list/catalog/directory merge just a standard
letter.




  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
mike_mike
 
Posts: n/a
Default putting tabs in a mail merge field?

I'm using 2002 word and i'm not connecting to excel. I'm
running the word mail merge from excel VB code , and opening word up from
there..


"Peter Jamieson" wrote:

Which version of Word? When I try to do this in Office 2003, the tabs come
across no matter which way I connect to Excel (DDE, OLEDB, ODBC). (They do
/not/ come across if I just copy/paste into Word, unless I use Edit|Paste
Special and choose, e.g. RTF formatted text rather than HTML format).

Peter Jamieson
"mike_mike" wrote in message
...
Hi

i standard letter with merge codes
{address}

Dear sir

These companies are in breach..
{mydata}

I want to all the following data into {mydata}
2005 tab Company 1
2006 tab company 2

I am merging from excel how do i get the tabs into word as they seem to be
turning to spaces? I do have them in the excel using char(9) in the source
data ..I do not want to use a list/catalog/directory merge just a standard
letter.





  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default putting tabs in a mail merge field?

OK, I have to be quick and will be offline for a few days:
a. Word mailmerge always needs a connection to a data source. If you are
not making it programmatically, then it was already set up in the Word
document.
b. In Word 2002, the default connection method would be OLEDB. Although my
tests here suggest the tabs should get through, my test data may be too
simple to reveal the problem.
c. It may be worth making the connection using one of the other methods -
in Word, check Tools|Options|General|"Confirm conversions at open", go
through the data source selection, and choose either DDE or ODBC when
offered. However, unfortunately you may also encounter problems related to
DDE or to the fact that the data source is already open.

If what you are actually doing is a "roll-your-own" merge where your Excel
VB code is placing data in the Word document, then that may be the source of
the problem. If you're doing that, I suggest you post a new message showing
the code you're using.

Peter Jamieson

"mike_mike" wrote in message
...
I'm using 2002 word and i'm not connecting to excel. I'm
running the word mail merge from excel VB code , and opening word up from
there..


"Peter Jamieson" wrote:

Which version of Word? When I try to do this in Office 2003, the tabs
come
across no matter which way I connect to Excel (DDE, OLEDB, ODBC). (They
do
/not/ come across if I just copy/paste into Word, unless I use Edit|Paste
Special and choose, e.g. RTF formatted text rather than HTML format).

Peter Jamieson
"mike_mike" wrote in message
...
Hi

i standard letter with merge codes
{address}

Dear sir

These companies are in breach..
{mydata}

I want to all the following data into {mydata}
2005 tab Company 1
2006 tab company 2

I am merging from excel how do i get the tabs into word as they seem to
be
turning to spaces? I do have them in the excel using char(9) in the
source
data ..I do not want to use a list/catalog/directory merge just a
standard
letter.







  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default putting tabs in a mail merge field?

I think that your bigger problem is going to be that you are appear to be
trying to perform a multiple items per condition mailmerge, which is
something that is not possible with a simple mailmerge. See the "Group
Multiple items for a single condition" item on fellow MVP Cindy Meister's
website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

or at:

http://www.knowhow.com/Guides/Compou...poundMerge.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

"mike_mike" wrote in message
...
Hi

i standard letter with merge codes
{address}

Dear sir

These companies are in breach..
{mydata}

I want to all the following data into {mydata}
2005 tab Company 1
2006 tab company 2

I am merging from excel how do i get the tabs into word as they seem to be
turning to spaces? I do have them in the excel using char(9) in the source
data ..I do not want to use a list/catalog/directory merge just a standard
letter.




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
Form Letter Mail Merge using field code: {Database} jyan Mailmerge 8 December 19th 05 09:18 PM
Mail Merge from Excel - conditional field choice? Gordon Smith \(eMVP\) Mailmerge 1 December 13th 05 05:18 AM
Field problems with Mail Merge Debbie Baker Mailmerge 1 December 8th 05 08:58 PM
Mail merge field generates MS WORD fault report Doug Robbins Mailmerge 0 October 5th 05 09:37 PM
Switch an image dynamically based on mail merge field - possible? Chris Hlusak Mailmerge 1 January 24th 05 11:11 PM


All times are GMT +1. The time now is 01:04 AM.

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

About Us

"It's about Microsoft Word"