how to create excel macro for linkedin message

**uppi** · 04-27-2012, 02:27 AM

Hi guys,

I am the new guy this forum from india.
I just want to know a simple macro which i am not familiar in excel macro or vba.

please I need a excel macro where it can open website links from column1 and copy column2 text to subject line in website link and then from column3 copy text into website message body.

i need it to be like this
column1= http://www.linkedin.com/msgToConns?d...onnId=27732683
column2= Need java developer, chicago, IL
column3= job description

I have attached a sample excel macro were i found on google.

please help me I am very much need at present.
sorry for bad english.

**AlvaroSiza** · 04-27-2012, 03:00 AM

This is merely designed to show a general approach, but is specific to LinkedIn.

In a blank workbook, enter the data as you originally specified in Cells A1 (WebAddress), B1 (Subject), and C1 (Msg Body).

Copy and Paste the following into a standard module and run it. You will see an instance of IE open, navigate to the URL (Cell A1), and place the Subject (B1) and Message (C1) into the web.

Please Login or Register  to view this content.

**uppi** · 04-27-2012, 03:26 AM

i need this with firefox. Please help.

**uppi** · 09-03-2012, 10:55 PM

Hi AlvaroSiza,

This script only pastes contents in the message. it does not click send button and close the current tab and switch to send message link. I need this to automate.

Thanks
uppi

**DavidCrompton** · 09-12-2012, 10:05 AM

Yep, that's what it does. Very clever as far as it goes but I want the same as you uppi. Also it opens a new instance of linkedin which needs a password. I want it to use my logged-in instance of linkedin, populate it from the spreadsheet, send it and move to the next record. Anyone out there who can help the pair of us. David