[mso] Re: create text file from column contents :VSMail mx3
- From: Cherie <msogroup@xxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Fri, 20 Aug 2004 11:57:56 -0400
I don't remember...and I can't duplicate it right now..I don't use
outlook..but it would say something like...semi colon won't work..try
comma..then I'd try comma and it would say comma won't work..try semi
colon...I was put in a loop..I looked up all the error messages on the
internet and MS KB...came up with nothing that would help..I might have
even posted on this group about it
..trust me..I spent about 10 hours trying to figure it out..finally gave
up...Outlook 2002 (?) would NOT accept two emails separated by anything..it
wants one at a time...I think I have a memo saved at work with the exact
messages..but I'll have to get it from work on Monday
in the mean time..I think I figured out how to automate the "export as txt"
thing with saved specs..but when I run the macro...it says "cannot update.
Database or object is read-only"..again..looking all over the internet and
MS KB tells me nothing that fixes this problem
I am running WinXP Pro..I am the only log on user and admin...the database
file itself does NOT have a read only tag on it..the folder it is in does
not...etc..I am not sure what else to check within Acess to UN stick the
read only (if this really is the problem..I think it is a random message
that spits out when MS has no clue what is going on)
anyway...how do I get rid of the message and get this macro to work??
thanks
C
It was 8/20/2004 when James LaBorde mentioned:
----------------------Begin Quote------------------------
>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
>*************************************************************
----------------------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
*************************************************************
Other related posts:
