Normal Topic Export is not allowing Mail Merge (Read 508 times)
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Export is not allowing Mail Merge
Sep 25th, 2005 at 5:29pm
Print Post Print Post  
Hi -

I have had the most awful time for two days now, trying to perform what I consider a very simple and "routine" function.

I retrieved a group of records, set up my export specs and exported the data to a file.

I then opened an MS Word merge document to complete the merge and I kept getting errors in almost every record.

Finally, I opened the exported file, set Word to reveal paragraph marks and found there were only a few.

I read the manual several times and overlooked this one (very clear) sentence:

Quote:
Make sure to give the file a .txt extension.


From "old" habit I had been saving the file with a .asc extention.  When I changed the export file name to include a .txt extension, it worked like a charm ...

So, I simply wanted to pass this along in case anyone else makes a similar mistake.  
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Export is not allowing Mail Merge
Reply #1 - Sep 26th, 2005 at 12:03pm
Print Post Print Post  
Spencer,

Sesame does not change the export behavior based on the file extension. Exporting to .asc and exporting to .txt will get you the exact same export file.

Word, however, may make different decisions about how to interpret the file based on its extension.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Export is not allowing Mail Merge
Reply #2 - Sep 26th, 2005 at 4:46pm
Print Post Print Post  
Erika -

Thanks for clarifying the "why" of the problem and I imagine that you're right about it being an MS Word issue.  The interesting part is that I nearly always performed mail merges in Word and the file extension of either .txt or .asc was never a problem. 

In any event, it's a mistake that I won't make again.   Smiley
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged