Replies

Fantastic. Thank you.

Fantastic. Thank you.

(Edited by Don_Sadler on 18-Sep-03 12:00. To further explain the automated repetition desired.)

I always want to transpose it three cells to the right of the selected cell. Sorry, I should have mentioned it. Your code works beautifully. Is there a way to automate it so it will continue until there is no more data?

I have added code to move the active cell to the next starting point so I can execute the macro again. This works well but each starting cell should contain the entry “Name:” without the quotes. I would like the macro to continue until the cell does not contain “Name:”

(Edited by Don_Sadler on 18-Sep-03 12:00. To further explain the automated repetition desired.)

I always want to transpose it three cells to the right of the selected cell. Sorry, I should have mentioned it. Your code works beautifully. Is there a way to automate it so it will continue until there is no more data?

I have added code to move the active cell to the next starting point so I can execute the macro again. This works well but each starting cell should contain the entry “Name:” without the quotes. I would like the macro to continue until the cell does not contain “Name:”

Dave, thanks to your request, my problem is solved. I was trying to figure out what you actually wanted a screen shot of since the SMTP settings were the same. As I was examining each screen trying to determine what you needed that was different from I described, I realized that in Account 1, I spelled “adelphia” correctly but in Account 2, I spelled it “adlephia”. Obviously that was why it didn’t work. I corrected it and I am now happy. I need to go wash the egg off my face now. Thanks again for your patience and cheerful persistence.

Dave, thanks to your request, my problem is solved. I was trying to figure out what you actually wanted a screen shot of since the SMTP settings were the same. As I was examining each screen trying to determine what you needed that was different from I described, I realized that in Account 1, I spelled “adelphia” correctly but in Account 2, I spelled it “adlephia”. Obviously that was why it didn’t work. I corrected it and I am now happy. I need to go wash the egg off my face now. Thanks again for your patience and cheerful persistence.

Thanks for the reply, Dave. In fact, that IS the problem – I do have exact same settings for outgoing SMTP for both accounts – the same ISP server. That is why I am confused. Outlook will connect to my ISP SMTP server for Account 1 but will not connect for Account 2 despite the fact that it is the same server with the same settings.

Thanks for the reply, Dave. In fact, that IS the problem – I do have exact same settings for outgoing SMTP for both accounts – the same ISP server. That is why I am confused. Outlook will connect to my ISP SMTP server for Account 1 but will not connect for Account 2 despite the fact that it is the same server with the same settings.

I often run into this problem so here are three notes I made to which I often refer. You may need to adjust them to meet your needs but there are written “conceptually”:
==================================================
Excel – last name sort

Put the names in a spreadsheet starting in A1. Then, place the formula below in B1 and replicate it all the way down until the last name in the list is covered.

=RIGHT(A1, LEN(A1)-FIND(” “, A1))

When the all the names have been done, select all the full names and all the last names. Then, choose (from the menu) Data, Sort. Sort on column B.
================================================
Excel – lastname, firstname -> firstname lastname

Put the names in a spreadsheet starting in A1. Then, place the formula below in B1 and replicate it all the way down until the last name in the list is covered.

=RIGHT(A1, LEN(A1)-FIND(” “, A1))&” “&LEFT(A1, FIND(“,”, A1)-1)
=============================================================
Excel – lastname, firstname -> lastname firstname (two columns)

Put the names in a spreadsheet starting in A1. Then, place the formulas below in B1 and B2 then replicate them all the way down until the last name in the list is covered.

B1 =LEFT(A1, FIND(“,”, A1)-1)

B2 =RIGHT(A1, LEN(A1)-FIND(” “, A1))

I often run into this problem so here are three notes I made to which I often refer. You may need to adjust them to meet your needs but there are written “conceptually”:
==================================================
Excel – last name sort

Put the names in a spreadsheet starting in A1. Then, place the formula below in B1 and replicate it all the way down until the last name in the list is covered.

=RIGHT(A1, LEN(A1)-FIND(” “, A1))

When the all the names have been done, select all the full names and all the last names. Then, choose (from the menu) Data, Sort. Sort on column B.
================================================
Excel – lastname, firstname -> firstname lastname

Put the names in a spreadsheet starting in A1. Then, place the formula below in B1 and replicate it all the way down until the last name in the list is covered.

=RIGHT(A1, LEN(A1)-FIND(” “, A1))&” “&LEFT(A1, FIND(“,”, A1)-1)
=============================================================
Excel – lastname, firstname -> lastname firstname (two columns)

Put the names in a spreadsheet starting in A1. Then, place the formulas below in B1 and B2 then replicate them all the way down until the last name in the list is covered.

B1 =LEFT(A1, FIND(“,”, A1)-1)

B2 =RIGHT(A1, LEN(A1)-FIND(” “, A1))

I, too, am out of my element but want to offer this idea. I suspect that there may be either an OS, CMOS, or H/W setting(s) where you can choose between static or dynamic ne#’s. Obviously, the OS is able to distinguish between printers regardless of the NE# so this ability must be available to the developer/user. Then, again, I could be (am probably) wrong.

I, too, am out of my element but want to offer this idea. I suspect that there may be either an OS, CMOS, or H/W setting(s) where you can choose between static or dynamic ne#’s. Obviously, the OS is able to distinguish between printers regardless of the NE# so this ability must be available to the developer/user. Then, again, I could be (am probably) wrong.

I guess I should have been more clear in my posting. I know I can add to the text in the text box but I have developed many verses that I would like to have included in the wizard so that I can select my customized verses and have the text boxes automatically filled with my verses instead of having to manually type it in.

It may have been clearer if I had said “add verses to the wizard”.

Thanks to all – that did the trick. It is certainly a relief to not have those messages.

Mark, my question is off topic but how do you insert that graphic (the MS Office setup message box) into a post? When I have wanted to insert a graphic, I only seem to have the option of attaching a file. Thanks, Don