VBA strFind, Outlook Contacts converted to Excel issue

[jvdherik010]

Hi Guys,

i had alot of help just reading this forum. its great to have excel masters in the world who are able to help..

well i have an issue.

I have imported all my contact details from my Microsoft Outlook, hence also the comments which are linked to that.
its now saved as an Excel 97-2003 file..

but.

there are alot of comments + a sort of coding to find certain contacts.

Jane Doe	FCNFOSNLRTM FCNMAINNLRTM FCNLRTMZADUR FCNLRTMUSLAX 12-09-2016 called 11-09-2016 email send etc etc
John Doe	FCNMAINNLRTM FCNLRTMCNSHA FZADURNLRTM 12-09-2016 called 11-09-2016 email send etc etc

<tbody>
</tbody>

so you see, every contact could have the same code as everybody else, but sometimes has another one extra.


i need to get above converted to only with an Vba or Macro:

<tbody>
</tbody>

Jane Doe	FCNMAINNLRTM	FCNFOSNLRTM	FCNLRTMZADUR	FCNLRTMUSLAX
John Doe	FCNMAINNLRTM	FCNLRTMCNSHA	FZADURNLRTM

<tbody>
</tbody>

many thanks guys for your help

 

[hiker95]

jvdherik010,

Welcome to the MrExcel forum.


We can not tell where your raw data is located, sheet name, cells, cell formatting, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, rows, columns.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[jvdherik010]

so sorry, and thanks for the heads up..

well here is the link
https://www.dropbox.com/s/ptqpf8gcss7q4gc/test.xls?dl=0


the thing is that these contacts note's need to be filtered, arranged and converted into a reasonable cell with just the code in each cell.

just for your information,
i am making a sort of invitation sheet which i need to send to 2500 contacts.
and with these codes i can determine which code gets another text or sort with verticall search, but i can figure that out myself.

but i also want him to make a pdf of a range, and send a email with standard text in the body through my microsoft outlook with this pdf as attachement.
and he needs to do that in a loop so each individual contact will get an email with there own invitation in a pdf..
( the emailadresses will be imported from contact lists from outlook.., so i can add that. and then it will be at cullumn "I"

i hope its a little bit clear
thanks so much for looking at it..

 

[hiker95]

but i also want him to make a pdf of a range, and send a email with standard text in the body through my microsoft outlook with this pdf as attachement.
and he needs to do that in a loop so each individual contact will get an email with there own invitation in a pdf..
( the emailadresses will be imported from contact lists from outlook.., so i can add that. and then it will be at cullumn "I"

jvdherik010,

I do not have any experience with PDF's, and, Outlook.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[jvdherik010]

Re: VBA BUMP Outlook Contacts converted to Excel issue

thanks for your reply