[SOLVED] Email Sheets to various contacts in PDF and also excel (but locked)


"Excel VBA Help"

 


Play Friv Now - Play Friv Games
Go Back   The Code Cage Forums > Microsoft Topics > Microsoft Excel Forum
Our Info Pages:-
The Code Cage - Microsoft Office help

Notices

Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc.

New Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 15th May 2014, 09:18
etaf's Avatar
etaf etaf is offline
Junior Member
MS Office Version: Ms Office 2010
MS Office Skill Level: Proficient with MS Office
 
Join Date: Nov 2009
Location: Surrey, UK
Posts: 10
Posts Per Day: 0.00
My Top Tip Count: 0
Thanks to others: 0
Thanked 0 Times in 0 Posts
Reputation: 10 (8) etaf is on a distinguished road
Great_Britain
Default Email Sheets to various contacts in PDF and also excel (but locked)
     Excel: VBA   


------ Register to get rid of these "In Post" ads! ------

Category: Excel: VBA   

Email Sheets to various contacts in PDF and also excel (but locked)
I'm asking for a friend, I'm helping to work on a spreadsheet with multiple sheets , that will then be emailed once a month, with different sheets going to different contacts.
because of our timezone difference, i may be slow to reply, so apologies in advance, BUT I will reply.

If a sheet could be used to maintain a list of contacts and which sheet to email out
Also in which format PDF, Excel (locked down) or both
would be useful.

A button maybe on the contact sheet to start the process / but also with an option to set-up to email on a certain day per month would be good

the number of contacts at the moment varies between 1 and 4 for each sheet - perhaps , we could set-up to email up to 10 contacts per sheet

The email client is Outlook , but will also be emailing out to other email services like gmail etc

Each contact should only receive their sheet and not see any of the other sheets , also the contacts should not be able to alter the spreadsheet at all. hence the possibility of using PDF , but most still would like to see the report in excel format.

there would be about 20 sheets , to go to between 1 and 10 contacts for each sheet

I have attached a dummy workbook , which has 4 example worksheets in

In the real workbook, the worksheet names , also will have spaces in them.

I could setup a Start Sheet and a finish sheet - so that the macro - can go through each worksheet in between , if that offers a solution
also a maintenance sheet which has the sheet name , email contacts email address and PDF, Excel or both format.

my knowledge of VBA is very rusty, as its was a few years ago I played with macros in any depth.

i have outlook on my PC , so i can play

thanks for any help

please ask for any further clarification , and I will do my best to provide any information required.
Attached Files To view attachments in this forum your post count must be 2 or greater. You currently have 0 posts.

The Code Cage Advertisment
Advertisement
  #2  
Old 16th May 2014, 03:24
Hennie Neuhoff's Avatar
Hennie Neuhoff Hennie Neuhoff is offline
Junior Member
MS Office Version: Ms Office 2010
MS Office Skill Level: Proficient with Excel
 
Join Date: Jun 2009
Location: South Africa
Age: 65
Posts: 116
Posts Per Day: 0.04
My Top Tip Count: 0
Thanks to others: 69
Thanked 1 Time in 1 Post
Reputation: 15 (10) Hennie Neuhoff is on a distinguished road
South_Africa
Default Re: Email Sheets to various contacts in PDF and also excel (but locked)

------ Register to get rid of these "In Post" ads! ------


Try Ron de Bruyn
http://msdn.microsoft.com/en-us/library/bb268022.aspx

disapprove this post: -5 Reputation
Reply & Quote Reply


  #3  
Old 16th May 2014, 06:54
RoyUK's Avatar
RoyUK RoyUK is offline
Administrator
Solution Centre Professional
MS Office Version: MS Office 2003, 2007, 2010
MS Office Skill Level: Proficient with MS Office
 
Join Date: Nov 2008
Location: Derbyshire, UK
Posts: 2,707
Posts Per Day: 0.83
My Top Tip Count: 4
Thanks to others: 2
Thanked 195 Times in 193 Posts
Reputation: 3320 (69) RoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond repute
4 Top Tips
England
Default Re: Email Sheets to various contacts in PDF and also excel (but locked)

------ Register to get rid of these "In Post" ads! ------


What have you tried so far? This is a complex project which in my opinion is a lot to expect from a free forum.
__________________
Hope that helps, RoyUK
For tips & examples visit free excel help
DatabaseForm
About me

