[mso] Re: create text file from column contents :VSMail mx3
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Fri, 20 Aug 2004 08:45:30 -0700
Cherie,
What error did you get with the semicolon?
James
-----Original Message-----
From: Cherie [mailto:msogroup@xxxxxxxxxxx]
Sent: Thursday, August 19, 2004 3:40 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: create text file from column contents :VSMail mx3
James
I tried the semicolon, and everything else I could think of
I worked WAY too long on it..it SHOULD work (even MS help file says it
will)..but it does NOT work for us (it would say "try a semicolon" if I
used a tab or space or colon..and if I used a semicolon..it gave another
error message...forgot how it went)
..we never figured out why..I moved on (it works flawlessly in Eudora)
soo.....with that said...my specs are saved..how do I create a macro for
this?
thanks
Cherie
It was 8/19/2004 when James LaBorde mentioned:
----------------------Begin Quote------------------------
>Cherie,
>
>Try a semicolon. Outlook likes semicolons rather than commas. As for
>automating it. Once you have your specs down and saved, you can create a
>macro that you can run at the touch of a button to accomplish it.
>
>James
>
>-----Original Message-----
>From: Cherie [mailto:msogroup@xxxxxxxxxxx]
>Sent: Thursday, August 19, 2004 3:11 PM
>To: mso@xxxxxxxxxxxxx
>Subject: [mso] Re: create text file from column contents mx3 :VSMail mx4
>
>
>I am too quick with the send button..Ok..I got the file to export the way
I
>want it to..but..it's just as fast for me to go to the query...copy the
>column and paste it into notepad (which is what I was doing)
>I need to automate this..but..I found another problem:
>
>I need the contents of TWO columns put into a text file (preferably in
>alphabetical order)
>when I tried this..it lists the records with TWO email addresses as
>email1@xxxxxxxxx, email2@xxxxxxxxx
> I want one under the other..not two separated by a comma....
>Outlook is suppose to accept it with a comma in between..but it does not
>thanks
>C
>
>It was 8/19/2004 when James LaBorde mentioned:
>----------------------Begin Quote------------------------
> >Cherie,
> >
> >Try this:
> >
> >- Right Click your table and select Export. In the Save As Type change
>this
> >to Text Files (You will need to scroll down a little to find it)
> >- You will now get a wizard that runs. The first option that appears is
>to
> >save as delimited or fixed.
> >- Rather than select one of those, click on the Advanced button in the
>lower
> >left hand corner.
> >- The current Export Specifications will now pop up.
> >- Since you do not want any extra information in your text file, select
> >fixed. This will remove the quotes you ended up with.
> >- Verify that the lengths indicated are appropriate at the bottom of
this
> >window. Click the Save As button and it will allow you to save these
> >specifications.
> >- Click on Okay. This will take you back to the original wizard, but
your
> >options are now set for you.
> >- Click Finish and the table will be exported in a format that should be
> >more to your liking.
> >
> >Once you get that done we can go over how to automate it. Let me know
how
> >this works out for you.
> >
> >James
> >
> >-----Original Message-----
> >From: Cherie [mailto:msogroup@xxxxxxxxxxx]
> >Sent: Thursday, August 19, 2004 2:49 PM
> >To: mso@xxxxxxxxxxxxx
> >Subject: [mso] Re: create text file from column contents mx3 :VSMail mx4
> >
> >
> >It was 8/19/2004 when James LaBorde mentioned:
> >----------------------Begin Quote------------------------
> > >Cherie,
> > >
> > >If all you need is a text file, simply go to the table, right click it
>and
> > >select Export. If you change the Save As Type to Text Files, you can
> > >customize how it will come out in the text file.
> >
> >James,
> >How do I customize how it will come out??? the only option I have for
txt
> >is "Microsoft Word Merge"..and it comes out with all the addresses
> >surrounded by quotation marks (and the column name on the top..which I
> >don't need)
> >
> >once you have your layout
> > >complete, you can save the specs. Then just export to text in the
>future
> > >using the same specs (You can automate this part).
> >
> >what do you mean by save specs? and how do I automate it??
> >thanks
> >Cherie
> >
> > >
> > >James
> >----------------------End Quote------------------------
> >
> >*************************************************************
> >You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or
> >MicrosoftOffice@xxxxxxxxxxxxxxxx
> >
> >To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> >
> >To Unsubscribe from this group, send an email to
> >mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes)
> >in the subject line.
> >
> >Or, visit the group's homepage and use the dropdown menu. This will
also
> >allow you to change your email settings to digest or vacation (no mail).
> >//www.freelists.org/webpage/mso
> >
> >To be able to use the files section for sharing files with the group,
send
>a
> >request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation
> >with instructions. Once you are a member of the files group, you can go
> >here to upload/download files:
> >http://www.smartgroups.com/vault/msofiles
> >*************************************************************
> >*************************************************************
> >You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or
> >MicrosoftOffice@xxxxxxxxxxxxxxxx
> >
> >To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> >
> >To Unsubscribe from this group, send an email to
> >mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes)
> >in the subject line.
> >
> >Or, visit the group's homepage and use the dropdown menu. This will
also
> >allow you to change your email settings to digest or vacation (no mail).
> >//www.freelists.org/webpage/mso
> >
> >To be able to use the files section for sharing files with the group,
send
>a
> >request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation
> >with instructions. Once you are a member of the files group, you can go
> >here to upload/download files:
> >http://www.smartgroups.com/vault/msofiles
> >*************************************************************
>----------------------End Quote------------------------
>---Thanks,
>Cherie
>
>*************************************************************
>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
>MicrosoftOffice@xxxxxxxxxxxxxxxx
>
>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
>To Unsubscribe from this group, send an email to
>mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
>in the subject line.
>
>Or, visit the group's homepage and use the dropdown menu. This will also
>allow you to change your email settings to digest or vacation (no mail).
>//www.freelists.org/webpage/mso
>
>To be able to use the files section for sharing files with the group, send
a
>request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
>with instructions. Once you are a member of the files group, you can go
>here to upload/download files:
>http://www.smartgroups.com/vault/msofiles
>*************************************************************
>*************************************************************
>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
>MicrosoftOffice@xxxxxxxxxxxxxxxx
>
>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
>To Unsubscribe from this group, send an email to
>mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
>in the subject line.
>
>Or, visit the group's homepage and use the dropdown menu. This will also
>allow you to change your email settings to digest or vacation (no mail).
>//www.freelists.org/webpage/mso
>
>To be able to use the files section for sharing files with the group, send
a
>request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
>with instructions. Once you are a member of the files group, you can go
>here to upload/download files:
>http://www.smartgroups.com/vault/msofiles
>*************************************************************
----------------------End Quote------------------------
---Thanks,
Cherie
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