The Code Cage Advertisment
Advertisement
  #4  
Old 16th May 2014, 10:40
Hennie Neuhoff's Avatar
Hennie Neuhoff Hennie Neuhoff is offline
Junior Member
MS Office Version: Ms Office 2010
MS Office Skill Level: Proficient with Excel
 
Join Date: Jun 2009
Location: South Africa
Age: 65
Posts: 116
Posts Per Day: 0.04
My Top Tip Count: 0
Thanks to others: 69
Thanked 1 Time in 1 Post
Reputation: 15 (10) Hennie Neuhoff is on a distinguished road
South_Africa
Default Re: Email Sheets to various contacts in PDF and also excel (but locked)

------ Register to get rid of these "In Post" ads! ------


I may a suggestion for pointers to etaf. I didn't ask for snotty remarks like you usually give. Typically an arrogant pommie!

Reply & Quote Reply


1 members found this post helpful.
  #5  
Old 16th May 2014, 11:39
RoyUK's Avatar
RoyUK RoyUK is offline
Administrator
Solution Centre Professional
MS Office Version: MS Office 2003, 2007, 2010
MS Office Skill Level: Proficient with MS Office
 
Join Date: Nov 2008
Location: Derbyshire, UK
Posts: 2,707
Posts Per Day: 0.83
My Top Tip Count: 4
Thanks to others: 2
Thanked 195 Times in 193 Posts
Reputation: 3320 (69) RoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond repute
4 Top Tips
England
Default Re: Email Sheets to various contacts in PDF and also excel (but locked)

------ Register to get rid of these "In Post" ads! ------


Hennie

What's your problem?
__________________
Hope that helps, RoyUK
For tips & examples visit free excel help
DatabaseForm
About me

  #6  
Old 16th May 2014, 13:06
RoyUK's Avatar
RoyUK RoyUK is offline
Administrator
Solution Centre Professional
MS Office Version: MS Office 2003, 2007, 2010
MS Office Skill Level: Proficient with MS Office
 
Join Date: Nov 2008
Location: Derbyshire, UK
Posts: 2,707
Posts Per Day: 0.83
My Top Tip Count: 4
Thanks to others: 2
Thanked 195 Times in 193 Posts
Reputation: 3320 (69) RoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond repute
4 Top Tips
England
Default Re: Email Sheets to various contacts in PDF and also excel (but locked)

------ Register to get rid of these "In Post" ads! ------


Hennie

You are quick to spout abuse but not explain why!!!

1. My reply was not directed to you and so I can't see why you needed to respond
2. Your reply to the question was merely a link to another site.
3. I have replied to one of your questions with a question. You did not even reply. In fact you have other questions that you haven't replied to where solutions have been offered. At your age you should know how to user "Thank you"
4. You said -"I didn't ask for snotty remarks like you usually give." I have provided thousands of solutions over the years. I have never been accused of snotty remarks. In fact I have acted as Moderator and Admin at three of the major Excel Forums. In fact I did not give you a remark of any kind!
5.You said - "Typically an arrogant pommie!" - rude, unnecessary and racist. Considering you state you live in South Africa I am surprised you would make such a racist comment.
__________________
Hope that helps, RoyUK
For tips & examples visit free excel help
DatabaseForm
About me

The Code Cage Advertisment
Advertisement
  #7  
Old 16th May 2014, 13:39
etaf's Avatar
etaf etaf is offline
Junior Member
MS Office Version: Ms Office 2010
MS Office Skill Level: Proficient with MS Office
 
Join Date: Nov 2009
Location: Surrey, UK
Posts: 10
Posts Per Day: 0.00
My Top Tip Count: 0
Thanks to others: 0
Thanked 0 Times in 0 Posts
Reputation: 10 (8) etaf is on a distinguished road
Great_Britain
Default Re: Email Sheets to various contacts in PDF and also excel (but locked)

------ Register to get rid of these "In Post" ads! ------


Thanks for the link, for some strange reason, even though I'm set as subscribed , I have not received any email notifications

I will go and have a look at Ron de Bruyn link

cheers

  #8  
Old 16th May 2014, 15:13
RoyUK's Avatar
RoyUK RoyUK is offline
Administrator
Solution Centre Professional
MS Office Version: MS Office 2003, 2007, 2010
MS Office Skill Level: Proficient with MS Office
 
Join Date: Nov 2008
Location: Derbyshire, UK
Posts: 2,707
Posts Per Day: 0.83
My Top Tip Count: 4
Thanks to others: 2
Thanked 195 Times in 193 Posts
Reputation: 3320 (69) RoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond repute
4 Top Tips
England
Default Re: Email Sheets to various contacts in PDF and also excel (but locked)

------ Register to get rid of these "In Post" ads! ------


It's Ron de Bruin

This page has various bits code on to email & convert tp pdf

http://www.rondebruin.nl/win/section1.htm
__________________
Hope that helps, RoyUK
For tips & examples visit free excel help
DatabaseForm
About me

  #9  
Old 20th May 2014, 18:28
etaf's Avatar
etaf etaf is offline
Junior Member
MS Office Version: Ms Office 2010
MS Office Skill Level: Proficient with MS Office
 
Join Date: Nov 2009
Location: Surrey, UK
Posts: 10
Posts Per Day: 0.00
My Top Tip Count: 0
Thanks to others: 0
Thanked 0 Times in 0 Posts
Reputation: 10 (8) etaf is on a distinguished road
Great_Britain
Default Re: Email Sheets to various contacts in PDF and also excel (but locked)

------ Register to get rid of these "In Post" ads! ------


I managed to get a basic email going now , with most of what i needed
Protect sheet email to a distribution list
The link provided most of the info i needed
so now to start customising a little - but otherwise all OK

thanks for the link

The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!

  #10  
Old 21st May 2014, 07:21
RoyUK's Avatar
RoyUK RoyUK is offline
Administrator
Solution Centre Professional
MS Office Version: MS Office 2003, 2007, 2010
MS Office Skill Level: Proficient with MS Office
 
Join Date: Nov 2008
Location: Derbyshire, UK
Posts: 2,707
Posts Per Day: 0.83
My Top Tip Count: 4
Thanks to others: 2
Thanked 195 Times in 193 Posts
Reputation: 3320 (69) RoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond repute
4 Top Tips
England
Default Re: Email Sheets to various contacts in PDF and also excel (but locked)

------ Register to get rid of these "In Post" ads! ------


Post back with any problems adapting the code.
__________________
Hope that helps, RoyUK
For tips & examples visit free excel help
DatabaseForm
About me

The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!

New Reply
The Code Cage at Facebookhe Code Cage at Twitter


Tags
contacts, email, excel, locked, pdf, sheets

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

The Code Cage Affilliates



http://www.thecodecage.com/forumz tested by McAfee Security http://www.thecodecage.com/forumz tested by McAfee Security

All times are GMT +1. The time now is 16:00.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Template-Modifications by TMS
No part of this board, functionality or creatives may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
Copyright ©2008 - , Simon lloyd.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
UA-8135493-1
Cultural Forum | Study at Malaysian University
X vBulletin 3.8.7 Debug Information
  • Page Generation 0.22673 seconds
  • Memory Usage 6,665KB
  • Queries Executed 18 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footerEnd
  • (1)ad_footerStart
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_headerEnd
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_leftcolumn_code
  • (1)ad_navbar_below
  • (5)ad_postbit_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (10)helpful_answers
  • (1)helpfulanswers_javascript
  • (1)navbar
  • (3)navbar_link
  • (2)navbar_noticebit
  • (41)option
  • (10)post_thanks_box
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_attachment
  • (10)postbit_ctoptip
  • (10)postbit_onlinestatus
  • (60)postbit_reputation
  • (10)postbit_wrapper
  • (1)showthread_changepostsowner_link
  • (1)showthread_extra_fields
  • (1)showthread_quickreply_mrgdp
  • (1)showthread_reason_popup
  • (1)spacer_close
  • (1)spacer_open
  • (1)su_form
  • (6)tagbit
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_datastore.php
  • ./includes/class_hook.php
  • ./awcoding/plugins/awc.php
  • ./awcoding/plugins/ds.php
  • ./awcoding/plugins/ss.php
  • ./includes/functions_notice.php
  • ./mobiquo/smartbanner.php
  • ./mobiquo/include/classTTConnection.php
  • ./mobiquo/smartbanner/head.inc.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/vbatags.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php
  • ./includes/functions_misc.php 

Hooks Called:
  • init_startup
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_check_criteria
  • notices_noticebit
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • helpfulanswers_showthreadorpost
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • helpfulanswers_show_normal
  • reputation_power
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • error_fetch
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete